public DeliveryNoteTableCollection FetchAll()
 {
     DeliveryNoteTableCollection coll = new DeliveryNoteTableCollection();
     Query qry = new Query(DeliveryNoteTable.Schema);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public DeliveryNoteTableCollection FetchByQuery(Query qry)
 {
     DeliveryNoteTableCollection coll = new DeliveryNoteTableCollection();
     coll.LoadAndCloseReader(qry.ExecuteReader()); 
     return coll;
 }
 public DeliveryNoteTableCollection FetchByID(object DeliveryNoteID)
 {
     DeliveryNoteTableCollection coll = new DeliveryNoteTableCollection().Where("DeliveryNoteID", DeliveryNoteID).Load();
     return coll;
 }