Linq search (.Contains) across all items in a rows at once?

Question

Is there a way to do a contains search in linq across all the rows at once rather than list them out.

At the moment I am doing

    Data.Where(
        x => x.Name.Contains(searchValue) ||
        x.Address.Contains(searchValue) || 
        x.Id.ToString().Contains(searchValue)... etc

What would I like to do is pass in a generic and have it search across all the data in the rows?

e.g. Data.Where(x => row.Contains(searchValue))

Possible duplicate of [linq search multiple columns](https://stackoverflow.com/questions/18292618/linq-search-multiple-columns) — Hooman Bahreini, Jun 26 '18 at 09:30
Possible duplicate of [LINQ query any of the properties contains string](https://stackoverflow.com/questions/23527545/linq-query-any-of-the-properties-contains-string) — Lucifer, Jun 26 '18 at 09:35
Moreover, how `.ToString()` will be translated to SQL at all? May be you should create computed property like `Name + '@' + Id + '@' + ...` and search by it? — Slava Utesinov, Jun 27 '18 at 07:12

Antonio Campagnaro · Answer 1 · 2018-06-26T09:40:02.720

0

Duplicate of LINQ query any of the properties contains string

You can use reflection but it isn't good for performance

list.Where(x => x.GetType()
            .GetProperties()
            .Any(p =>
            {
                var value = p.GetValue(x);
                return value != null && value.ToString().Contains("some string");
            }));

EDIT: Like Fabio said this will filter list in memory, not in sql.

edited Jun 26 '18 at 09:40

answered Jun 26 '18 at 09:31

Antonio Campagnaro

546
6
15

4

Will not work for SQL, OP have SQL tag, assume that linq will generate sql – Fabio Jun 26 '18 at 09:35
1

Side note to the Edit: Filtering in memory i.e. `Data.AsEnumerable().Where(...)` even if it's possible can well appear be *inefficient* (you fecth a *long cursor* into memory and then obtain just a *few records* after filtering) – Dmitry Bychenko Jun 26 '18 at 09:42

score -2 · Answer 2 · edited Jun 27 '18 at 00:07

-2

You can add a property for your data type with a getter method that joins other properties:

public string JoinedProperty{
   get{
      return Name+" "+Id.ToString();
   }
}

and then this code can help you

Data.Where(
    x => x.Contains(searchValue) ... etc

edited Jun 27 '18 at 00:07

Zer0

7,191
1
20
34

answered Jun 26 '18 at 09:35

Nima Yazdi

27
9

Linq search (.Contains) across all items in a rows at once?

2 Answers2