Home / Questions / 128913
Accepted
Ariel Octavio D'Alfeo
Asked: 2020-01-05 11:19:10 +0800 CST 2020-01-05 11:19:10 +0800 CST

Equivalent of Sql's IN() or VFP's InList() in C#

  • 772

Good morning, I have to search through a FOREACH if a field contains any of the strings. Example

  foreach (var item in Clientes.Listado)
                {
                    if (item.Nombre.Contains("Juan") || item.Nombre.Contains("Carlos") || item.Nombre.Contains("Pedro")) 
                    {
                        ...Codigo
                    }
                }

I would like to change item.Nombre.Contains("Juan") || item.Nombre.Contains("Carlos") || item.Nombre.Contains("Pedro") For something more Verbose as in FoxPro that would be

if INLIST(item.Nombre,"Juan","Carlos","Pedro")
c#

1 Answers

  1. Best Answer

    You can just put them into an array and test using .Any()if item.Nombreit contains at least one of the values ​​in the array.

    if (new [] { "Juan", "Carlos", "Pedro" }.Any(x => item.Nombre.Contains(x))) 
{
    //...
}
    • 3