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