Eager loading for one to many to one in EF Core

asp.net-core c# entity-framework entity-framework-core

Question

I have a database schema just like below:

ER Model

Here is the code that I need to do eager loading for my data:

var item = db.Course
    .Include(p => p.CourseInstructor)
    .FirstOrDefault(p => p.CourseId == courseId);

if (item == null)
{
    return NotFound();
}

return (from p in item.CourseInstructor
        select p.Instructor).ToList();

All I can get are the null on the p.Instructor navigation property.

I was tried to use ThenInclude, but I don't know how to code it right.

Wrong trial

How can I made this code works as expected to get the full Person data using Eager loading technique?

1
0
12/13/2018 5:50:40 PM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

This is a known Intellisense issue with the ThenInclude overload for collection type navigation properties, tracked by the Completion missing members of lambda parameter in fault tolerance case #8237 Roslyn GitHub issue.

Until it gets fixed, simply type the name of the property and it will compile successfully and work as expected.

.ThenInclude(mu => mu.ParseSubTrees)

Update: Now it's even specifically mentioned in the Including multiple levels section of the EF Core documentation:

Note

Current versions of Visual Studio offer incorrect code completion options and can cause correct expressions to be flagged with syntax errors when using the ThenInclude method after a collection navigation property. This is a symptom of an IntelliSense bug tracked at https://github.com/dotnet/roslyn/issues/8237. It is safe to ignore these spurious syntax errors as long as the code is correct and can be compiled successfully.

41
10/10/2018 8:06:29 PM

Related Questions

How to create Multiple one-to-one relationships in EF Code first?

Third Edit: Changed plenty of my code at the end of the question, left the original just in case that was the way to go.......I'm having a problem understanding how to work with multiple one-to-one relationships in EF. I already had made a one-to-one relationship between two models, but when I tried to add another model one-to-one relationship to t...
asp.net-mvc c# ef-code-first entity-framework entity-framework-6
asked by Jorge Díaz

EF Code-First One-to-one relationship: Multiplicity is not valid in Role * in relationship

I'm attempting to do the following:...public class class1 { public int Id {get;set;} [ForeignKey("Class2")] public int Class2Id {get;set;} public virtual Class2 Class2 {get;set;} } public class class2 { public int Id { get; set;} [Required] public virtual int Class1Id {get;set;} [Required] [ForeignKey("Class1Id"...
c# database ef-code-first entity-framework entity-framework-6
asked by JensOlsen112

Solutions with one EF6 model (db first) and one code first

I have a solution that has multiple databases. We are using EF6....We have one Project that is EF6 (code first), and one project that is EF6 DB first....var arkleModelDbFist = new Arkle.DAL.EF.ArkleEntities(); var CustomerOld= new Arkle.DAL.EF.Customer(); arkleModelDbFist.Customers.Add(CustomerOld); // Errors on this line arkleModelDbFist.SaveChang...
c# entity-framework entity-framework-6
asked by DermFrench

EF 6 - Code first invalid one-to-one foreign key relationship

DESIGN BACKGROUND...:...I'm trying to create code-first EF6 mappings for the following database structure:...The database design is as follow: Instead of having "CustomerID" as foreign key on all related entities (Employment, expenses, income, etc...), we have a CustomerRelationship table, which will contain the CustomerID, and then a "RelatedID" c...
c# ef-code-first entity-framework entity-framework-6
asked by FaNIX

One to One Relationship with Different Primary Key in EF 6.1 Code First

I am having an issue getting a reference to the employee object from the PayGroup object using Entity Framework 6.1. I have a foreign key in the database on PayGroup.SupervisorId -> Employee.EmployeeId. Note that this is a zero or one-to-one relationship (a pay group can only have one supervisor and an employee can only be the supervisor of one pay...
c# ef-fluent-api entity-framework entity-framework-6 sql-server
asked by Brian Swart

How to have a one to one, and a many to one, relation ship EF?

Context:...I am working with entity framework core code first approach. The entity framework core is located in .Net core class library....Situation:...Relations...I have one table named ...Question... and a table named ...AnswerOption.... These tables have relationships like:...A ...Question... has one RightAnswer which is of type ...AnswerOption....
c# ef-code-first entity-framework entity-framework-core
asked by Timon Post

Entity Framework Core fluent api One-To-Many and One-To-One produces duplicate foreign key

I'm changing my ASP.NET MVC project to ASP.NET Core MVC with Entity Framework Core and Fluent API. When I try to configure a one-to-one and one-to-many relationship, it generates duplicate foreign key columns in the dependent table. ...For example: I have this in my context's ...OnModelCreating... method:...builder.Entity<Session>() .HasKey...
asp.net-core-mvc c# ef-fluent-api entity-framework-core entity-framework-core-migrations
asked by Deyi Kong

What is the difference between EF Core Database-First and EF Core Code-First approaches?

I was wondering... since there is no EDMX in EF Core, what is the difference between those 2? And if the major difference would be the possibility to change the database tables, why not use code first then use EF code-first migrations?
asp.net-core ef-code-first ef-database-first entity-framework-core
asked by shade1337

EF Core is lazy loading when I try to eager load with .Include()

I'm using EF Core 2.2.6 (database first) and it seems like just having lazy loading enabled keeps me from being able to eager load. Does enabling lazy loading preclude using eager loading in any capacity?...namespace Example.Models { public class Lead { public int Id { get; set; } public LeadOrganization LeadOrganization { g...
c# ef-core-2.2 entity-framework-core
asked by Gabe

One-way one-to-one relationship with EF Core

What I want to achieve, is have a model ...CommentsThread... that can be attached to any other model that needs comments, be it ...Chapter..., ...BlogPost..., ...UserProfile..., or what have you. Basically, the structure I need is...CommentsThread int ID Chapter int ID int Thread FK(CommentsThread.ID) BlogPost int ID int Thread FK(Comme...
asp.net-core c# entity-framework-core
asked by Angius

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow