Mastering Entity Framework Core: Mapping & Manipulating Data

Name: Mastering Entity Framework Core: Mapping & Manipulating Data
Rating: 4.0 (21 reviews)

In a step by step manner, master Entity Framework Core and effectively start developing and managing data-driven applica

Created byPackt Publishing

Last updated 12/2017

English

What you'll 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

Course content

5 sections • 26 lectures • 3h 28m total length

The Course Overview3:40
This video will give an overview of the entire course
Quick Dive into Object Relational Mapping6:29
Historically, there has been an impedance mismatch between object-oriented languages and relational databases
Understanding Entity Framework Core Concepts3:52
We need to know what problems the EF core solves and how it makes developers lives easier.
Working with .NET Core5:28
Since EF Core is built on top of .NET Core, we must understand the .NET Core framework and its key characteristics.
EF Capabilities and Architecture6:19
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.
Prerequisites to Creating an ASP.NET Core Application4:25
We need to write code to access data in an RDBMS to follow along with the course.

Command Line Interface for .NET Core7:35
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
Create New Project Using VS 2017 with Entity Framework8:36
To get started with EF inside .NET Core ASP.NET project, we need to create a project first
Configure Entity Framework in an ASP.NET Core Project7:33
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
Creating Simple Model and Create a Database for the Application9:34
We need to know how, partially speaking, we can model database tables in C#.
Save and Query a New Record6:10
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 Classes to Tables12:14
We need to learn how to define the desired database structure using entity classes with properties and configuration mechanisms available through DbContext Api
Mapping Properties to Columns8:59
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.
One-to-many Relationships12:37
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#.
Many-to-many Relationships8:42
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.
One-to-one Relationships7:40
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

Using LINQ, Method, and Query Syntax10:35
We need to learn LINQ, the query language for Entity Framework Core to be able to create queries.
Simple Queries, Using Order By, and Where Clauses7:18
In order to be able to get multiple records from a database, we need to learn basic queries.
Aggregations11:21
Often, we do not need to look at each row of data, when we are only interested in summarizing them
Using Projections7:29
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.
Including Child Records12:00
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.
Performance Considerations9:12
We must think about the speed of software when using EF Core in order to achieve optimal performance.

Create a Web API Controller with CRUD Operations8:55
We need to create a Web API Controller, which we will use to implement CRUD operations that manipulate the data
Insert Data8:10
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
Update Data6:04
Often, we need to update the data we inserted, so we need to add the update functionality to our controller
Delete Data7:57
We must support deletes, so we need to add a delete method to our controller

Requirements

Familiar with Entity Framework and .NET Core

Description

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 this course is for:

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.

Mastering Entity Framework Core: Mapping & Manipulating Data

What you'll learn

Explore related topics

Course content

Getting to Know Entity Framework Core6 lectures • 30min

Create New Project with Entity Framework Core5 lectures • 39min

Mapping Entities and Database Structure5 lectures • 50min

Querying Data6 lectures • 58min

Manipulating Data4 lectures • 31min

Requirements

Description

Who this course is for: