This thread looks to be a little on the old side and therefore may no longer be relevant. Please see if there is a newer thread on the subject and ensure you're using the most recent build of any software if your question regards a particular product.
This thread has been locked and is no longer accepting new posts, if you have a question regarding this topic please email us at support@mindscape.co.nz
|
I am getting incorrect SQL with class table inheritance and joins. Here is my LINQ query: events = events.Join(
And here is the generated SQL: exec sp_executesql N'SELECT
And here is the error: Msg 207, Level 16, State 1, Line 8
The problem is PlaceId and CityId exist on derived tables but the SQL is searching for them on the base [Object] table. |
|
|
We have added in a fix for this and it will be available in tonights nightly build.
Jeremy |
|