public override void UpdateBlogRollItem(BlogRollItem blogRollItem)
{
var blogRolls = BlogRollItem.BlogRolls;
blogRolls.Remove(blogRollItem);
blogRolls.Add(blogRollItem);
using (var conn = this.CreateConnection())
{
if (conn.HasConnection)
{
var sqlQuery = string.Format("UPDATE {0}BlogRollItems SET Title = {1}Title, Description = {1}Description, BlogUrl = {1}BlogUrl, FeedUrl = {1}FeedUrl, Xfn = {1}Xfn, SortIndex = {1}SortIndex WHERE BlogId = {1}BlogId AND BlogRollId = {1}BlogRollId", this.tablePrefix, this.parmPrefix);
using (var cmd = conn.CreateTextCommand(sqlQuery))
{
this.AddBlogRollParametersToCommand(blogRollItem, conn, cmd);
cmd.ExecuteNonQuery();
}
}
}
}