ASP.NET 6 MVC with Entity Framework Core 6 - demo app with Blazor Server components

This solution is one take at migrating a layered architecture MVC web app to "Clean Architecture" using a practical approach that preserves as much existing code as possible, while making it possible for future development to use Clean Architecture.

The code for the starting point of this endeavour can be found in GitHub here.

See "Clean Architecture and related Resource Links" below for some of the materials I read before attempting this work.

A parallel solution using .NET Core 3.1 can be found in GitHub here.

Dev Notes

Create your local database(es) and use the SQL scripts:
...\SqlScripts\Schema\CU6_M01_ExistingSchemaBase_2022_idempotent.sql
...\SqlScripts\Schema\CU6_M02_AddEnrollment_idempotent.sql
to create the tables for the database used for migrations.

Use the SQL scripts:
...\SqlScripts\Schema\CU6_M01_ExistingSchemaBase_2022.sql
...\SqlScripts\Schema\CU6_M02_AddEnrollment.sql
...\SqlScripts\Schema\CU6_M03_AddCourseInstructorLink.sql
to create the tables for the database used for integration tests and the web app.

Copy ...\_ConfigSource\src\ContosoUniversity\appsettings.Development_user_xxxx.json to ...\src\ContosoUniversity replacing "xxxx" in the file name with the username of the account from which you are running Visual Studio, and update the paths in the file to match your solution path. Also, and correct connection string for your environment.

Update paths for internalLogFile and var_logdir in appsettings.Development_user_... after you copy and rename it.

Copy ...\_ConfigSource\src\CU.EFDataApp\appsettings.migrations.json to ...\src\CU.EFDataApp and modify connection string for your environment.

Copy ...\_ConfigSource\src\tests\CU.ApplicationIntegrationTests\appsettings.LocalTesting.json to ...\src\tests\CU.ApplicationIntegrationTests and modify connection string for your environment.

Blazor Resource Links
Clean Architecture and related Resource Links
EF Core 6 Resources
Logging Resources
Other Resources
Tools

Set connection string in ...\src\tests\CU.ApplicationIntegrationTests\appsettings.LocalTesting.json for the database you want to seed.

Run a single test that uses GetISchoolDbContext (e.g. CanGetCoursesAsync()).

See code in TestFixture.GetISchoolDbContext(ITestOutputHelper testOutputHelper) for more information.