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);
}
