IntroductionIn this article,I am going to show some SQL queries and LINQ queries with IN and NOT IN clause with SQL and LINQ, but not going to show images for all cases. Filter data by using IN and NOT IN clauseMost of the developer who started working on LINQ queries gets confuse when they got requirement to write IN and NOT IN query using LINQ. SQL Query //IN
SELECT [Id], [UserId], [IMEINo]
FROM [UserClients]
WHERE [UserId] IN (3, 4)
or
//NOT IN
SELECT [Id], [UserId], [IMEINo]
FROM [UserClients]
WHERE [UserId] IN (3, 4) as you see above query use IN and NOT IN clause to filter from list of records. LINQ Query To achieve similar task LINQ make use of Contains function of C#. which do filtering of record form the list of record. //IN
int[] chosenOnes = { 3, 4 };
var user = from u in UserClients
where chosenOnes.Contains(u.UserId.Value)
select new { u.id,u.userid, u.ImeiNo};
or
//NOT IN
int[] chosenOnes = { 3, 4 };
var user = from u in UserClients
where !chosenOnes.Contains(u.UserId.Value)
select u;Note :
IN and NOT IN use same function in LINQ query but it just use !(Not) symbol for it. Graphical representationHope help and thank you for reading. |