Book Image

Mastering Entity Framework Core - Mapping, Querying and Manipulating Data [Video]

Book Image

Mastering Entity Framework Core - Mapping, Querying and Manipulating Data [Video]

Overview of this book

Entity framework is an Object Relational Mapping (ORM) framework that offers an automated mechanism to developers for storing and accessing the data in the database. In order to survive in this growing market, the knowledge of a framework that helps provide easy access to databases, that is, Entity Framework has become a necessity. This Video will provide .NET developers with this knowledge and guide them through working efficiently with data using Entity Framework Core.You will start by understanding ORM concepts, before then moving on to discuss advantages of Entity Framework over ADO.NET. Next you will see how.NET Core fits into the overall pictures and go over the environment necessary to follow along with the course. Further you will learn to build your first sample project to see EF in action here you will learn to create database and add data to it. Further you will learn about Mapping Entities and Database structure here you will see how to create mapping between objects and database structures, how to define tables and columns. You will learn the specifics or SQL Server types and how to map them to .NET Types. You will define all possible types of relationships for your database model. Next you will dive into Querying data you will learn the basics of Linq then you will start with simple queries, advance to aggregations and projection techniques. You will see how to obtain object graphs and talk about performance. Next you will learn Manipulating data, you will learn how to create, read, update and delete data, commonly referred to as CRUD operations. You will see the differences between object graphs and individual objects when it comes to CRUD features of Entity Framework Core. Finally you will learn best practices examples.
Table of Contents (5 chapters)
Chapter 1
Getting to Know Entity Framework Core
Content Locked
Section 5
EF Capabilities and Architecture
We need to know what key object we will need to manipulate and understand how EF core translates our C# code to SQL code. We also need to update the schema at times. - EF Core exposes database data as objects on .NET, using classes such as DbContext and DbSet - EF is capable of updating the database schema via the migrations API - The provider architecture is the magic behind translating C# or VB.NBET LINQ statements to SQL statements