Guest User

Untitled

a guest
Aug 14th, 2018
84
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. how to convert sql to linq
  2. select s.IdSimcard ,s.Imei from dbo.SimCard s
  3. where s.Imei not in (select distinct d.Imei from dbo.SimCard d inner join dbo.Configuracion c
  4. on c.SinCard_IdSincard = d.IdSimcard
  5. where c.Estado = 'Activo' )
  6.  
  7. (from s in SimCard where s.Imei.Contains( (from c in Configuracion
  8. join d in SimCard on c.SinCard_IdSincard equals d.IdSimcard
  9. where c.Estado == "Activo"
  10. select new { d.Imei }).Distinct())
  11. select new { s.IdSimcard, s.Imei })
Add Comment
Please, Sign In to add comment