LINQ to SQL - some possible issues with syntax for joins
Posted: Fri Nov 25, 2016 2:45 pm
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.
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 (45.41 KiB) Viewed 158 times
- XS_RobExampJoin_05.jpg (61.57 KiB) Viewed 158 times
- XS_RobExampJoin_03.jpg (107.53 KiB) Viewed 158 times