public void InsertRealmlist(Entities.Realmlist entity, Guid locationId) { _dbConnection.Execute( "INSERT INTO Realmlist VALUES(@Id, @Name, @Url, @Image, @Index, @LocationId)", new { Id = entity.Id, Name = entity.Name, Url = entity.Url, Image = entity.Image, Index = entity.Index, LocationId = locationId }); }
public void UpdateRealmlist(Entities.Realmlist entity, Guid locationId) { _dbConnection.Execute( "UPDATE Realmlist SET Name = @Name, Url = @Url, Image = @Image, [Index] = @Index, LocationId = @LocationId WHERE Id = @Id", new { Id = entity.Id, Name = entity.Name, Url = entity.Url, Image = entity.Image, Index = entity.Index, LocationId = locationId }); }