Eager Load many to Many - EF Core [closed]

Question

Hello I have a many to many relationship set up like following.

public class order
{
    public int id { get; set; }    
    public virtual ICollection<OrderProducts> Products { get; set; }
}

public class product
{
    public int id { get; set; }
    public virtual ICollection<OrderProducts> Orders { get; set; }
}

public class OrderProducts
{
    public int OrderId { get; set; }
    public virtual Order Order{ get; set; }

    public int ProductIdId { get; set; }
    public virtual Product Product { get; set; }   
}

I would like to Include (Eager load) all products into their orders, but when using same approach like shown with customer, my product list get populated with OrderProducts-objects and not Product-objects

public IEnumerable<Order> GetAll()
{
    return dataContext.Orders
                      .Include(order => order.Customer)
                      // now include all products aswell..
}

I have tried stuff like witout any luck

  .Include(order => order.Products.Where(op => op.OrderId == order.Id).Select(p => p.Product))

So would appreciate if someone could help me out here.. You'r also most welcome to share any good resources on how to construct more advanced lambdas, since i'm not that familiar with this yet..

Answer 1

Just use ThenInclude() statement:

public class order
{
    public int id { get; set; }    
    public virtual IList<OrderProducts> OrderProducts { get; set; }
}
//...
public IEnumerable<Order> GetAll()
{
    return dataContext.Orders
                      .Include(order => order.OrderProducts)
                      .ThenInclude(orderProducts => orderProducts.Product);
}

As stated here, many-to-many relation is not yet implemented. You have to load your OrderProducts then Select(orderProducts => orderProducts.Product)

Important: IntelliSense completion might tell you can't do this, but you can, just make a real build and it will work