private static DbCommand CreateAppSettingsDbCommand(DataAccessMgr dbMgr) { DbTableDmlMgr dmlSelect = dbMgr.DbCatalogGetTableDmlMgr(DataAccess.Constants.SCHEMA_CORE , DataAccess.Constants.TABLE_AppConfigSettings); dmlSelect.SetWhereCondition((t) => t.Column(DataAccess.Constants.TABLE_AppConfigSettings, Constants.ConfigSetName) == t.Parameter(DataAccess.Constants.TABLE_AppConfigSettings, Constants.ConfigSetName, dbMgr.BuildParamName(Constants.ConfigSetName))); dmlSelect.OrderByColumns.Add(1, new DbQualifiedObject <DbIndexColumnStructure>(DataAccess.Constants.SCHEMA_CORE , DataAccess.Constants.TABLE_AppConfigSettings, dbMgr.BuildIndexColumnAscending(Constants.ConfigKey))); DbCommand dbCmd = dbMgr.BuildSelectDbCommand(dmlSelect, 5000); return(dbCmd); }