NET 6 - Introduction
NET 6 - Install Software & SDK
NET 6 - Projects
NET 6 - Create Projects
NET 6 - MVC - Project Structure
NET 6 - Razor Pages - Project Structure
NET 6 - Web API - Project Structure
NET 6 - Entities
NET 6 - Interfaces and Services
NET 6 - Setup Entity Framework
NET 6 - Dependency Injection
NET 6 - Model
NET 6 - Service/Business Layer
NET 6 - MVC - Controller
NET 6 - MVC - View
NET 6 - Razor Page
NET 6 - API
NET 6 - Logging
NET 6 - Self Hosting
NET 6 - Tag Helper

NET 6 - Setup Entity Framework

Last modified: June 21, 2021
< Interfaces and Services
Dependency Injection >
Create Database

sql sql sql

Repeat it for MVC, Razor Page and WebApi
Configure appsettings.json

Since we are database running on our computer (i.e. localhost) and our database name is Event, hence we set up as below

"DefaultConnection": "Server=localhost;Database=Event;Trusted_Connection=True;MultipleActiveResultSets=true"

sql

Configure startup.cs
builder.Services.AddDbContext<TicketingDbContext>(options => options.UseSqlServer(connectionString));

sql

Migrations

Create migration file for EventContext

Add-Migration InitialCreate -Context EventContext -OutputDir Migrations\SqlServerMigrations

Peform migration to create table for identity models (i.e. ApplicationDbContext)

Update-Database -Context ApplicationDbContext

Peform migration to create table for Event and EventBooking models

Update-Database -Context TicketingDbContext
< Interfaces and Services
Dependency Injection >