/// <summary>
        /// Deletes a ApplicationType record
        /// </summary>
        public static int Delete(ApplicationTypeDO DO)
        {
            SqlParameter _ApplicationTypeID = new SqlParameter("ApplicationTypeID", SqlDbType.VarChar);

            _ApplicationTypeID.Value = DO.ApplicationTypeID;

            SqlParameter[] _params = new SqlParameter[] {
                _ApplicationTypeID
            };

            return DataCommon.ExecuteScalar("[dbo].[ApplicationType_Delete]", _params, "dbo");
        }
        /// <summary>
        /// Creates a new ApplicationType record
        /// </summary>
        public static void Create(ApplicationTypeDO DO)
        {
            SqlParameter _ApplicationTypeID = new SqlParameter("ApplicationTypeID", SqlDbType.VarChar);

            _ApplicationTypeID.Value = DO.ApplicationTypeID;

            SqlParameter[] _params = new SqlParameter[] {
                _ApplicationTypeID
            };

            DataCommon.ExecuteNonQuery("[dbo].[ApplicationType_Insert]", _params, "dbo");
        }
        /// <summary>
        /// Gets all ApplicationType records
        /// </summary>
        public static ApplicationTypeDO[] GetAll()
        {
            SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[ApplicationType_GetAll]", new SqlParameter[] { }, "dbo");

            List<ApplicationTypeDO> objs = new List<ApplicationTypeDO>();

            while(sr.Read()){

                ApplicationTypeDO obj = new ApplicationTypeDO();

                obj.ApplicationTypeID = sr.GetString(sr.GetOrdinal("ApplicationTypeID"));

                objs.Add(obj);
            }

            return objs.ToArray();
        }
        /// <summary>
        /// Selects ApplicationType records by PK
        /// </summary>
        public static ApplicationTypeDO[] GetByPK(String ApplicationTypeID)
        {
            SqlParameter _ApplicationTypeID = new SqlParameter("ApplicationTypeID", SqlDbType.VarChar);

            _ApplicationTypeID.Value = ApplicationTypeID;

            SqlParameter[] _params = new SqlParameter[] {
                _ApplicationTypeID
            };

            SafeReader sr = DataCommon.ExecuteSafeReader("[dbo].[ApplicationType_GetByPK]", _params, "dbo");

            List<ApplicationTypeDO> objs = new List<ApplicationTypeDO>();

            while(sr.Read())
            {
                ApplicationTypeDO obj = new ApplicationTypeDO();

                obj.ApplicationTypeID = sr.GetString(sr.GetOrdinal("ApplicationTypeID"));

                objs.Add(obj);
            }

            return objs.ToArray();
        }