且构网

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

自动更新整个数据库

更新时间:2023-02-03 22:28:30

有多种方法可以实现此目的.

首先,您需要使用一些东西来轮询实时API,这可以是通过计划任务调用的控制台应用程序,也可以是Windows服务:

http://msdn.microsoft.com/en-us/library/0wc2kk78%28v = vs.90%29.aspx [ ^ ]

http://support.microsoft.com/kb/308569 [ http://msdn.microsoft.com/en-us/library/d56de412%28v = vs.100%29.aspx [ ^ ]

然后,一旦您有权访问数据,就需要将其保存到数据库中.我假设它是SQL Server,因为您没有另外声明,因此可以选择SqlClient,Entity Framework或NHibernate:

http://www.csharp-station.com/Tutorial/AdoDotNet [ http://msdn.microsoft.com/en-gb/data/ef.aspx [ ^ ]

http://nhforge.org/ [ ^ ]
There''s a number of ways you can accomplish this.

To start with, you need something to poll the live API with, this could either be a console application invoked via a scheduled task, or a windows service:

http://msdn.microsoft.com/en-us/library/0wc2kk78%28v=vs.90%29.aspx[^]

http://support.microsoft.com/kb/308569[^]

http://msdn.microsoft.com/en-us/library/d56de412%28v=vs.100%29.aspx[^]

Then once you have access to the data, you''ll need to save it to your database. I''m assuming it''s SQL Server because you haven''t stated otherwise so you could either go for a SqlClient, Entity Framework or NHibernate:

http://www.csharp-station.com/Tutorial/AdoDotNet[^]

http://msdn.microsoft.com/en-gb/data/ef.aspx[^]

http://nhforge.org/[^]