ProjectID ProjectOwner ProjectName ProjectStatus
1 77 "Build Fence" 555
ID FName LName
77 John Smith
Let's say I want to build a single linq query to query the SQL tables listed above. How would I come up with this dataset:
ProjectID ProjectOwnerFullName ProjectName ProjectStatusText
1 "John Smith" "Build Fence" "Active"
I understand how to join two tables, but this query will require data from three (all three listed above).
Thank you in advance.