Entity Framework Core - Knowledge Base (KB)

Entity Framework core select causes too many queries

I have the following method which is meant to build me up a single object instance, where its properties are built via recursively calling the same method:...public ChannelObjectModel GetChannelObject(Guid id, Guid crmId) { var result = (from ...

How to improve performance of an EF Core query which uses several Includes

I've got this query, which I'll simplify for brevity:...public IQueryable<User> GetByIdAsync(Guid userId) { return MyContext .Users //Bunch of Includes //Most of which have a ThenInclude //Followed by anothe...

C# .NET Core EF or ADO.NET query takes minutes and SSMS just 30 seconds, why?

So yeah, I'm currently stuck on a simple code that my app should do pretty quickly, considering the same query runs in SSMS in about 34 seconds and uses around 90mbps:...But then, look at what EF does while running the same query:...Not even using ADO.NET...