public void Update(ArticleContributor entity)
{
string sql = @"UPDATE [ArticleContributors]
SET [ArticleId] = @ArticleId,
[ContributorId] = @ContributorId,
[ContributionTime] = @ContributionTime
WHERE [Id] = @Id";
_connection.Execute(sql, entity);
}
public void Add(ArticleContributor entity)
{
string sql = "INSERT INTO [ArticleContributors] VALUES(@ArticleId, @ContributorId, @ContributionTime)";
_connection.Execute(sql, new
{
ArticleId = entity.ArticleId,
ContributorId = entity.ContributorId,
ContributionTime = DateTime.Now.ToUniversalTime()
});
}
public void Delete(ArticleContributor entity)
{
string sql = "DELETE FROM [ArticleContributors] WHERE [Id] = @eid";
_connection.Execute(sql, new { eid = entity.Id });
}
