How I setup my .NET 6 API and connect to a local MSSQL server running in Docker.

I base a lot of the code on Jason Taylor’s Clean Architecture template.

00:00 Intro
00:12 Prerequisites
00:33 Project setup
02:02 Docker
11:18 MSSQL root
13:15 ConnectionStrings
15:00 Database layer
17:55 Entity framework
25:10 First migration
28:10 Model overrides
31:58 Identity framework
37:25 Extend IdentityUser
40:57 Seeding UserRoles

#csharp #dotnet #entityframework #identityframework #mssqlserver #mssql #cleanarchitecture #authentication #api #development #local #web #fullstack #webdevelopment