How to convert this query in linq.

Question

Hi frnds....

 

i want to convert this query in linq..but i could not get success....So please help me out. 

 

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_sid,acc_sname FROM acc_subtype

where acc_id in (select acc_id from acc_type where grp_id=7))) as t order by acc_name

 

 

Thanks....