unable to write Linq query -
i have sql query. want convert linq query. userlinks , userroles c# classes represent dbase tables.
select distinct userlinks.linkid userlinks roleid in (select roleid userroles userid=1) , userlinks.enable='true'
var roleids = userroles.where(u => u.userid == 1) .select(r=>r.roleid) .tolist(); var result = userlinks.where(u => roleids.contains(u.roleid) && u.enable) .select(l => l.linkid) .distinct() .tolist();
Comments
Post a Comment