public DespatchNotePalletIdCollection FetchAll()
 {
     DespatchNotePalletIdCollection coll = new DespatchNotePalletIdCollection();
     Query qry = new Query(DespatchNotePalletId.Schema);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public DespatchNotePalletIdCollection FetchByQuery(Query qry)
 {
     DespatchNotePalletIdCollection coll = new DespatchNotePalletIdCollection();
     coll.LoadAndCloseReader(qry.ExecuteReader()); 
     return coll;
 }
 public DespatchNotePalletIdCollection FetchByID(object PalletId)
 {
     DespatchNotePalletIdCollection coll = new DespatchNotePalletIdCollection().Where("pallet_id", PalletId).Load();
     return coll;
 }