Skip to content

A sample CRUD project demonstrates the process of Azure Function using EntityFramework Core to operate the Azure SQL database.

Notifications You must be signed in to change notification settings

chenjd/AzureFunction.UserCRUD

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

AzureFunction.UserCRUD

Build status

A sample CRUD project demonstrates the process of Azure Function using EntityFramework Core to operate Azure Sql database.

Create a User data

Create a new user data in the sql database.

POST /api/create

Parameters

Name Type Description
name string Required. The user's name.
password string Required. The user's password.

Example for creating a user

{
    "name": "lydia",
    "password": "password"
}

Response

user is created, the id is xxx

Get a User data

Get a user data from the sql database.

GET /api/read/:userid

Response

{
  "id": "fc78c67e-cf6a-4335-ae9c-7ac8459dbc2e",
  "name": "lydia",
  "password": "password"
}

Get a Users List

Get a users list from the sql database.

GET /api/list

Response

[
    {
        "id": "f560927e-4564-456f-aceb-35aa32cf7c08",
        "name": "susan",
        "password": "password"
    },
    ...
]

Update a User data

Update a existing user data in the sql database.

PUT /api/update/:userid

Parameters

Name Type Description
name string Required. The user's name.
password string Required. The user's password.

Delete a User data

Delete a user data in the database.

DELETE /api/delete/:userid

Blog Post

Using VS Code To Build An Azure Function And SQL Database App With .Net Core On Azure Cloud

CI/CD For Azure Functions App By Using GitHub And Azure DevOps

About

A sample CRUD project demonstrates the process of Azure Function using EntityFramework Core to operate the Azure SQL database.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Sponsor this project

 

Packages

No packages published

Languages