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