WebWhat you can do is: var templatesFields = await _context.Sections .Include (x => x.Subtitles) .ThenInclude (r => r.Fields) .ThenInclude (r => r.OptionSources) .ThenInclude (r => r.OptionsSourcesDetails) .Where (t=>t.Subtitles.Fields.Any (x => x.TemplatesFields.TemplateID==TemplateID)) .ToListAsync (); WebOct 14, 2024 · Include is an extension method in the System.Data.Entity namespace so make sure you are using that namespace. Eagerly loading multiple levels It is also possible to eagerly load multiple levels of related entities. The queries below show examples of how to do this for both collection and reference navigation properties. C#
More flexible Include API - allow walking back up include tree
WebJun 27, 2024 · ThenInclude You can drill down through relationships to include multiple levels of related data using the ThenInclude method. The following example retrieves data from Users, UserRoles, and Roles tables. using (var context = new UserContext()) { var User = context.Users .Include(ur=> ur.UserRoles) .ThenInclude(r => r.Roles) .ToList(); } WebMar 11, 2024 · Entity Framework Core allows you to use the navigation properties in your model to load related entities. There are three common O/RM patterns used to load … ironwood connection san antonio
Loading Related Entities - EF6 Microsoft Learn
Web/// http://duoduokou.com/csharp/27342138329645772088.html WebFeb 26, 2024 · Entity Framework Plus library contains IncludeOptimized extension method which under the hood also split the query into multiples queries but way more: Easier Faster Flexible Pros Easier to use than splitting queries One database round-trip is required Bonus: Allow to filter related entities Cons Can sometimes be slower than Include ironwood condos in bradenton fl