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)