LINQ2SQL - cross join when I want inner join

Question

This emits the internal connections that I want and works:

var q =
    from itm in esdc.items
    join itmImg in esdc.itemImages on itm.itemId equals itmImg.itemId
    join itmIdent in esdc.itemIdentities on itm.imgIdentityId equals itmIdent.itemIdentityId
    join startImgs in esdc.vStartPgImgs on itmImg.imgId equals startImgs.imgId
    select ...

This also works, but cross-connections have been emitted. How to get internal connections? I checked entities twice, and the relationship is correct.

var q =
    from itmIdent in esdc.itemIdentities
    from itm in itmIdent.items
    from itmImg in itm.itemImages
    join startImgs in esdc.vStartPgImgs 
        on itmImg.imgId equals startImgs.imgId
    select ...

If you need me to publish emitted SQL and entity customization, let me know.

Answer 1

Simply put: you get internal connections if you use the first form. A few sentences fromare cross-connects (sort of like ¹ anyway ) in LINQ.

, , join.

---

¹ ( , ... LINQ to SQL .)