如何将在线xml文件与Access数据库同步 [英] How to synchronize online xml file with access database

问题描述

I need to synchronize online XML file which given to me from another website with my access database
what I exactly need is to make this sync offline which means that when my website user open the page he will find the last data from xml file

I tried to fix it by deleting all the table data and then using LINQ to read the XML file and insert it to Access database
every time the page load which make delay about 5 min and this is off course not acceptable.
Please Help me with this situation

推荐答案

我建​​议编写Windows服务，该服务将根据您确定的预定时间间隔运行，并将最新XML文件从外部网站下载到您的服务器并将这些XML文件中的数据保存到您的数据库中.

这将帮助您节省宝贵的用户时间，因为您可以安排服务在您知道新的XML文件可用的时间运行(例如，该服务可以运行一整夜，以下载最新文件并将其保存到数据库中). br/>
当然，您可以调整此行为，以使其对您更灵活并且对您的用户更容易.

希望这会有所帮助.

I would recommend writing a Windows service that will run at scheduled intervals as decided by you and download the latest XML files from the external website to your server and save the data in those XML files to your database.

This will help you save precious user time because you can schedule the service to run at a time you know new XML files would be available (for .e.g the service can run over night to download the latest files and save it to database).

Ofcourse, you can tweak this behavior to make it more flexible for you and easy for your users.

Hope this helps a bit.

这篇关于如何将在线xml文件与Access数据库同步的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！