自动更新整个数据库 [英] update whole database automaticaly

问题描述

你好朋友，
我想在15分钟后自动更新数据库.数据将来自实时API
它会存储在我自己的数据库中

hello friends,
i want to update database automatically after 15 minutes.data will come from live api
it would be store in my own database
how it is possible

推荐答案

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

首先，您需要使用一些东西来轮询实时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/[^]

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