Mastering Entity Framework Core: Mapping & Manipulating Data
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
8 students enrolled
Wishlisted Wishlist

Please confirm that you want to add Mastering Entity Framework Core: Mapping & Manipulating Data to your Wishlist.

Add to Wishlist

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
0.0 (0 ratings)
Instead of using a simple lifetime average, Udemy calculates a course's star rating by considering a number of different factors such as the number of ratings, the age of ratings, and the likelihood of fraudulent ratings.
8 students enrolled
Created by Packt Publishing
Last updated 8/2017
Current price: $10 Original price: $125 Discount: 92% off
5 hours left at this price!
30-Day Money-Back Guarantee
  • 3.5 hours on-demand video
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
What Will I Learn?
  • 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
View Curriculum
  • Familiar with Entity Framework and .NET Core

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.

Who is the target audience?
  • This course is aimed at developers who are somewhat familiar with Entity Framework and .NET Core, and who want to develop or extend their knowledge of Entity Framework Core and see practical examples on how to use it in .NET Core Web applications. Prior knowledge of .NET and C# is assumed.
Students Who Viewed This Course Also Viewed
Curriculum For This Course
26 Lectures
Getting to Know Entity Framework Core
6 Lectures 30:13
This video will give an overview of the entire course
Preview 03:40

Historically, there has been an impedance mismatch between object-oriented languages and relational databases
Quick Dive into Object Relational Mapping

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

Understanding Entity Framework Core Concepts

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

Working with .NET Core

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 Capabilities and Architecture

We need to write code to access data in an RDBMS to follow along with the course.
Prerequisites to Creating an ASP.NET Core Application
Create New Project with Entity Framework Core
5 Lectures 39:28

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

Preview 07:35

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

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

Configure Entity Framework in an ASP.NET Core Project

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

Creating Simple Model and Create a Database for the Application

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
Save and Query a New Record
Mapping Entities and Database Structure
5 Lectures 50:12
We need to learn how to define the desired database structure using entity classes with properties and configuration mechanisms available through DbContext Api
Preview 12:14

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.

Mapping Properties to Columns

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#.
One-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.

Many-to-many 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
One-to-one Relationships
Querying Data
6 Lectures 57:55

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

Using LINQ, Method, and Query Syntax

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

Simple Queries, Using Order By, and Where Clauses

Often, we do not need to look at each row of data, when we are only interested in summarizing them

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.
Using Projections

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.

Including Child Records

We must think about the speed of software when using EF Core in order to achieve optimal performance.
Performance Considerations
Manipulating Data
4 Lectures 31:06
We need to create a Web API Controller, which we will use to implement CRUD operations that manipulate the data
Create a Web API Controller with CRUD Operations

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
Insert Data

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

Update Data

We must support deletes, so we need to add a delete method to our controller
Delete Data
About the Instructor
Packt Publishing
3.9 Average rating
8,109 Reviews
58,371 Students
686 Courses
Tech Knowledge in Motion

Packt has been committed to developer learning since 2004. A lot has changed in software since then - but Packt has remained responsive to these changes, continuing to look forward at the trends and tools defining the way we work and live. And how to put them to work.

With an extensive library of content - more than 4000 books and video courses -Packt's mission is to help developers stay relevant in a rapidly changing world. From new web frameworks and programming languages, to cutting edge data analytics, and DevOps, Packt takes software professionals in every field to what's important to them now.

From skills that will help you to develop and future proof your career to immediate solutions to every day tech challenges, Packt is a go-to resource to make you a better, smarter developer.

Packt Udemy courses continue this tradition, bringing you comprehensive yet concise video courses straight from the experts.