通过ADO.Net同步SQL数据库
我遇到的问题是如何将 VS 2008 项目中的数据集同步到数据库中的任何更改。
如您所知，我们将数据从数据库读取到断开连接的数据集中，现在假设 1 分钟后更新了数据库中的数据。我想要做的是在设定的时间间隔后检查数据库是否有任何更新，我在数据库的表中已有一列，显示该行上次更新的时间，因此检查此列并返回大于该行的所有行我上次检索数据集的时间。
现在实际的问题是我可以做什么来实现这个结构？我正在考虑有某种经常运行的循环，这将使我的新数据集仅包含已更新的行，但是如何将这些行添加到现有数据集，其中现有数据集将替换任何已更新的行与新数据中的行相同，并添加不在现有数据中但在新数据中的任何行。
我确实查看了 Microsoft 的同步框架和本地缓存，但据我所知，它只适用于我挂接到存储过程的表，除非我错了？
附言。我正在用 C# 编码。
有人可以帮忙吗？
The problem that i'm having is how can i synchronise my datasets in my VS 2008 project to any changes in the database.
As you know we read data from the db into the dataset which is disconnected, now lets say 1 minute later something updates the data in the database. What i want to do is after a set time interval check the db for any updates, i have a column already in my tables in the db that show when that row was last updated and so check this column and return all rows that are greater then the time of my last retrieval into my dataset.
Now the actual issue is what can I do to implement this structure? I was thinking of having some sort of loop that ran every so often which would get my new dataset with only the rows that have been updated but then how do i add those rows to my existing dataset where the existing dataset will replace any rows that are the same with the row from the new data and add any rows that aren't in existing one but are in the new one.
I did look at Sync Framework from Microsoft and the Local Cache but from what i can tell it only works on tables as i am hooking into a Stored Proc, unless i am wrong?
PS. I am coding in C#.
Can anyone help?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
datatable.merge
datatable.merge