// Dynamic LINQ

// Doc: https://linq-dynamic.net/dynamic-extensions-methods

​

// @nuget: System.Linq.Dynamic.Core

​

using System;

using System.Linq;

using System.Collections.Generic;

using System.Linq.Dynamic.Core;

public class Program

{

    public static void Main()

    {

         List<Customer> source = new List<Customer>()

         {

             new Customer() { CustomerID = 1, Name = "xyz", LastName="ggg"},

             new Customer() { CustomerID = 2, Name = "Gail",LastName="Cohen"},

             new Customer() { CustomerID = 3, Name = "Gigi N Matthew",LastName="Hadid"},

             new Customer() { CustomerID = 4, Name = "Michael Raheem",LastName="Jackson"},

             new Customer() { CustomerID = 5, Name = "Janice Galvin",LastName="Lebi"},

             new Customer() { CustomerID = 6, Name = "Michael Sullivan",LastName="Johnson"},

             new Customer() { CustomerID = 7, Name = "David Bradley",LastName="Cooper"},

             new Customer() { CustomerID = 8, Name = "David Benshoof",LastName="King"},

                              new Customer() { CustomerID =11, Name = "David aBenshoof",LastName="King"},

                         new Customer() { CustomerID = 12, Name = "David aaBenshoof",LastName="King"},

             new Customer() { CustomerID = 9, Name = "Peter Gilbert",LastName="Rabbit"},

             new Customer() { CustomerID = 10, Name = "Rebecca Bradley",LastName="Rabit"},

         };

        List<Customer> source2 = new List<Customer>();

        var customers = source.AsQueryable();

        string[] names = new[] { "Hadid", "Johnson" };

        try {

            // Throws

        var result = customers

            //  .Where(x=>Array.Exists(names, element => element == x.LastName));

            .Where("LastName In @0", new[] { names });

            foreach (var customer in result.ToList())

            {

                Console.WriteLine(customer.CustomerID + " "+customer.Name);

            }

        }

        catch (Exception ex) {

            Console.WriteLine(ex.ToString());

            Console.WriteLine(ex.StackTrace);

        }

    }

    public class Customer

    {

        public int CustomerID { get; set; }

        public string Name { get; set; }

        public string LastName { get; set; }

        public DateTime LastLogin { get; set; }

        public Boolean IsActive { get; set; }

        public Dictionary<string, object> Properties { get; set; }  

    }

}