public override List<BlogRollItem> FillBlogRoll()
{
var blogRoll = new List<BlogRollItem>();
using (var conn = this.CreateConnection())
{
if (conn.HasConnection)
{
using (var cmd = conn.CreateTextCommand(string.Format("SELECT BlogRollId, Title, Description, BlogUrl, FeedUrl, Xfn, SortIndex FROM {0}BlogRollItems WHERE BlogId = {1}blogid ", this.tablePrefix, this.parmPrefix)))
{
cmd.Parameters.Add(conn.CreateParameter(FormatParamName("blogid"), Blog.CurrentInstance.Id.ToString()));
using (var rdr = cmd.ExecuteReader())
{
while (rdr.Read())
{
var br = new BlogRollItem
{
Id = rdr.GetGuid(0),
Title = rdr.GetString(1),
Description = rdr.IsDBNull(2) ? string.Empty : rdr.GetString(2),
BlogUrl = rdr.IsDBNull(3) ? null : new Uri(rdr.GetString(3)),
FeedUrl = rdr.IsDBNull(4) ? null : new Uri(rdr.GetString(4)),
Xfn = rdr.IsDBNull(5) ? string.Empty : rdr.GetString(5),
SortIndex = rdr.GetInt32(6)
};
blogRoll.Add(br);
br.MarkOld();
}
}
}
}
}
return blogRoll;
}