public static Areametadata Load(System.Nullable<int> SysId) {
     resourceSchema.Dal.Areametadata dbo = null;
     try {
         dbo = new resourceSchema.Dal.Areametadata();
         System.Data.DataSet ds = dbo.AreaMetaData_Select_One(SysId);
         Areametadata obj = null;
         if (GlobalTools.IsSafeDataSet(ds)) {
             if ((ds.Tables[0].Rows.Count > 0)) {
                 obj = new Areametadata();
                 obj.Fill(ds.Tables[0].Rows[0]);
             }
         }
         return obj;
     }
     catch (System.Exception ) {
         throw;
     }
     finally {
         if ((dbo != null)) {
             dbo.Dispose();
         }
     }
 }
 public static AreametadataCollection GetAll() {
     resourceSchema.Dal.Areametadata dbo = null;
     try {
         dbo = new resourceSchema.Dal.Areametadata();
         System.Data.DataSet ds = dbo.AreaMetaData_Select_All();
         AreametadataCollection collection = new AreametadataCollection();
         if (GlobalTools.IsSafeDataSet(ds)) {
             for (int i = 0; (i < ds.Tables[0].Rows.Count); i = (i + 1)) {
                 Areametadata obj = new Areametadata();
                 obj.Fill(ds.Tables[0].Rows[i]);
                 if ((obj != null)) {
                     collection.Add(obj);
                 }
             }
         }
         return collection;
     }
     catch (System.Exception ) {
         throw;
     }
     finally {
         if ((dbo != null)) {
             dbo.Dispose();
         }
     }
 }