using System.Collections.Generic;
using System.Linq.Dynamic.Core;
public static void Main()
Dictionary<string, object> Properties =new Dictionary<string, object>();
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 tttt1= conns.AsQueryable()
.Where("DevicId.Contains(\"45\")").ToList();
foreach (var connn in tttt1)
Console.WriteLine(connn.connid+ " "+ connn.DevicId);
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 int connid { get; set; }
public string status { get; set; }
public string DevicId { get; set; }
public DateTime connDate { get; set; }