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