LINQ help!!!

[ywang555]

I have this query, but I need the flat result. Like: c.id, c.CoverCode, c.Premium, ..., cv.CoverageCode any idea??? From c In Covers _ Join cv In Coverages On c.PolicyKey Equals cv.PolicyKey And c.CoverNumber Equals cv.CoverNumber _ Where c.PolicyKey = 3441028 _ Select New With {c, cv.CoverageCode}

[Fernando Soto]

Hi ywang555; In the select statement explicitly select each field of c and cv. For example: Select New With {c.Field1, c.Field2, ... , c.Fieldn, cv.CoverageCode} Fernando

[ywang555]

Yes. But I have tons of fields. It's hard to write and maintain. I am just wondering a good way.

[Fernando Soto]

It is the only way to get a flatten result set.

[akidan]

You will be happier in the long run if you do Select New With {c, cv}