public CategoryCollection FetchByQuery(Query qry) { CategoryCollection coll = new CategoryCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public CategoryCollection FetchAll() { CategoryCollection coll = new CategoryCollection(); Query qry = new Query(Category.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public static NorthwindAccess.CategoryCollection GetCategoryCollection(int varProductID) { SubSonic.QueryCommand cmd = new SubSonic.QueryCommand("SELECT * FROM [Categories] INNER JOIN [Product_Category_Map] ON [Categories].[CategoryID] = [Product_Category_Map].[CategoryID] WHERE [Product_Category_Map].[ProductID] = PARM__ProductID", Product.Schema.Provider.Name); cmd.AddParameter("PARM__ProductID", varProductID, DbType.Int32); IDataReader rdr = SubSonic.DataService.GetReader(cmd); CategoryCollection coll = new CategoryCollection(); coll.LoadAndCloseReader(rdr); return(coll); }