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