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); }