• 6 hours
  • Medium

Free online content available in this course.

course.header.alt.is_video

course.header.alt.is_certifying

Got it!

Last updated on 11/15/19

Part 1 Summary

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. 

Example of certificate of achievement
Example of certificate of achievement