Implementing Dynamic LINQ Query with "NOT IN" Clause

Question

I have dynamic string generated from back end which generates expression like:

"Col NOT IN ('ABC','CDE','EDF'...)"

I would like to make use of above string has predicate to my IEnumerable collection. Does Dynamic LINQ supports NOT IN operation?

I have assumed the ABC CDE and EDF values are contained in a string array i.e. notInArray = ["ABC", "CDE", "EDF"]. Could you not simply do collection = collection.Where(i => !notInArray.Contains(i.Col))? — nbokmans
– nbokmans, Commented Jan 2, 2018 at 12:39
IN is Contains in LINQ: stackoverflow.com/q/15633066/861716 — Gert Arnold
– Gert Arnold, Commented Jan 2, 2018 at 12:49
It's not supported directly (in fact Dynamic LINQ supports just a limited set of standard LINQ methods). You have to do parsing yourself. Or modify the backend to generate some more structured query definition instead of string. — Ivan Stoev
– Ivan Stoev, Commented Jan 3, 2018 at 13:33

arhnee · Accepted Answer · 2022-11-15 22:07:48Z

1

It is possible to do this by using a SQL syntax that is much less common, but does the same thing:

"NOT (Col IN ('ABC','CDE','EDF'...))"

This works both for SQL and Dynamic Linq

answered Nov 15, 2022 at 22:07

arhnee

1,05912 silver badges24 bronze badges

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

Comments

Emre Kabaoglu · Accepted Answer · 2018-01-02 15:52:45Z

-1

You didn't provide your sample code but it seems something like;

var array = new [] {"ABD", "ABC", "BED"};
var result = _context.table.Where(x => !array.Any(y => x.Col1 == y));

edited Jan 2, 2018 at 15:52

answered Jan 2, 2018 at 13:13

Emre Kabaoglu

13.2k4 gold badges27 silver badges48 bronze badges

3 Comments

Nikhil Agrawal Over a year ago

var result = _context.table.Where(x => !array.Contains(x.Col1));

Gert Arnold Over a year ago

The question is about Dynamic LINQ.

user145610 Over a year ago

I would like to implement in Dynamic LINQ not through LINQ. My String will be like "'ABC','DEF','GHI'".....comma separator with more than 15000 characters.

Collectives™ on Stack Overflow

Implementing Dynamic LINQ Query with "NOT IN" Clause

2 Answers 2

Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related