Click here to Skip to main content
15,918,243 members
Please Sign up or sign in to vote.
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
Updated 24-Jan-16 18:14pm
v2

1 solution

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
 
Share this answer
 
Comments
Kannannns 25-Jan-16 0:27am    
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
Garth J Lancaster 25-Jan-16 1:09am    
well, you've just chucked out a very broad question - so you're going to get a very broad answer - if you're doing this commercially, ie, being paid to do it, I'd recommend you look at links like https://msdn.microsoft.com/en-us/library/hh868047.aspx and https://azure.microsoft.com/en-us/documentation/articles/sql-database-get-started-sql-data-sync/ rather than implement a tool from scratch

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