LINQ thinks I need an extra INNER JOIN, but why?
- by Saurabh Kumar
I have a LINQ query, which for some reason is generating an extra/duplicatre INNER JOIN. This is causing the query to not return the expected output. If I manually comment that extra JOIN from the generated SQL, then I get seemingly correct output.
Can you detect what I might have done i nthis LINQ to have cuased this extra JOIN?
Thanks.
Here is…