Selecting multiple child tables throwing error
Posted by: Aaron J
Date: October 04, 2021 10:32AM


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

.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 ChildEndityA.

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

Written By
Selecting multiple child tables throwing error
October 04, 2021 10:32AM

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.