Loading

Linq join query in C#

Sri Kanth Dharapaneni

i have the following query in Linq. how can i convert this one into list or data table without loops.

var joinedList = (from lid in liDtls

join licomd in liCommoDtls on lid.QLFBOMId equals licomd.QLFBOMId into temp

from detail in temp.DefaultIfEmpty()

select new

{

CommoidAppl = detail == null ? String.Empty : "Y"

});

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nilesh Shah9y ago
Just append a .toList() at the end of the query, and you will get list of entities in joinedList variable.

What happens now when you look at the value returned in joinedList?