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

Popular posts from this blog

Change php variable from jquery value using ajax (same page) -

Pull out data related to my apps from Android Play Store and iOS App Store -

How can I fetch data from a web server in an android application? -