Mukesh Kumar Tiwari

Mukesh Kumar Tiwari

  • 1.2k
  • 1k
  • 213.2k

How to convert this query in linq.

Dec 14 2015 11:38 AM
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.... 
 

Answers (2)