LINQ with joins using sharepoint lists
Here this code is used for using joins in linq uisng sharepoint lists. here is the code. SPList Firstlist = objWeb . Lists [ "FirstList" ]; SPList Secondlist = objWeb . Lists [ "Secondlist" ]; SPList Thirdlist = objWeb . Lists [ "ThirdList" ]; var customerorders = from SPListItem first in Firstlist . Items join SPListItem second in Secondlist . Items on first [ "Location" ] equals second [ "Location" ] join SPListItem third in Thirdlist . Items on first [ "Location" ] equals third [ "Location" ] select new { Location = Convert . ToString ( first [ "Location" ]), Name = Convert . ToString ( first [ "Name" ]), Address = Convert . ToString ( second [ "Address" ]), Status = Convert . ToString ( third [ "Status" ]) };