public DespatchNoteCollection FetchAll()
 {
     DespatchNoteCollection coll = new DespatchNoteCollection();
     Query qry = new Query(DespatchNote.Schema);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public DespatchNoteCollection FetchByQuery(Query qry)
 {
     DespatchNoteCollection coll = new DespatchNoteCollection();
     coll.LoadAndCloseReader(qry.ExecuteReader()); 
     return coll;
 }
 public DespatchNoteCollection FetchByID(object DespatchId)
 {
     DespatchNoteCollection coll = new DespatchNoteCollection().Where("despatch_id", DespatchId).Load();
     return coll;
 }