Retrieving all data matching search criteria

Simple.Data method FindAll is used to retrieve all data that satisfy search criteria.

Find all products with product category 1:

IEnumerable<dynamic> products = _db.Products.FindAll(_db.Products.ProductName.Category == 4);
Assert.NotEmpty(products);

Find all products with the length of name equal to 4:

IEnumerable<dynamic> products = _db.Products.FindAll(_db.Products.ProductName.Length() == 4);
Assert.NotEmpty(products);

---

See also:
Simple.Data documentation for FindAll