Mastering Entity Framework Core – Advanced Querying, Migrations and Testing

Mastering Entity Framework Core – Advanced Querying, Migrations and Testing
Mastering Entity Framework Core – Advanced Querying, Migrations and Testing
English | MP4 | AVC 1920×1080 | AAC 44KHz 2ch | 2h 40m | 864 MB

Enhance and Master skills to support large complex applications

Master Entity Framework in a step-by-step manner and learn advanced querying techniques, migrations, and testing

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.

What You Will Learn

  • Understand how to evolve database structures using migrations
  • Set up an MVC .NET Core application that uses Entity Framework
  • Enhance the performance and/or scalability of Entity Framework Core
  • Explore data validation inside models using attributes
  • Handle validation inside MVC Core via the Web API
  • Learn advance query and update techniques such as joins and access stored procedures and views
Table of Contents

01 The Course Overview
02 Implementing Data Validation Using Attributes
03 Validation In Controllers
04 Exposing Validation in MVC Views
05 Using Business Objects for Validation
06 Windowing Functions
07 Working with Joins
08 Left Outer Joins and Unions
09 Using Stored Procedures and Views
10 Asynchronous Code
11 Profiling Queries and Logging
12 General Performance Tips
13 Concurrency Handling
14 Understanding Transactions
15 Using Repository Pattern With EF
16 Automatic Migrations
17 Migrations API
18 Manual Migrations
19 Handling Existing Data
20 Creating Integration Tests
21 Creating Unit Tests
22 Reverse Engineer Context for an Existing Database
23 Other Databases and Runtimes