eDataContext eData = new eDataContext(); var eSelect = (from iw in eData.Ibooks join ip in etData.IPack on iw.P_ID equals ip.P_ID join eTrack in eData.eRPT_Trans on ip.TNum equals eTrack.P_ID where ip.TNum == packageId select new { iw.P_ID, ip.P_ID, eTrack.P_ID /* Other fields */ } ).FirstOrDefault();