Selecting multiple child tables throwing error

[Aaron J]

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