public override int Insert(Entity.BlogPost entity)
{
return((int)
base.ExecuteScalar <decimal>(
"insert into BlogPost (Content,Created,UserId,Title) values (@Content,@Created,@UserId,@Title) SELECT SCOPE_IDENTITY()",
new SqlParameters
{
{ "Content", entity.Content },
{ "Created", entity.Created },
{ "UserId", entity.UserId },
{ "Title", entity.Title },
}
));
}
public override bool Update(Entity.BlogPost entity)
{
var res = base.ExecuteNonQuery(
"update BlogPost set Content = @Content ,UserId = @UserId, Title =@Title where Id = @Id ",
new SqlParameters
{
{ "Content", entity.Content },
{ "Id", entity.Id },
{ "UserId", entity.UserId },
{ "Title", entity.Title },
}
);
return(res > 0);
}
