public override List<QuickSetting> FillQuickSettings(string userId)
{
var settings = new List<QuickSetting>();
using (var conn = this.CreateConnection())
{
if (conn.HasConnection)
{
using (var cmd = conn.CreateTextCommand(string.Format("SELECT SettingName, SettingValue FROM {0}QuickSettings where UserName = '{1}' and BlogId = '{2}'", tablePrefix, userId, Blog.CurrentInstance.Id.ToString())))
{
using (var rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
var s = new QuickSetting()
{
SettingName = rdr.GetString(0),
SettingValue = rdr.GetString(1)
};
settings.Add(s);
}
}
}
}
}
return settings;
}