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