Chapter 8. Working with Relational Data Using the Entity Framework

This chapter is about reading and writing to Microsoft SQL Server (and other databases) using classic ADO.NET and the object-relational mapping technology known as the Entity Framework.

This chapter will cover the following topics:

  • Relational Database Management Systems
  • Using ADO.NET
  • Using Entity Framework 6
  • Using Entity Framework 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 MySQL.

Connecting to Microsoft SQL Server LocalDb

Microsoft offers various editions of its SQL Server product. We will use a free version that can run standalone and ...

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