In this chapter, we have learned how to use Entity Framework Core 3 with ASP.NET Core 3 in order to work with SQL Server databases.

We have seen how to use a database context and connection string to connect to a SQL Server database. Then, we updated the models in the Tic-Tac-Toe application with primary and foreign key definitions by using Entity Framework Core 3 Data Annotations, and by overriding the OnModelCreating method within the database context.

We worked with Entity Framework Core 3 migrations to constantly keep the models in our code consistent with their corresponding database representations.

Furthermore, we learned how to insert, update, and query data in an easy, productive, and efficient way. We have also learned how to query databases using the Fluent API and how to use transactions.

In the next chapter, we will talk about how to secure access to our ASP.NET Core 3 applications using ASP.NET Core 3's integrated authorization features.