How to implement Azure offline sync in C#-win form?

Question

1.00/5 (1 vote)

See more:

C#

i want to write a windows form application , and this application is to be connected with azure cloud sql database.


i am looking for offline sync of azure to local sql express store, it means when internet connectivity is not available application will work in offline mode with local store in  sqlexpress and as soon as connectivity is available it will be sync with azure,



So kindly help me with if anyone  have any idea how to implement this, i have googled alot but not reached anywhere to start with

Posted 13-Jan-16 18:17pm

Kannannns

Updated 24-Jan-16 18:14pm

v2

Add a Solution

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)

Garth J Lancaster · Answer 1 · 2016-01-18T15:55:00

Im not sure if we would know how to help you based on your requirements

(1) .. its not clear what you expect the application to do - your question title says C#-Win form, while your 'content' such as it is just says 'desktop application'

(2) Synchronise is a term thats bandied about that has different meaning - a bit like 'CSV' - so describe what you want to happen to the data

So, lets look at (1) if you were going to design a Windows Forms Application, what do you need to do ? For example

Specify Azure Database and Credentials
Specify SQLite Database location/file
Display any errors

(based on this, what would be wrong with a Command-Line/Console Application ?)

Is the application supposed to run Autonomously ? or Needs User Input

And moving on to (2) as I said above, define 'Synchronise' .... do you mean for example 'make a complete copy' from Azure to SQLite - do you mean 'Copy Changed/Added records from Azure to SQLite'

... you see, its by writing out the requirements and the specifications for a program, that you start breaking it down into managable 'chunks' of functionality