更改数据库记录时自动更新数据集 [英] Automatic Dataset updation when DB records are changed

问题描述

我已经编写了一个c#.net WCF服务，其中Dataset1包含主数据，我在整个服务中都使用了此数据，如果有人从外部更改了主数据，我将找不到它.

为此，我每次访问主数据.

您能告诉我，当数据库自动发生更改时，服务中有什么技术要知道吗?

提前谢谢.

问候
Murty DVSR

Hi,

I have written one c#.net WCF Service, in that Dataset1 contains Master data, i am using this data in the entire service, if someone changes the Master data from outside, i am not able to find that.

for that everytime i am accessing the master data.

Can you please tell me, is there any technique to know in the service, when database change happens automatically?

Thanks in advance.

Regards
Murty DVSR

推荐答案

您现在可以将.NET代码添加到SQL Server中，并且可以创建触发器来告诉您数据是否已更改或更新.

You can add .NET code to SQL Server nowadays and you can create a trigger to tell you if data was changed or updated.

这篇关于更改数据库记录时自动更新数据集的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！