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