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