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