public TemplateRegionCollection FetchByTemplateId(int templateId)
 {
     IDataReader reader = SPs.FetchTemplateRegionsByTemplateId(templateId).GetReader();
       TemplateRegionCollection templateRegionCollection = new TemplateRegionCollection();
       templateRegionCollection.LoadAndCloseReader(reader);
       return templateRegionCollection;
 }
 public TemplateRegionCollection FetchAll()
 {
     TemplateRegionCollection coll = new TemplateRegionCollection();
     Query qry = new Query(TemplateRegion.Schema);
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public TemplateRegionCollection FetchByQuery(Query qry)
 {
     TemplateRegionCollection coll = new TemplateRegionCollection();
     coll.LoadAndCloseReader(qry.ExecuteReader());
     return coll;
 }
 public TemplateRegionCollection FetchByID(object TemplateRegionId)
 {
     TemplateRegionCollection coll = new TemplateRegionCollection().Where("TemplateRegionId", TemplateRegionId).Load();
     return coll;
 }