public void UpdateByQuery()
{
using (var conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySql"].ConnectionString))
{
conn.Open();
var checkInDto = new CheckInDto {
Id = 0,
UserId = 1,
FourSquareId = "asdasd",
Message = "asdasd",
PictureId = 5,
StoreId = 1,
Time = DateTime.Now
};
conn.Upsert(checkInDto);
Assert.That(checkInDto.StoreId, Is.EqualTo(1));
conn.UpdateByQuery <CheckInDto>(
b => b
.Set(x => x.FourSquareId, "Shalom")
.Set(x => x.StoreId, 15),
q => q.Equal(x => x.PictureId, 5)
);
var dto = conn.GetById <CheckInDto>(checkInDto.Id);
Assert.That(dto.StoreId, Is.EqualTo(15));
}
}
public void Upsert()
{
using (var conn = new MySqlConnection(ConfigurationManager.ConnectionStrings["MySql"].ConnectionString))
{
conn.Open();
var checkInDto = new CheckInDto {
Id = 13,
UserId = 1,
FourSquareId = "asdasd",
Message = "asdasd",
PictureId = 5,
StoreId = 123123,
Time = DateTime.Now
};
conn.Upsert(checkInDto);
Console.WriteLine(checkInDto.Id);
}
}
