我正在使用DBContext.Update(ParentEntity)
更新实体。然后我遍历每个实体property.CurrentValue
和property.OriginalValue
。我面临的问题是CurrentValues和OriginalValues是相同的,即使一个属性已更改并且与数据库不同。我期待从数据库中获取OriginalValues。这是在保存更改之前发生的循环。
foreach (var entry in ChangeTracker.Entries())
{
if (entry.Entity is Audit || entry.State == EntityState.Detached || entry.State == EntityState.Unchanged ||entry.Entity is ChangelogUser)
continue;
var auditEntry = new AuditEntry(entry) {TableName = entry.Metadata.Relational().TableName};
auditEntries.Add(auditEntry);
foreach (var property in entry.Properties)
{
if (property.IsTemporary)
{
// value will be generated by the database, get the value after saving
auditEntry.TemporaryProperties.Add(property);
continue;
}
string propertyName = property.Metadata.Name;
if (property.Metadata.IsPrimaryKey())
{
auditEntry.KeyValues[propertyName] = property.CurrentValue;
continue;
}
switch (entry.State)
{
case EntityState.Added:
auditEntry.NewValues[propertyName] = property.CurrentValue;
break;
case EntityState.Deleted:
auditEntry.OldValues[propertyName] = property.OriginalValue;
break;
case EntityState.Modified:
if (property.CurrentValue != null)
{
if (property.OriginalValue != null && property.CurrentValue != null)
{
if (property.IsModified && !property.CurrentValue.Equals(property.OriginalValue))
{
auditEntry.OldValues[propertyName] = property.OriginalValue;
auditEntry.NewValues[propertyName] = property.CurrentValue;
}
}
}
break;
}
}
从这段代码中,我 AWLAYS 获得了相同的 Original 和 Current 值。有没有办法从数据库中获取原始值并将它们设置在实体上?
由于很难获得 EFCore 问题的答案,这是我想出的解决方案。
查看State.Modified部分。我遍历每个实体,然后遍历每个属性。在这种情况下,我使用当前值和原始值来比较它们,并且仅在发生变化时才将它们添加到我的审计表中。
在该方法结束时,我从审计表中删除了未更改的实体。简单的表情包。
您可以使用此var databaseValues = entry.GetDatabaseValues();
To 来满足您的自定义断开连接方案需求。
var auditEntries = new List<AuditEntry>();
foreach (var entry in ChangeTracker.Entries())
{
if (entry.Entity is Audit || entry.State == EntityState.Detached || entry.State == EntityState.Unchanged)
continue;
var auditEntry = new AuditEntry(entry) {TableName = entry.Metadata.Relational().TableName};
auditEntries.Add(auditEntry);
var databaseValues = entry.GetDatabaseValues();
foreach (var property in entry.Properties)
{
if (property.IsTemporary)
{
// value will be generated by the database, get the value after saving
auditEntry.TemporaryProperties.Add(property);
continue;
}
string propertyName = property.Metadata.Name;
if (property.Metadata.IsPrimaryKey())
{
auditEntry.KeyValues[propertyName] = property.CurrentValue;
continue;
}
switch (entry.State)
{
case EntityState.Added:
auditEntry.NewValues[propertyName] = property.CurrentValue;
break;
case EntityState.Deleted:
auditEntry.OldValues[propertyName] = property.OriginalValue;
break;
case EntityState.Modified:
if (property.CurrentValue != null)
{
if (databaseValues[propertyName] != null && property.CurrentValue != null)
{
if (property.IsModified && !property.CurrentValue.Equals(databaseValues[propertyName]))
{
auditEntry.OldValues[propertyName] = databaseValues[propertyName];
auditEntry.NewValues[propertyName] = property.CurrentValue;
}
}
}
break;
}
}
if (auditEntry.NewValues.Equals(auditEntry.OldValues) || auditEntry.NewValues.Count == 0 && auditEntry.OldValues.Count == 0)
{
auditEntries.Remove(auditEntry);
}
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句