Need multiple where conditions to a query with OR operator

Question

I have a requirement to add multiple where conditions with or operator out of which one where condition will have to check if the db column has any of the item in a list provided. Please consider the query below

var res= from table1 in context.table1
         join table2 in context.table2
         on table1.id equals table2.id
         where table1.name=="res1" || table1.description=="desc"
         || table1.name.any(res=>FreeText.Contains(res))
         select table1

this query is leading the compiler to run query multiple times and I am not getting required result. My end goal is to achieve the following sql query

select * from table1 join table2 on table1.id ==table2.id 
  where table1.name=="res1" || table1.description=="desc" || table1.name like "%item1%" ||table1.name like "%item2% ......"

the like statements should be dynamically added based on the items in the list.

This sounds more like client evaluation (non SQL translatable construct) issue rather than OR operator. What is `FreeText` in your query? — Ivan Stoev, Jan 09 '19 at 18:34
FreeText is a list which contains string which needs to be checked in the where condition as like — bheem prakash, Jan 09 '19 at 18:35
`table1.name.Any(res=>FreeText.Contains(res))` is backwards. That `Any` is from `string`'s `IEnumerable`. You wanted `FreeText.Contains(table1.name)` — Camilo Terevinto, Jan 09 '19 at 18:37
But if `table1.name` is `string`, then `res` must be `char`, right? If `FreeText` is `string[]`, the code should not even compile. — Ivan Stoev, Jan 09 '19 at 18:37
check this answer: https://stackoverflow.com/a/7180331/1745913 — jtate, Jan 09 '19 at 19:15

Sria Pathre · Answer 1 · 2019-01-09T19:10:16.413

-1

try this...

var res= from table1 in context.table1
         join table2 in context.table2
         on table1.id equals table2.id
         where table1.name=="res1" || table1.description=="desc"
         || FreeText.Any(p => table1.name.Contains(p, StringComparison.InvariantCultureIgnoreCase))
         select table1

edited Jan 09 '19 at 19:10

answered Jan 09 '19 at 18:55

Sria Pathre

182
1
10

How would a string contain a list of strings in it? This doesn't even compile – Camilo Terevinto Jan 09 '19 at 18:56
FreeText is a list of string. Each element in the list should be compared to the name column using contains – bheem prakash Jan 09 '19 at 19:07
check the edited answer. I've added StringComparison.InvariantCultureIgnoreCase to ignore case. – Sria Pathre Jan 09 '19 at 19:12

Need multiple where conditions to a query with OR operator

1 Answers1