I have a table 'TableA' which represents TypeA and its child TypeB
A third table 'People' has a many to many relationship to TableA.
when I issue a query like
from p in _entities.People where p.Id = 7 from t in p.TablesUsingPeople select a;
I get an InvalidOperationException at line 76 in TransformVisitor. This seems to happen with a variety of syntaxes expressing much the same query.
This morning has been spent polymorphising TableA. Prior to that I had the same table structure and the query worked.
I've run a similar query against a SQL Server database with this structure and it seems to work OK.
Can you take a look?