10

Working with Data Using Entity Framework Core

This chapter is about reading and writing to relational data stores, such as SQLite and SQL Server, 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
  • Modifying data with EF Core
  • Working with transactions
  • Code First EF Core models (online section)

Understanding modern databases

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

Get C# 11 and .NET 7 – Modern Cross-Platform Development Fundamentals - Seventh Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.