Mastering Entity Framework Core: Mapping & Manipulating Data
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.
About the Author :
Sergey Barskiy is an architect with Tyler Technologies. He lives in Atlanta, GA. He has been developing software for almost 20 years. Sergey is a Microsoft MVP. He holds these Microsoft certifications: MCPD, MCTS, MCSD for .NET, MCAD for .NET, MCDBA, and MCP. He has been working with Microsoft Technologies for over 15 years. He is a frequent speaker at various regional and national conferences, such as VS Live, DevLink, CodeStock, and Atlanta Code Camp, as well as local user groups. He is one of the organizers of Atlanta Code Camp. He authored articles for Code Magazine.
Sergey Barskiy has been using Entity Framework since it was first released to the public. He has deployed a number of projects to production that used Entity Framework over the years. He has used the Code-First approach on a few different projects as well. Sergey has produced an online video training course for this technology. He has spoken on Entity Framework Code-First at a number of national and regional conferences and events.
Getting to Know Entity Framework Core
We need to know what problems the EF core solves and how it makes developers lives easier.
Since EF Core is built on top of .NET Core, we must understand the .NET Core framework and its key characteristics.
Create New Project with Entity Framework Core
We need to learn how to use the command-line interface tool, dotnet.exe, in order to be proficient and effective as we write our code
In order to effectively use Entity Framework Core inside an ASP.NET Core application, we must add it to dependency injection and use connection strings to specify the database we want to talk to
We need to know how, partially speaking, we can model database tables in C#.
Mapping Entities and Database Structure
We must know how to create columns in the database that correspond to our classes’ properties with the desired characteristics through the DbContext Api and the use of attributes.
We need to define another common way to relate entities, many-to-many relationships. In this case, a single row from one table may relate to many on another, and vice-versa.
We need to learn LINQ, the query language for Entity Framework Core to be able to create queries.
In order to be able to get multiple records from a database, we need to learn basic queries.
Sometimes, we need to get data from multiple related tables to match our goals. There are many ways of achieving this purpose in EF Core.
Often, we need to update the data we inserted, so we need to add the update functionality to our controller