public void TriggerMustSetVallueWhenNotSetManuallyOnUpdate() { using TestDatabase korm = CreateTestDatabase(); var dbSet = korm.Query <Data_AutoIncrementId_WithoutTriggerValue>().AsDbSet(); var item1 = new Data_AutoIncrementId_WithoutTriggerValue { FirstName = "Lorem 10", Age = 10 }; var item2 = new Data_AutoIncrementId_WithoutTriggerValue { FirstName = "Lorem 20", Age = 20 }; dbSet.Add(item1); dbSet.Add(item2); dbSet.CommitChanges(); dbSet.Clear(); item1.Age = item1.Id * 20; item2.Age = item2.Id * 20; dbSet.Edit(item1); dbSet.Edit(item2); dbSet.CommitChanges(); foreach (var item in korm.Query <Data_AutoIncrementId_WithTriggerValue>()) { item.Age.Should().Be(item.Id * 20); item.AutoValue.Should().Be(item.Age * 100); } }
public void ReturnCorrectAutoIncrementIdsAfterInsertTrigger_ValueSetByTrigger() { using TestDatabase korm = CreateTestDatabase(); var dbSet = korm.Query <Data_AutoIncrementId_WithoutTriggerValue>().AsDbSet(); var item1 = new Data_AutoIncrementId_WithoutTriggerValue { FirstName = "Lorem 10", Age = 10 }; var item2 = new Data_AutoIncrementId_WithoutTriggerValue { FirstName = "Lorem 20", Age = 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 * 10); } }