c# - Accessing foreign keys through LINQ -

i have setup on sql server 2008. i've got 3 tables. 1 has string identifier primary key. second table holds indices attribute table. third holds foreign keys both tables- attributes aren't held in first table instead referred to. apparently common in database normalization, although still insane because know that, since key string, take maximum of 1 attribute per 30 first table room entries yield space benefit, let alone time , complexity problems.

how can write linq sql query return values first table, such hold specific attributes, defined in list in second table? attempted use join or groupjoin, apparently sql server 2008 cannot use tuple return value.

"i attempted use join or groupjoin, apparently sql server 2008 cannot use tuple return value".

you can use anonymous types instead of tuples supported linq2sql.

ie:

from x in source group x new {x.field1, x.field2}