Mukesh Kumar Tiwari

Mukesh Kumar Tiwari

  • 1.2k
  • 1k
  • 213.2k

How To Convert This Sql Query To LINQ.??

Oct 5 2015 9:12 AM
Hi frnds..
 
i want to convert this Sql Query into linq....Anybody help me out pls...
 
select * from ((select acc_id,0,acc_name from acc_Type where grp_id=7 and acc_id not in (select distinct acc_id from acc_subtype))
union all(select acc_id, acc_subTypeid, acc_SubTypename from acc_subtype where acc_id in( select acc_id from acc_type where grp_id=7))) as t order by acc_name
 
Thanks.... 

Answers (1)