Suggest the best solution for my requirement below

Question

2.50/5 (2 votes)

See more:

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 30-Dec-14 20:46pm

dorababu407

Updated 30-Dec-14 22:46pm

v2

Add a Solution

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Raul Iloc · Accepted Answer · 2014-12-30T21:48:00

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.