3.85 out of 5
3.85
15 reviews on Udemy

Mastering Entity Framework Core: Mapping & Manipulating Data

In a step by step manner, master Entity Framework Core and effectively start developing and managing data-driven applica
Instructor:
Packt Publishing
148 students enrolled
English [Auto-generated]
Understand what ORM tools are and what problems they solve
Understand how to persist application data to a database using Entity Framework Api.
Learn how to query the data using Linq and gain insight in how Linq fits into Entity Framework
Learn how about mapping entities explore possible types of relationships for database model
Learn how to create, update and delete data, commonly referred to as CRUD operations

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

1
The Course Overview
This video will give an overview of the entire course
2
Quick Dive into Object Relational Mapping
Historically, there has been an impedance mismatch between object-oriented languages and relational databases
3
Understanding Entity Framework Core Concepts

We need to know what problems the EF core solves and how it makes developers lives easier.

4
Working with .NET Core

Since EF Core is built on top of .NET Core, we must understand the .NET Core framework and its key characteristics.

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.
6
Prerequisites to Creating an ASP.NET Core Application
We need to write code to access data in an RDBMS to follow along with the course.

Create New Project with Entity Framework Core

1
Command Line Interface for .NET 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

2
Create New Project Using VS 2017 with Entity Framework
To get started with EF inside .NET Core ASP.NET project, we need to create a project first
3
Configure Entity Framework in an ASP.NET Core Project

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

4
Creating Simple Model and Create a Database for the Application

We need to know how, partially speaking, we can model database tables in C#.

5
Save and Query a New Record
We must conclude the introductory part of the course by adding data to our newly created database and querying it back out in order to ensure that we’ve properly configured and modeled our simplest use case

Mapping Entities and Database Structure

1
Mapping Classes to Tables
We need to learn how to define the desired database structure using entity classes with properties and configuration mechanisms available through DbContext Api
2
Mapping Properties to Columns

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.

3
One-to-many Relationships
In an RDBMS system, R stands for relational, meaning that the tables relate to each other in the same way entities are related to one another in our .NET code. We need to be able to model the most common type, one-to-many relationship, using C#.
4
Many-to-many Relationships

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.

5
One-to-one Relationships
We must conclude the introductory part of the course by adding data to our newly created database and querying it back out to ensure that we’ve properly configured and modelled our simplest use case

Querying Data

1
Using LINQ, Method, and Query Syntax

We need to learn LINQ, the query language for Entity Framework Core to be able to create queries.

2
Simple Queries, Using Order By, and Where Clauses

In order to be able to get multiple records from a database, we need to learn basic queries.

3
Aggregations
Often, we do not need to look at each row of data, when we are only interested in summarizing them
4
Using Projections
Sometimes, we do not need to get all the properties filled if we need to get a subset of columns. This is where projections come in.
5
Including Child Records

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.

6
Performance Considerations
We must think about the speed of software when using EF Core in order to achieve optimal performance.

Manipulating Data

1
Create a Web API Controller with CRUD Operations
We need to create a Web API Controller, which we will use to implement CRUD operations that manipulate the data
2
Insert Data
In order to be able to insert new data into the database through web service calls, we need to add the insert implementation to our Web API controller
3
Update Data

Often, we need to update the data we inserted, so we need to add the update functionality to our controller

4
Delete Data
We must support deletes, so we need to add a delete method to our controller
You can view and review the lecture materials indefinitely, like an on-demand channel.
Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don't have an internet connection, some instructors also let their students download course lectures. That's up to the instructor though, so make sure you get on their good side!
3.9
3.9 out of 5
15 Ratings

Detailed Rating

Stars 5
6
Stars 4
2
Stars 3
4
Stars 2
1
Stars 1
2
f1a76abfc9695cd8bc116fe157f43159
30-Day Money-Back Guarantee

Includes

3 hours on-demand video
Full lifetime access
Access on mobile and TV
Certificate of Completion