public ConfigEntity GetConfigByConfigName(string ConfigName) { DbCommand cmd = Database.GetSqlStringCommand(Sql_GetConfigByConfigName); Database.AddInParameter(cmd, "ConfigName", DbType.String, ConfigName); DataSet ds = Database.ExecuteDataSet(cmd); if (ds == null || ds.Tables.Count <= 0) { return(null); } if (ds.Tables[0].Rows.Count <= 0) { return(null); } var result = ConfigEntity.CreateEntity(); ClassValueCopier.CopyValueFromDataRow(result, ds.Tables[0].Rows[0]); return(result); }