Web我在處理包含大量鏈式.Include 的大型 EF Core 查詢時遇到問題。 我有一個看起來像這樣的 linq 查詢: context.Equipment.Include x gt x.Group .Include x gt x.Status .Include x gt x.Area .Inclu WebJan 13, 2024 · It does that by using two different methods Include () and ThenInclude (). In the next example, we are going to return only one student with all the related evaluations, to show how the Include () method works: var students = _context.Students .Include(e => e.Evaluations) .FirstOrDefault();
Eager Loading using Include & ThenInclude in EF Core
WebThenInclude (g => g.Teachers) will load the Teacher collection property of the Grade entity. The ThenInclude method must be called after the Include method. The above will execute the following SQL queries in the database. SELECT TOP (1) [s]. [StudentId], [s]. [DoB], [s]. [FirstName], [s]. [GradeId], [s]. [LastName], [s]. [MiddleName], [s.Grade]. WebJul 6, 2024 · What is include and ThenInclude in Linq? The Include method works quite well for Lists on objects, but what if there is a need for multiple levels of depth. For example, … sims mod better wall projector scenery
Include & ThenInclude in EF Core Tutorial - Entity Framework Core
WebFeb 1, 2024 · The following works for me with the EF Core 2.0 driver: Blog.Take (100).Include (b => b.Posts).ThenInclude (p => p.Blog) Just as with Visual Studio, you … WebApr 28, 2024 · We use the include & ThenInclude methods, along with the Projection Query in EF Core to load the related entities. In this tutorial, we look at include method and learn … WebJan 30, 2024 · using (var context = new BloggingContext ()) { var blogs = context.Blogs .Include (blog => blog.Posts) .AsSplitQuery () .ToList (); } It will produce the following SQL: SQL SELECT [b]. [BlogId], [b]. [OwnerId], [b]. [Rating], [b]. [Url] FROM [Blogs] AS [b] ORDER BY [b]. [BlogId] SELECT [p]. [PostId], [p]. [AuthorId], [p]. [BlogId], [p]. sims mobile online play