Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- how to convert sql to linq
- select s.IdSimcard ,s.Imei from dbo.SimCard s
- where s.Imei not in (select distinct d.Imei from dbo.SimCard d inner join dbo.Configuracion c
- on c.SinCard_IdSincard = d.IdSimcard
- where c.Estado = 'Activo' )
- (from s in SimCard where s.Imei.Contains( (from c in Configuracion
- join d in SimCard on c.SinCard_IdSincard equals d.IdSimcard
- where c.Estado == "Activo"
- select new { d.Imei }).Distinct())
- select new { s.IdSimcard, s.Imei })
Add Comment
Please, Sign In to add comment