Build a fully functional, cloud-ready, and professional Web Api using the latest features in the .NET Core 5.0 and MySQL '8.0.25' as your database management system.
- Fully async for better scalability
- Using Dapper instead of Entity Framework
- Token Protection / Route Protection using security
- Pagination using dapper
- cd into cloned repo
- Run the script located at Scripts/database_scripts.sql
- Once database is created and schema has been generated you need to add a SQL Login and make sure it is granted permissions for read/write to DNSeed database.
- Open Visual Studio 2019, open Solution and build
- Otherwise you can run: dotnet restore
- Followed by: dotnet run
- If running in Development mode you need to edit appsettings.Development.json Make sure you update connectionString accordingly => SQL Login
- If running in Production mode you need to edit appsettings.Production.json Make sure you update connectionString accordingly => SQL Login
- Once the site is running, it will load up Swagger endpoint, from here you can test login feature.
- The provided Scripts/database_scripts.sql file, adds a user: demo2 / demo2_Sup3rPwd
- Once logged in, grab the token and modify Swagger to use given token.
- Start adding/editing products.