dc

dc

  • NA
  • 663
  • 0

C# linq use 3 tables

Oct 7 2012 1:54 PM
In a C# 2008 application, I have the following linq to sql statement setup so far. 

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 iw).FirstOrDefault();

I want to obtain values from the 3 different tables listed in the statement aove.
How do I change the linq statement above so that I can obtain data from all three tables?

Thus can you show me how to obtain data from all 3 tables?

Answers (1)