Add Include Expressions dynamically

Prevent Entity Framework adding ORDER BY when using Include

We have a query similar to the following:...from x in db.Table.Include(x => x.Parent) .Include(x => x.Parent.Relation) .Include(x => x.Relation) .Include(x => x.Children) where /* some query */ select x ...The problem is that when adding ....Include(x => x.Children)..., the ...ORDER BY... statem...

Dynamically add route value parameter from database in Asp.Net Core

I'm creating multi-tenancy application, with single database per library, for example....I want to dynamically add library name to route, for example, when user trying to get all books .../Books/GetAllBooks..., I must add library name, which could be retrieved from database, for example: .../LibraryName/Books/GetAllBooks..., so the user can get all...

Apply Include and ThenInclude based on Lambda Expressions Dictionary

I have a few Entity Framework 7 (Core) entities:...public class Person { public virtual Address Address { get; set; } public virtual ICollection<Hobby> Hobbies { get; set; } } public class Address { public String Street { get; set; } public virtual Country Country { get; set; } } ...And I have a string array as follows:...String[] enti...

How To create linq Expression dynamically in c# for Contains

I am trying to create expression dynmically but i could not figure it out... Also dont want to use like this.....if (item.id == 1) filter.AddExpression(c => filterValues.Contains(c.a1)); if (item.id == 2) filter.AddExpression(c => filterValues.Contains(c.a2)); if (item.id == 3) filter.AddExpression(c => filterValues.Contains(c.a3)); if (item.id == ...

Ordering query using lambda expression and Include method

You cannot do sorting (...OrderBy...) inside the ...Include... method. Sort the data after the query.

Why the include function is not including the navigational property of the model?

I have these 2 models:...Phones:...public class Phones { public int ID { get; set; } public string Model { get; set; } public string Manufacturer { get; set; } // e.g. XIAOMI, NOKIA, IPHONE public int UserID { get; set; } public List<Users> Users { get; set; } } ...Users:... public class Users ...

Eagerly loading multiple levels error: "The Include property lambda expression is invalid"

I have a .NET Core 2.1 library that is leveraging Entity Framework Core v.2.2.4 with a MySQL database. I am using the code first model. I have service classes that depend on the ...SoarDataContext... class seen below....When I try to eagerly-load multiple-level nested entities by using the ....Include()... method in ...the way suggested in the docs...

.net Core EF - Dynamically Add to DbSet by string name or type

You can do it by dynamically creating a new type that inherits from DbContext and the use Reflection Emit to add the DbSets to this type....It's a bit of a long solution to try and post into a response here, but here's a GitHub link to a working demo of how it can be done - ...EF Core Dynamic Db Context

Why is Entity Framework core loading entity's relations without adding include

I think the problem is this (excerpt from documentation):...Entity Framework Core will automatically fix-up navigation properties to any other entities that were previously loaded into the context instance. So even if you don't explicitly include the data for a navigation property, the property may still be populated if some or all of the related e...

Entity Framework Core 3.0 - Lambda expression used inside Include is not valid

Here below I am using lambda expression in LINQ Includes for 1 level, to fetch a list of customers using three entities, the main one is for all Customers and has only 2 properties Id and bool: IsCompany, the second one has only those that are companies, and the third one has only those that are individuals. The below code was working using .Net Co...