Using Linq to do a Contains with multiple values

Question

I have a medication table that I'm looking for certain drug names, but I need to search for multiple names. Here is where I currently am with it.

string[] names = new string[2];
names[0] = "apixaban";
names[1] = "desirudin";

var meds = (from m in Medications where names.Any(m.BrandName.Contains) || names.Any(m.GenericName.Contains) select m);

What I have isn't working, and I'm currently stuck. I know I'm close, but I can't quite figure out what's wrong.

EDIT

For clarification, if the name I'm searching for is desirudin, then the BrandName or Generic name will be longer, so I have to have the contains on the field in the database.

EDIT 2 Here is the error I recieve.

Unsupported overload used for query operator 'Any'.

Here is what I finally ended up with

var meds = (from m in db.AdmissionMedications where 
(names.Any(n => m.BrandName.Contains(n)) || names.Any(n => m.GenericName.Contains(n))
) select m);

Please post the error message if you get one, or the fact that it runs without returning results — Brian Cauthon, Mar 05 '13 at 23:04
You need to use a lambda in the `Any()` method, like in my answer. — Umar Farooq Khawaja, Mar 05 '13 at 23:11

score 35 · Accepted Answer · edited Jun 14 '18 at 00:06

35

Maybe somthing like

C# Linq:

var meds = (from m in Medications 
            where names.Any(name => name.Equals(m.BrandName) || m.GenericName.Contains(name)) 
            select m);

Extension methods:

List<Medication> meds = Medications
    .Where( med =>
        names.Any( name =>
            name.Equals( med.BrandName ) || med.GenericName.Contains( name )
        )
    )
    .ToList();

edited Jun 14 '18 at 00:06

Dai

141,631
28
261
374

answered Mar 05 '13 at 22:54

sa_ddam213

42,848
7
101
110

@Jhorra, your query seems fine then. Could you provide some sample data? And what exactly is not working with your query? – aush Mar 05 '13 at 23:05
Updated my answer with what i think you need – sa_ddam213 Mar 05 '13 at 23:09
Yours came the closest to what I was looking for. I had to tweak it, but it was on the right track and got me what I needed. – Jhorra Mar 06 '13 at 22:23

Umar Farooq Khawaja · Answer 2 · 2013-03-05T23:16:35.120

1

Just do a join between the medication table and the names array.

var query = from m in Medications
            from n in in names
            where m.BrandNames.Any(bn => bn.Contains(n)) || m.GenericNames.Any(gn => gn.Contains(n))
            select m;

edited Mar 05 '13 at 23:16

answered Mar 05 '13 at 23:05

Umar Farooq Khawaja

3,925
1
31
52

score 1 · Answer 3 · answered Mar 05 '13 at 23:11

1

I think you want to try:

var query = Medications.Where(m => names.Contains(m.BrandName) || names.Contains(m.GenericName));

answered Mar 05 '13 at 23:11

chead23

1,859
11
12

it will compare only single value. what if i need to compare both value at time in and condition. – Ankit Mori Aug 22 '18 at 12:11

score 0 · Answer 4 · answered Mar 05 '13 at 22:53

0

If I've understood your right:

var meds = Medications.Where(m => names.Contains(m.BrandName) || names.Contains(m.GenericName));

answered Mar 05 '13 at 22:53

aush

2,108
1
14
24

score 0 · Answer 5 · answered May 08 '16 at 04:25

0

var x = (from c in Reports where c.HKPlanningQty == xi select c).Select(u=>new {Style=u.Style,QTN=u.HKPlanningQty}).OrderBy(u =>u.Style ).Where(v=>v.Style.Contains("44")||v.Style.Contains("58"));

answered May 08 '16 at 04:25

Linkanyway

89
5

Using Linq to do a Contains with multiple values

5 Answers5

Linked