public PageCollection FetchByQuery(Query qry) { PageCollection coll = new PageCollection(); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public PageCollection FetchAll() { PageCollection coll = new PageCollection(); Query qry = new Query(Page.Schema); coll.LoadAndCloseReader(qry.ExecuteReader()); return(coll); }
public static MettleSystems.dashCommerce.Content.PageCollection GetPageCollection(int varRegionId) { SubSonic.QueryCommand cmd = new SubSonic.QueryCommand( "SELECT * FROM dashCommerce_Content_Page INNER JOIN dashCommerce_Content_Page_Region_Map ON " + "dashCommerce_Content_Page.PageId=dashCommerce_Content_Page_Region_Map.PageId WHERE dashCommerce_Content_Page_Region_Map.RegionId=@RegionId", Region.Schema.Provider.Name); cmd.AddParameter("@RegionId", varRegionId, DbType.Int32); IDataReader rdr = SubSonic.DataService.GetReader(cmd); PageCollection coll = new PageCollection(); coll.LoadAndCloseReader(rdr); return(coll); }