[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