Click here to Skip to main content
15,901,666 members
Please Sign up or sign in to vote.
2.50/5 (2 votes)
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
Posted
Updated 30-Dec-14 22:46pm
v2
Comments
dorababu407 31-Dec-14 4:16am    
My application should scan tickets without internet it's a client requirement. so i need to get online data to local database.
AbidHussain128 1-Jan-15 5:02am    
is xml you are downloading is service like web service? or it is actual xml file.

1 solution

1.You should use SQLite for local database because of its main features: one of the fastest database for simple CRUD operations, no installation is required (just a simple copy), easy to use from .NET.

2.For transferring data over the internet you should use WCF with net.tcp binding because is the fastest way for transferring data over the internet in .NET application; you have also options to secure your data by using SSL.
Here is an article about this subject: Use Mutual SSL Authentication in WCF[^]

3.When transferring the data read from database, between WCF service and WCF client, you should use pagination - so you should read and send pages of maximum 700 records.
 
Share this answer
 
v2
Comments
dorababu407 3-Jan-15 0:33am    
@Raul lloc : Thank you , i implemented your suggestion , SQL lite with Wcf .
Raul Iloc 3-Jan-15 11:35am    
I am glad that I could help you!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900