from s in db.tblMaster
let t= from u in db.tblUHTs
where u.UId='F7ECFB41-177F-4408-B856-A4F669FAA714'
select u.HTId
where t.Contains(s.HTId)
select new {s.HTId, s.HTN}
1
solved linq query analogous to sql Not In, In clause
from s in db.tblMaster
let t= from u in db.tblUHTs
where u.UId='F7ECFB41-177F-4408-B856-A4F669FAA714'
select u.HTId
where t.Contains(s.HTId)
select new {s.HTId, s.HTN}
1
solved linq query analogous to sql Not In, In clause