This is a .NetCore API to show how i would create an API for a database.
Technologies and languages used:
-.NetCore 3.1
-swashbuckler (swagger)
-AutoMapper.
-Azure KeyVault to securly store AppSetings.
-Azure Devops CI/CD (Yaml Build Definition).
-EntityframeworkCore.
-Azure Sql Server database.
The database is a sample from microsoft. AdventureWorks Sql Database
- Select the AdventureWorks.Database file and run a "Schema compare..."
- select the location you would like to recreate the database.
- Right click on the AdventureWorks.Api project
- Click on "Manage User Secrets"
- Add in the connection string to the database you have created like so:
"ConnectionString": {
"AdventureWorksDbContext": "{ConnectionString}"
}