Chapter 8. Working with Databases Using the Entity Framework Core

This chapter is about reading and writing to databases, such as Microsoft SQL Server and SQLite, using the object-relational mapping technology known as the Entity Framework Core.

This chapter will cover the following topics:

  • Relational Database Management Systems
  • Using Microsoft SQL Server on Windows
  • Using SQLite on macOS and mobile platforms
  • Setting up Entity Framework Core
  • Querying an EF Core model
  • Manipulating data with EF Core

Relational Database Management Systems

One of the most common places to store data is in a Relational Database Management System (RDBMS). Common ones include Microsoft SQL Server, Oracle, and SQLite.

Using a sample database

To learn how to manage a database using ...

Get C# 7 and .NET Core: Modern Cross-Platform Development - Second 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.