C# MVC Dynamic Linq OR Query

Question

I am looking to build this query and am able to do it for 'AND' phrases, but not for 'OR' phrases based off of the format in the link below. The dynamic OR query will be combined with the 'AND' queries.

http://www.codeproject.com/Articles/168981/Guide-to-Creating-Dynamic-LINQ-Queries

I decided to use an expression tree. Thanks! – Sun Sun Ku Feb 04 '14 at 01:00 — Sun Sun Ku, Feb 04 '14 at 01:00

score 1 · Answer 1 · answered Feb 03 '14 at 21:54

1

Out of the box, creating a nested dynamic OR query isn't easily obtainable. You're probably looking for something like Predicate Builder or Dynamic Linq which will allow you to have the control over how things are converted to SQL.

answered Feb 03 '14 at 21:54

Steven V

16,357
3
63
76

score 1 · Accepted Answer · answered Apr 24 '14 at 21:32

1

I ended up using the method in the original link posted with sql queries integrated.

http://www.codeproject.com/Articles/168981/Guide-to-Creating-Dynamic-LINQ-Queries

answered Apr 24 '14 at 21:32

Sun Sun Ku

337
1
6
17

score 0 · Answer 3 · edited May 23 '17 at 11:43

0

What exactly are you trying to query? Do you have any code snippets. From the example you could try modifying this snippet

oDataQuery = oDataQuery.Where(a => a.CustomerID == CustomerID);

to be

oDataQuery = oDataQuery.Where(a => (a.CustomerID == CustomerID) || (a.Something == Something));

Reference this stack overflow question

edited May 23 '17 at 11:43

Community

1
1

answered Feb 03 '14 at 21:57

Gina

33
1
6

1

That's easy to do when the operations are all known at compile time. Not so much when they're dynamic, as this question states. – Servy Feb 03 '14 at 22:02

C# MVC Dynamic Linq OR Query

3 Answers3