My Courses are Live on PacktPub

Course Names:

Mastering Entity Framework Core – Mapping, Querying and Manipulating Data

Mastering Entity Framework Core – Advanced Querying, Migrations and Testing

Introduction

These two courses walk the users through learning all the aspects of Entity Framework Core that you can use today to build .NET Core applications.  These two courses will cover everything you need to get started and be productive with EF Core.

Mastering Entity Framework Core – Mapping, Querying and Manipulating Data

Video 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.

Style and Approach

In a step-by-step manner, learn to use the latest and open-source features of Entity Framework Core in your .NET applications. Understand everything required to effectively start developing and managing data-driven applications using Entity Framework. Make the best of your .NET APIs by integrating them with Entity Framework.

Mastering Entity Framework Core – Advanced Querying, Migrations and Testing

Video Description

You will start the course by exploring data validation and learn how to implement data validation inside your model using attributes. Then you will use validation inside MVC controllers and expose validations inside your MVC views in the user interface. Next you will delve into advanced query techniques. You will see how asynchronous code helps your applications scale better and explore query performance. Further, you will learn how to protect application data from concurrent access by multiple users, see how transactions enable changes to multiple tables and learn how to create an abstraction layer on top of Entity Framework by using the repository pattern.

Next you will embrace migrations and embark on a journey designed to develop the database structure as your application evolves using Entity Framework Core migrations. Then you will create custom migrations that update database schemas and use custom scripts to perform migrations while protecting existing data during rename operations. Finally you will explore testing and set up a further learning path by writing unit and integration tests. You will see how to bring Entity Framework into a project based on an existing database. In conclusion, you will learn about additional areas Entity Framework core can be used in, and what types of data structure (besides RDBMS) can be accessed with EF Core.

Style and Approach

In a step-by-step manner, learn to use the latest open source features of Entity Framework Core in your .NET applications. Learn to perform advanced querying techniques, migrations, and testing. Understand everything you need to effectively start developing and managing data-driven applications using Entity Framework and make the best of your .NET APIs by integrating them with Entity Framework.