You’re halfway through this course now. We’ve spent most of our time in this half working in Visual Studio, and you’ve learned a lot about database integration in .NET Core with Entity Framework. Here are just a few of the things you’ve done so far:
You’ve been introduced to object-relational mapping and Entity Framework Core, and you’ve learned that there are many alternative ORMs available for .NET if Entity Framework is not what you want to use.
You’ve designed and coded a complete model for your recipes database, and you’ve performed a code-first migration that created the database, all the tables, and their relationships, all from the code you wrote.
You updated your model classes with other changes and performed an additional migration to translate those changes to the database.
You used the SQL Server Data Import and Export tool to populate a database with sample data so you could test your queries.
And finally, you’ve written several queries for execution in C# using both SQL and LINQ, and you’ve placed them inside controller actions that return the query results as JSON objects.
That’s a lot of work so far!
After a quick quiz to check what you’ve learned, we’ll look at a different approach to building data models for your MVC projects. In the second half of this course, you’re going to learn a lot about SQL Server Management Studio (SSMS), and you’re going to do the reverse of code-first migrations as you generate a C# data model using database-first integration.