Entity with Multiple Child Entities
Posted by: Aaron J
Date: December 06, 2021 10:52AM

Hi,

our Dev tools .Net, C# and MySQL community server 8.0.26. Project using MySql.Data as data driver and MySql.Data.EntityFramework for EF.



Trying fetch related tables via LINQ to Entities as below

..
Find(predicate)
.Include(o => o.EntityA.ChildEntityB)
.Include(o => o.EntityA.ChildEntityc)
.Include(o => o.EntityX)
.Include(o => o.EntityY)
.Include(o => o.EntityZ)

EntityA has relation(1:m) to two child Entities ChildEndityB and ChildEndityC.

Above query as is returning error, "Unknown column 'Join7.OrderId' in 'on clause'". When i looked at the SQL generated, it is trying access Select alias "Join7" where it is out of scope.

If comment out either ".Include(o => o.EntityA.ChildEntityB)" or ".Include(o => o.EntityA.ChildEntityc)" Include statment, then the query works fine.

Please advise or do let me know if you need any more information.



Thanks in advance

Options: ReplyQuote


Subject
Written By
Posted
Entity with Multiple Child Entities
December 06, 2021 10:52AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.