EF Core introduced mixed client and server evaluation of LINQ queries. In this section, Phil explains the mechanism, possible ramifications, and how to change client side query evaluation warnings into exceptions.
- [Narrator] We've mentioned quite a few times,…in this course so far,…client versus server query evaluation and mixed evaluation.…So let's go into details.…So EF Core supports mixed server and client-side execution.…This allows for local C# functions to be added,…into your link statements.…The level of support and how it splits the command,…is determined by the database provider.…But be careful this can cause major performance issues.…
If your very first LINQ command out of the gate,…executes client-side and you aren't aware of that,…then your command will be pulling back every record…from that first DB set…and then operating in a Linq to objects manner,…as opposed to efficient server side execution.…Now EF Core 2.0 has improved the LINQ translation algorithm.…And this has reduced the number,…of client-side evaluation scenarios.…
There we're several,…that I had documented in earlier writings,…that would be client-side,…that are now correctly operating server-side.…But there are problems that still exist…as we demonstrated in the aggregate section.…
- 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
- Logging and tracking
- Mapping functions
- Generics and delegates
- Checking concurrency
- Resiliency and transactions
Skill Level Intermediate
Learning Entity Framework Corewith Reynald Adolphe1h 35m Intermediate
1. Get to Know Entity Framework
2. Set the Stage
3. Querying Data: Part 1
4. Querying Data: Part 2
5. Advanced Query Features
6. Persisting Data
7. DbContext Options and Configuration
Thank you1m 23s
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.