using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using ZocMonLib;

namespace ZocMonLib
{
    public class StorageCommandsSetupSqlServer : IStorageCommandsSetup
    {
        public virtual IEnumerable<ReduceLevel> SelectAllReduceLevels(IDbConnection conn)
        {
            return DatabaseSqlHelper.CreateListWithConnection<ReduceLevel>(conn, StorageCommandsSqlServerQuery.ReduceLevelSql);
        }

        public virtual IEnumerable<MonitorConfig> SelectAllMonitorConfigs(IDbConnection conn)
        {
            return DatabaseSqlHelper.CreateListWithConnection<MonitorConfig>(conn, StorageCommandsSqlServerQuery.MonitorConfigSql);
        }
    }
}
using System;
using System.Collections.Generic;
using System.Data;
using System.Text;
using ZocMonLib;

namespace ZocMonLib
{
    public class StorageCommandsSetupSqlServer : IStorageCommandsSetup
    {
        public virtual IEnumerable<ReduceLevel> SelectAllReduceLevels(IDbConnection conn)
        {
            const string sql = @"SELECT * FROM ReduceLevel";

            return DatabaseSqlHelper.Query<ReduceLevel>(conn, sql);
        }

        public virtual IEnumerable<MonitorConfig> SelectAllMonitorConfigs(IDbConnection conn)
        {
            const string sql = @"SELECT * FROM MonitorConfig";

            return DatabaseSqlHelper.Query<MonitorConfig>(conn, sql);
        }
    }
}
Switch over setup commands from using query class
Switch over setup commands from using query class
