Linq to SQL: WHERE IN statement

Question

CREATE TABLE [MyNames]
(
    [ID] INT IDENTITY PRIMARY KEY,
    [Name] NVARCHAR(255) NULL
)

INSERT INTO [MyNames] VALUES ('John')
INSERT INTO [MyNames] VALUES ('Jane')
INSERT INTO [MyNames] VALUES ('Peter')
INSERT INTO [MyNames] VALUES ('Montgomery')
INSERT INTO [MyNames] VALUES ('Sarah')

Based on the above (hypothetical) SQL schema and data, I want to use Linq to SQL to get all results where the name is in values of an array.

string[] names = {"John", "Cassandra", "Sarah"};

var results = (from n in db.Names
               where n.Name **in names**
               select n).ToList();

The results should include John and Sarah. With that information I am then able to add the entries that need to be added, in this case Cassandra.

I don't want to load all the Names because the list can get exceptionally long.

jmoerdyk · Accepted Answer · 2013-08-14 15:12:34Z

30

You can use names.Contains():

string[] names = {"John", "Cassandra", "Sarah"};

var results = (from n in db.Names
               where names.Contains(n.Name)
               select n).ToList();

answered Aug 14, 2013 at 15:12

jmoerdyk

5,5468 gold badges43 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Clarice Bouwer Over a year ago

Thanks! Such an obvious answer. I can't believe I never thought of it.

Michael Goldshteyn · Accepted Answer · 2013-08-14 15:12:24Z

5

You can use the Contains extension method:

var results = (from n in db.Names
               where names.Contains(n.Name)
               select n).ToList();

answered Aug 14, 2013 at 15:12

Michael Goldshteyn

74.9k25 gold badges136 silver badges183 bronze badges

Comments

King King · Accepted Answer · 2013-08-14 15:10:37Z

3

var results = (from n in db.Names
               where names.Any(x=>x == n.Name)
               select n).ToList();

answered Aug 14, 2013 at 15:10

King King

63.5k16 gold badges118 silver badges140 bronze badges

Collectives™ on Stack Overflow

Linq to SQL: WHERE IN statement

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related