Microsoft released a sample database which can be used to explore and practice using the various features of Sql Server. Adventure Works is a fictitious, multinational bicycle manufacturing company. The database is an enterprise solution which covers Sales/Marketing, Product, Purchasing/Vendor and Manufacturing scenarios.
At work we have started moving towards a standard .NET application architecture for most of our apps. This uses MVC 5 website with a REST client talking to a Web API 5. When you open a visual studio solution, as a minimum you see the following projects...
I while ago, I posted about setting up Entity Framework 6 Code First migrations in an MVC 5 Project. These days, its all about dotnet core, and whilst the process is very similar, I thought I would write another detailed walk through so that I can hit the ground running when I'm required to do this working on real projects.