How to translate my LINQ code to sql query

[Sudip_inn]

How to translate below LINQ to sql. in this LINQ i am joining a datatable & linq. here i will return those data from datatable dtFilter10QK
whose section & lineitem does not exist in list lstMapData. tell me how to write same equivalent sql.

DataTable dtJoinedData = (from _10qk in dtFilter10QK.AsEnumerable()
join mappedlst in lstMapData
on new
{
Section = _10qk.Field<string>("Section"),
LineItem = _10qk.Field<string>("Line Item")
}
equals new
{
Section = mappedlst.Section,
LineItem = mappedlst.LineItem
}
into g
where g.Count() == 0
select _10qk).CopyToDataTable();

Continue reading...