by Sergey Barskiy | Released September 2017 | ISBN: 9781788398527

Master Entity Framework in a step-by-step manner and learn advanced querying techniques, migrations, and testingAbout This VideoExplore data validation using attributes and use validation inside MVC controllersMaster advanced query techniquesLearn how to enhance the performance or scalability of Entity Framework CoreDelve into concurrency handling and understand transactionsPerform migrations and protect existing data during rename operationsIn DetailYou 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. Show and hide more

1. Chapter 1 : Exploring Data Validation
   • The Course Overview 00:04:01
   • Implementing Data Validation Using Attributes 00:06:02
   • Validation In Controllers 00:05:58
   • Exposing Validation in MVC Views 00:08:35
   • Using Business Objects for Validation 00:05:50
2. Chapter 2 : Advanced Query Techniques
   • Windowing Functions 00:07:44
   • Working with Joins 00:06:45
   • Left Outer Joins and Unions 00:07:14
   • Using Stored Procedures and Views 00:08:40
3. Chapter 3 : Performance and Scalability
   • Asynchronous Code 00:05:23
   • Profiling Queries and Logging 00:09:09
   • General Performance Tips 00:08:17
4. Chapter 4 : Advanced Update Support
   • Concurrency Handling 00:08:04
   • Understanding Transactions 00:07:12
   • Using Repository Pattern With EF 00:05:38
5. Chapter 5 : Migrations
   • Automatic Migrations 00:07:07
   • Migrations API 00:06:56
   • Manual Migrations 00:08:55
   • Handling Existing Data 00:08:14
6. Chapter 6 : Testing and Runtimes
   • Creating Integration Tests 00:07:31
   • Creating Unit Tests 00:04:36
   • Reverse Engineer Context for an Existing Database 00:04:44
   • Other Databases and Runtimes 00:07:44
Show and hide more