public override List<QuickNote> FillQuickNotes(string userId)
{
var notes = new List<QuickNote>();
using (var conn = this.CreateConnection())
{
if (conn.HasConnection)
{
using (var cmd = conn.CreateTextCommand(string.Format("SELECT NoteId, Note, Updated FROM {0}QuickNotes where UserName = '{1}' and BlogId = '{2}'", tablePrefix, userId, Blog.CurrentInstance.Id.ToString())))
{
using (var rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
var n = new QuickNote()
{
Id = rdr.GetGuid(0),
Author = userId,
Note = rdr.GetString(1),
Updated = rdr.GetDateTime(2)
};
notes.Add(n);
}
}
}
}
}
return notes;
}