C# 8.0 and .NET Core 3.0 – Modern Cross-Platform Development - Fourth Edition

Chapter 11

Working with Databases Using Entity Framework Core

This chapter is about reading and writing to data stores, such as Microsoft SQL Server, SQLite, and Azure Cosmos DB, by using the object-to-data store mapping technology named Entity Framework Core (EF Core).

This chapter will cover the following topics:

• Understanding modern databases
• Setting up EF Core
• Defining EF Core models
• Querying EF Core models
• Loading patterns with EF Core
• Manipulating data with EF Core

Understanding modern databases

Two of the most common places to store data are in a Relational Database Management System (RDBMS) such as Microsoft SQL Server, PostgreSQL, MySQL, and SQLite, or in a NoSQL data store such as Microsoft Azure Cosmos DB, Redis, MongoDB, and Apache ...