Dynamic Linq 'contains' clause without using placeholder

Question

The syntax given for contains clause is

ids = new int[] {1,2,3,4};
dataContext.Table.Where("@0.Contains(id)", ids);

But what I want is

dataContext.Table.Where("{1,2,3,4}.Contains(id)"); //getting exception here

[ERROR] Expression expected (at index 0)

I need this because the where clause my or may not use the contains method. it depends on how user acts.

score 0 · Accepted Answer · answered Jun 01 '17 at 05:13

0

so I got the answer for this after tinkering for sometime. So posting the answer here.

 dataContext.Table.Where("new Int[]{1,2,3,4}.Contains(id)");

You can use whatever datatype you need. I use reflection to find datatype and use that accordingly.

answered Jun 01 '17 at 05:13

Sujit.Warrier

2,815
2
28
47

this is wrong answer,How To Execute query , This Query Where cause has some invalid arguments – kari kalan Jun 01 '17 at 05:52
its dynamic linq dude – Sujit.Warrier Jun 01 '17 at 08:16

score 0 · Answer 2 · answered Jun 01 '17 at 05:16

0

try code:

int[] ids= {1,2,3,4};

dataContext.Table.Where(c=>c.ids.Contains(t.id)).ToList();

Or

var result= (from p in dataContext.Table.AsEnumerable()
                      join q in ids on p.id equals q
                        select p).Distinct() .ToList();

answered Jun 01 '17 at 05:16

kari kalan

497
3
20

1

But why are you using Dynamic LINQ when you don't need to? – NetMage Jun 01 '17 at 21:47
i do need to use it.Every column and every filter condition is determined at runtime – Sujit.Warrier Jun 28 '17 at 06:07

Dynamic Linq 'contains' clause without using placeholder

2 Answers2