Linq Mapping

Question

Dear All when i join two table than we wont to pic the column of both table with column attribute mapping in linq. sourabh

Deepak Saini · Answer

Dear Nitin  you r right if i am not using list of a particular table. i am using list and i am getting one table column in this list and i wont to getting second table column in this table with column attribute.give me some reason on that.

Nitin · Answer

Hi You need to define anonymous type for this. For ex: var result= from x in tableA join y in tableB on y.id equals x.id select new { x.FieldNameA x.FieldNameB y.FieldNameA y.FieldNameB }; Here new and the starting braces are the anonymous types. We can use this to achieve the result.