public void TriggerMustNotSetVallueWhenSetManuallyOnUpdate() { using TestDatabase korm = CreateTestDatabase(); var dbSet = korm.Query <Data_AutoIncrementId_WithTriggerValue>().AsDbSet(); var item1 = new Data_AutoIncrementId_WithTriggerValue { FirstName = "Lorem 10", Age = 150, AutoValue = 111 }; var item2 = new Data_AutoIncrementId_WithTriggerValue { FirstName = "Lorem 20", Age = 500, AutoValue = 222 }; dbSet.Add(item1); dbSet.Add(item2); dbSet.CommitChanges(); dbSet.Clear(); item1.Age = item1.Id * 200; item2.Age = item2.Id * 200; item1.AutoValue = item1.Age / 2; item2.AutoValue = item2.Age / 2; dbSet.Edit(item1); dbSet.Edit(item2); dbSet.CommitChanges(); foreach (var item in korm.Query <Data_AutoIncrementId_WithTriggerValue>()) { item.Age.Should().Be(item.Id * 200); item.AutoValue.Should().Be(item.Age / 2); } }
public void ReturnCorrectAutoIncrementIdsAfterInsertTrigger_ValueSetManually() { using TestDatabase korm = CreateTestDatabase(); var dbSet = korm.Query <Data_AutoIncrementId_WithTriggerValue>().AsDbSet(); var item1 = new Data_AutoIncrementId_WithTriggerValue { FirstName = "Lorem 10", Age = 10, AutoValue = -10 }; var item2 = new Data_AutoIncrementId_WithTriggerValue { FirstName = "Lorem 20", Age = 20, AutoValue = -20 }; dbSet.Add(item1); dbSet.Add(item2); dbSet.CommitChanges(); item1.Id.Should().Be(1); item2.Id.Should().Be(2); foreach (var item in korm.Query <Data_AutoIncrementId_WithTriggerValue>()) { item.AutoValue.Should().Be(item.Age * -1); } }