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);
}
