10

Working with Data Using Entity Framework Core

This chapter is about reading from 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 in a .NET project
  • Defining EF Core models
  • Querying EF Core models
  • Loading and tracking patterns with EF Core
  • Modifying 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 SQL Server, PostgreSQL, MySQL, and SQLite, or in a NoSQL database, such as Azure Cosmos DB, Redis, MongoDB, and Apache Cassandra.

Get C# 12 and .NET 8 – Modern Cross-Platform Development Fundamentals - Eighth 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.