English | MP4 | AVC 1280×720 | AAC 48KHz 2ch | 3h 20m | 513 MB
Updated6/6/2018
Note: This course is now updated to feature shorter videos and the original course has been split into two courses. Please check out Entity Framework Core Essential Training: 2 for the next installment.
This comprehensive course shows how to work with Entity Framework Core. Get introduced to the core components and see a comparison of versions. Find out how to create new projects, add packages, and use prebuilt classes. Learn how to build queries, apply sorting, and filter the results. Discover how to work with aggregation commands and use projections. See how to load related data and run async queries. Next, move on into advanced query features, including parameterization, tracking, function mapping, and LINQ functions. Then, learn about persisting data, DbContext options, configurations, and more.
Topics include:
- Entity Framework Core components and projects
- Working with scaffolded files
- Testing with xUnit
- Viewing generated SQL
- Composing queries
- Sorting and filtering results
- Working with aggregates
- Loading related data
- Parameterization
- Logging and tracking
- Mapping functions
- Generics and delegates
- Checking concurrency
- Resiliency and transactions
Table of Contents
Introduction
1 Welcome
2 What you should know and have
3 Configure Visual Studio 2017
4 Using the exercise files
5 Restore and fix AdventureWorks
Get to Know Entity Framework
6 Object-relational mappers
7 Introduction to Entity Framework Core
8 The components of EF Core
9 EF Core usage scenarios
10 Comparing EF 6 to EF Core 2
Set the Stage
11 Create the data access layer project
12 Create the test project
13 Scaffold an existing database
14 Examine the scaffolded files
15 Testing with xUnit
Querying Data
16 LINQ execution
17 View generated SQL
18 Logging
19 Filter results with Find
20 Filter results with Where
21 Filter results with multiple Wheres
22 Use first last and single
23 Sorting and paging
Advanced Query Features
24 Like query operator
25 Global query filters
26 Aggregates
27 Projections
28 Loading related data
29 Eagerly load related data
30 Explicitly load related data
31 Async queries
Persisting Data
32 Intro to FromSql and ExecuteSqlCommand
33 Raw SQL queries composed with LINQ
34 Use stored procedures with FromSql
35 FromSql with unmapped entities
36 Parameterization of Raw SQL
37 Mixed client-server query evaluation
38 Tracking or NoTracking
39 Scalar database function mapping
40 Explicitly compiled queries
41 Generics and delegates
Conclusion
42 Next steps
Resolve the captcha to access the links!