且构网

分享程序员开发的那些事...
且构网 - 分享程序员编程开发的那些事

使用c#将更改从表更改到另一个sql server中的另一个表

更新时间:2022-12-03 14:21:40

问题对我来说不是很清楚。我想你需要存储行版本。如果是这样,你想创建一个单独的表,它就是所谓的历史表。当需要主表插入/更新/删除操作时,在此之前,您只需将主表中的最后一行复制到历史表中,并使用专用标识/版本号等,您可以遵循各种策略。因此,当前一行需要时,您可以转到历史表并选择合适的行版本。





那么,你需要开发一个webservice / wcfservice。它将从互联网上添加/更新产品数据库。当您添加/更新产品时,从您的本地环境(Windows / Web),您还调用新开发webserivce以与您的本地数据库同步Internet数据库。如果您是webserivice世界的新手,那么您首先需要正确理解它,然后才能实现它。
Question not very clear to me. I guess you need to store row version. If so you want to create a separate table, it is so called history table. When main table insert/update/delete operation will need, before that you just copy last row from main table to history table with appropriation identification/version no etc various strategy you can follow. So when previous any row needed then you can go to history table and pick appropriate row version.


Well, Then you need to develop a webservice/wcfservice. It will add/update product database from the internet. From your local environment(windows/web)when you add/update product that time you also call that newly develop webserivce for sync internet database with your local database. If you are new to webserivice world then you first need to understand it properly then you can implement that.