i want to filter data with month id like 6

Refer this article and check below samples https://www.c-sharpcorner.com/article/how-to-use-data-filtering-operations-with-database-using-linq/ https://odetocode.com/articles/739.aspx var result = yourPaidInfoList.Where(s => s.CurrentMonthpaid=6); 2) var result = from c in yourPaidInfoList where c.CurrentMonthpaid == "6" select c; 3) public static Product[] GetProducts(Guid[] prodIDs) { return (from p in GetProducts() where prodIDs.Contains(p.ProductID) select p).ToArray(); }