Loading

How to convert this query in linq.

Mukesh Kumar Tiwari

10y1.1kLINQ

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

2 Replies

Know the answer? Post it — somebody with the same question will find it here.