How To Convert This Sql Query To LINQ.??

Question

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....