Left Outer Join in Linq to DataSet

Question

var query = from e in Employee
                    join s in Sanc
                    on e.Field<long>("eCol1") equals s.Field<long>("sCol1") into empSan
                    select new
                    {
                        EName = e["eCol2"],
                        SancName = empSan
                    };

I am getting the output as:-

      EName                                                   SancName                                               

<Steve Smith> <System.Linq.Lookup`2+Grouping[System.Int64,System.Data.DataRow]>

How to get the correct column value from Sanc table instead of this?

Answer 1

Hi SwastikMs,

your Question is related to LINQ. Post your question in below forum for proper answer.

http://social.msdn.microsoft.com/forums/en-US/linqprojectgeneral/threads/

Regards,

Gautam