CODEWITHSUNDEEP
databasesynchronizationlocaloffline
Arun
Arun

Reputation: 42

How to create a windows form application which enables users to work offline?

I want to create a windows form application which should be able to do Add/Edit/Delete records on server database when there is connectivity but if there are any connectivity issues the user should still be able to work offline and then sync it back to server when the connection is restored.

I read about Microsoft Sync Framework and Local Database Cache but I don't find Local Database Cache in Visual Studio 2012.

Upvotes: 0

Views: 1106

Answers (2)

JuneT
JuneT

Reputation: 7860

the Local Database Cache was taken out in VS 2012.

You can however use SQL Server Compact Toolbox to something similar, see: SQL SERVER COMPACT TOOLBOX SYNC FRAMEWORK SUPPORT

there's no stopping you handcoding the sync using Sync Fx as well.

Upvotes: 0

user2195244
user2195244

Reputation:

You can have your own data set which can be updated offline. The only thing is just write the data set to an XML file and when ever the user changes, update the dataset and rewrite the corresponding data set XML using the ds.writexml and ds.writexmlschema methods.

Upvotes: 1

Related Questions