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