To create DotnetCore 3.1 project with MSSQL without the EF and Dapper. Project is all about to create and manage the Recipe.
Database have five tables;-
- User
- Dish Category
- Dish it self
- Ingredients
- Recipe
Every User have there own Dish Category, Dish, Ingredients and Recipes. But user can look other users recipes as well.
You must have / install dotnet core 3.1 and MSSQL Server 18 on your machine
- Clone this Repository and Extract it to a Folder.
- Create database name 'GoodFoodDB', using Microsoft SQL Server Management studio, or any other way
- Change the Connection Strings for in the API/appsettings.json
- Run the following command on Powershell in Main directory (Not API)
- dotnet restore
- Run the command in API/
- dotnet run or dotnet watch run