问题描述
大家好,
我使用C#在Windows中创建扫描应用程序。此应用程序的主要任务是从在线SQL数据库获取数据到本地数据库(使用XML文件作为本地数据库)。我需要从在线数据库中只下载一个表,其中包含2个字段,即(票证ID,扫描状态)。记录下载到本地XML文件后,我在扫描票证时将扫描状态从 False更新为,然后将扫描票证数据上传到在线数据库。
我已经使用XML文件完成了这项工作,但问题是下载记录(从在线到XML)和上传(从XML到在线数据库)需要更多时间因为有数以千计的记录。
加载时间问题在这里。所以我正在考虑使用 SQL lite或SQL Compact CE 作为本地数据库而不是XML来加快执行速度。
请建议我我的需求的最佳解决方案
Hi all,
I am created scanning application in windows using C#. Main task of this application is to get data from online SQL database to local database (using XML file as local DB).I need to get download only one table from online DB which having 2 fields i.e (Ticket ID, Scanning Status). After records downloaded to local XML file, i am updating Scanning Status from False to True when ticket is scanned and then uploading Scanned tickets data to online database.
I was already did this work using XML files , but here issue is it took more time for downloading records (from Online to XML) and uploading (from XML to Online Database) because having thousands of records.
Loading time is issue here . so i am thinking about to use SQL lite or SQL Compact CE as local database instead of XML for faster Execution.
Please suggest me the best solution for my requirement
推荐答案
这篇关于为下面的要求建议最佳解决方案的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!