We will query the Book table in our SQL Express database:
- First, we will create three folders: Controllers, Models, and Views.
- Next, we add the following NuGet packages to the dependencies to the project:
"Microsoft.AspNetCore.Server.IISIntegration","Microsoft.AspNetCore.Server.Kestrel","Microsoft.AspNetCore.Mvc","Microsoft.AspNetCore.Razor.Tools","Microsoft.Extensions.Configuration.EnvironmentVariables","Microsoft.Extensions.Configuration.Json","System.Data.Common","System.Data.SqlClient","Dapper"
- Next, let's create an appsettings.config file to add our database connection string and add the following code:
{ "ConnectionStrings": { "CookBookConnection": "Data Source=PC-HOME\\SQLEXPRESS;Initial Catalog=CookBook;Integrated ...
