public void Add(Category domainEntity)
{
string query = @"
INSERT INTO Categories (Term, Scheme, Label)
VALUES (@Term, @Scheme, @Label)
SELECT @@IDENTITY;
";
int newId = _context.Connection.Query<int>(query,
new
{
Term = domainEntity.Term,
Scheme = domainEntity.Scheme,
Label = domainEntity.Label
}).FirstOrDefault();
if (newId != default(int))
{
domainEntity.Id = newId;
}
}
public void Update(Category domainEntity)
{
string query = @"
UPDATE Categories
SET
Term = @Term,
Scheme = @Scheme,
Label = @Label
WHERE Id = @ID";
_context.Connection.Execute(
query,
new
{
Term = domainEntity.Term,
Scheme = domainEntity.Scheme,
Label = domainEntity.Label,
ID = domainEntity.Id
});
}
public void Update(Category domainEntity)
{
this.Repository.Update<Category>(domainEntity);
}
public void Add(Category domainEntity)
{
this.Repository.Add<Category>(domainEntity);
}
