How to get multiple rows in subsonic

Question

Hi, I am using the following

Product objProduct = new Product("active_flag","true");

This one will result multiple row, how can I access the multple rows? ObjProduct will have only one row?

Answer 1

If you're using 2.1 or above you can do the following:

ProductCollection products = DB.Select().From(Product.Schema)
  .Where(Product.Columns.active_flag).IsEqualTo(true)
  .ExecuteAsCollection<ProductCollection>();

Answer 2

Thanks Adam

Answer 3

Another way...

ProductCollection products = new ProductCollection()
   .Where(Product.Columns.active_flag, true)
   .Load();