public void InsertLocation(Entities.Location entity) { _dbConnection.Execute("INSERT INTO Location VALUES(@Id, @Name, @Path, @Image, @Index)", new { Id = entity.Id, Name = entity.Name, Path = entity.Path, Image = entity.Image, Index = entity.Index }); }
public void UpdateLocation(Entities.Location entity) { _dbConnection.Execute( "UPDATE Location SET Name = @Name, Path = @Path, Image = @Image, [Index] = @Index WHERE Id = @Id", new { Id = entity.Id, Name = entity.Name, Path = entity.Path, Image = entity.Image, Index = entity.Index }); }