xsharp.eu • LINQ to SQL - some possible issues with syntax for joins - Page 3
Page 3 of 3

LINQ to SQL - some possible issues with syntax for joins

Posted: Fri Nov 25, 2016 2:45 pm
by Phil Hepburn
Hey guys,

It may interest you to see proof of the data in the SQL database - that which we have seen displayed in the WPF data grids previously.

I have added to that data shown in Robert's sample posting - we now have three flat Tables, and an extra column or two, as well as an extra row here and there.

I added just sufficient data to be able to test out two Left Outer Joins in the same query.

Once you get your head into this stuff it becomes really quite easy / doable. Honestly !

Regards,
Phil.
XS_RobExampJoin_04.jpg
XS_RobExampJoin_04.jpg (45.41 KiB) Viewed 176 times

XS_RobExampJoin_05.jpg
XS_RobExampJoin_05.jpg (61.57 KiB) Viewed 176 times

XS_RobExampJoin_03.jpg
XS_RobExampJoin_03.jpg (107.53 KiB) Viewed 176 times