// 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()

    {

          Dictionary<string, object> Properties =new Dictionary<string, object>();

        Properties.Add("p10",2);

        Properties.Add("p11",4);

        Properties.Add("p135","Test1");

        Properties.Add("p17","2021-10-10T09:48:27.9708889Z");

         Dictionary<string, object> Properties1 =new Dictionary<string, object>();

        Properties1.Add("p10",20);

        Properties1.Add("p11",40);

        Properties1.Add("p135","non");

        Properties1.Add("p17","2000-12-10T09:48:27.9708889Z");

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

         {

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

             new Customer() { CustomerID = 2, Name = "Gail",Properties=Properties1},

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

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

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

             new Customer() { CustomerID = 6, Name = "Michael Sullivan",Properties=Properties1},

             new Customer() { CustomerID = 7, Name = "David Bradley",Properties=Properties1},

             new Customer() { CustomerID = 8, Name = "David Benshoof",Properties=Properties1},

             new Customer() { CustomerID = 9, Name = "Peter Gilbert",Properties=Properties1},

             new Customer() { CustomerID = 10, Name = "Rebecca Bradley",Properties=Properties1},

         };

             List<connection> conns = new List<connection>()

            {

                 new connection() { connid = 1, status = "stored", DevicId="12345"},

                  new connection() { connid = 1, status = "stored", DevicId="4567"},

                  new connection() { connid = 1, status = "stored", DevicId="987"},

                 new connection() { connid = 1, status = "stored", DevicId="1111"}, 

                 new connection() { connid = 1, status = "stored", DevicId="2222"},

             };

        //var list = customers.AsQueryable()

        //  .Where("np(Name)==\"xyz\" or np(Name)==\"Gail\"")

            //.Where("Int32(Properties[\"p10\"])>2 and (Properties.ContainsKey(\"p11\") and Int32(Properties[\"p11\"])>5) and Convert.ToString(Properties[\"p135\"]).Contains(\"non\")")

            //.Where("Convert.ToDateTime(Properties[\"p17\"])>Convert.ToDateTime(\"2021-05-10T09:48:27.9708889Z\")")

​

        //  .ToList();

        //var tttt= customers.AsQueryable()         

            //.Where("@0.Contains(it.CustomerID)", new List<int>() { 1, 2,9 })

            //.Where("CustomerID==1 or CustomerID==2 or CustomerID==10")

            //.Where("Convert.ToDateTime(Properties[\"p17\"])>Convert.ToDateTime(\"2021-05-10T09:48:27.9708889Z\")")

            //.Where("CustomerID In (11) ")

            //.Where("Name In (\"Rebecca Bradley\") ")

            //.ToList();

        //foreach (var customer in tttt)

       // {

        //  Console.WriteLine(customer.Name+ " "+ customer.Properties["p10"]);

        //}

            var tttt1= conns.AsQueryable()

                .Where("DevicId.Contains(\"45\")").ToList();

                    foreach (var connn in tttt1)

        {

            Console.WriteLine(connn.connid+ " "+ connn.DevicId);

        }

    }

    public class Customer

    {

        public int CustomerID { get; set; }

        public string Name { get; set; }

        public string Description { get; set; }

        public DateTime LastLogin { get; set; }

        public Boolean IsActive { get; set; }

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

    }

    public class connection

    {

        public int connid { get; set; }

        public string status { get; set; }

        public string DevicId { get; set; }

        public DateTime connDate { get; set; }

    }

​

}