excuse my typing...my puppy is asleep in my one hand. breaking down the linq:
from t1 in context.Table1
t1 is an arbitrary variable name that linq binds to Table1. now when you use the variable you get intellisense on all fields in the table.
select new { t1.field2, t2.field3}
The select new is creating a new object that is a blend of fields from the two tables. You may want to see if there is a name parameter since you need that type name for enumeration. Now if you used a key in table 1 to get everything out of it's child table 2, then you could do this:
select t2;
The reason you don't need the new keyword is because t2 is a predefined variable.
modified on Thursday, February 19, 2009 4:20 PM