Re: Selecting multiple child tables throwing error
Posted by: Aaron J
Date: December 06, 2021 10:43AM

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.ChildEntityA)
.Include(o => o.EntityA.ChildEntityB)
.Include(o => o.EntictyB)
.Include(o => o.EntictyC)

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

Above query as is returning error, "Unknown column 'Join7.OrderId' in 'on clause'"

If comment out either ChileEntityA or ChildEntityB ".Include" line, 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
Re: Selecting multiple child tables throwing error
December 06, 2021 10:43AM


Sorry, you can't reply to this topic. It has been closed.

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.