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

• .NetCore
• Dapper
• Swagger
• Automapper

• 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.