如何确定 Linq-To-Sql 对象中哪些字段发生了变化

作者: 内涵女神苏晴儿爷
来源: 51数据库
2022-12-13

问题描述

我有一个 linq-to-sql 数据库，我想在其中记录对实体所做的一些更改.现在，我通过读取 DataContext.GetChangeSet().Updates 属性来获取更新的实体，但这并没有为我提供来自已更改实体的字段.

I I have a linq-to-sql database in which I want to log some of the changes made to an entity. Right now, I'm getting the updated entities by reading the DataContext.GetChangeSet().Updates property, but that doesn't provide me with the fields from the entity that were changed.

有没有办法知道更新的实体中修改了哪些字段??

Is there a way to know which fields were modified in an updated entity??

谢谢

推荐答案

DataTable 有一个 GetModifiedMembers 方法，该方法将返回已更改为指定实体实例的成员列表.

The DataTable has a method GetModifiedMembers that will return a list of members that have changed for a specified entity instance.

DataClasses1DataContext context;
Class1 instance = context.GetChangeSet().Updates.OfType<Class1>().First();
context.Class1s.GetModifiedMembers(instance);

推荐阅读