Entity Framework Core - Knowledge Base (KB)

Entity Framework Join vs Include

I am using EF6.1 and bit confused with the two formats of writing the join queries. ...var query = (from cc in dbContext.Companies.AsNoTracking() join dc in dbContext.Departments.AsNoTracking() on cc.CompanyId equals dc.Compa...

asp.net mvc Join two tables to a single list item in html unordered list

I have successfully used an sql inner join with two tables in webforms to join two tables to a single html unordered list....I am using Asp.net MVC 5 Entityframework 6...I am trying to join the same two tables in MVC to again output a single html unordere...

Add an inner or outer join based on a parameter

This is probably an easy/stupid question but is their a way to add an inner or outer join to a SQL query (with entity framework) based on data you receive?...Example...public bool method(int? typeId, int? categoryId){ var query = from o in _dbContext....

Entity Framework Core 2.2 Many-to-Many Self Reference Loop

I am following Microsoft's many-to-many ef core example at...https://docs.microsoft.com/en-us/ef/core/modeling/relationships#many-to-many...But get a self referencing loop error....Here are my entities:...public class Card { public Guid Id { get; set;...

Include with FromSqlRaw and stored procedure in EF Core 3.1

So here's the deal - I am currently using EF Core 3.1 and let's say I have an entity: ...public class Entity { public int Id { get; set; } public int AnotherEntityId { get; set; } public virtual AnotherEntity AnotherEntity { get; set; } } ...W...

Why only primitive types or enumeration types are supported in this context using EF?

In my application I try to execute a ...Join... query using ...EntityFramework..., ...Repository Pattern..., It is throwing bellow error. What is the ...problem... in the ...link query...? Let me explain in details...Error Description...Unable to create a...