public IOrderedEnumerable<PurchaseOrder> GetPurchaseOrdes()
{
PurchaseOrderCollection collection = new PurchaseOrderCollection();
using (PurchaseOrderDataAdapter adapter = new PurchaseOrderDataAdapter())
{
IDataReader dr = adapter.GetPurchaseOrders();
while (dr.Read())
{
collection.Add(PopulateReader(dr));
}
dr.Dispose();
adapter.Dispose();
}
return collection.OrderByDescending(P=>P.Id);
}
public void GetPurchaseOrders()
{
PurchaseOrderDataAdapter adapter = new PurchaseOrderDataAdapter();
IDataReader reader = adapter.GetPurchaseOrders();
}