Offline database

Discussion of open issues, suggestions and bugs regarding Entity Framework support in ADO.NET Data providers
Post Reply
imre.dudas
Posts: 18
Joined: Thu 11 Mar 2010 20:36

Offline database

Post by imre.dudas » Thu 25 Oct 2012 07:09

Hi to all,

I am making a simple registry program by using EntityFramework and dcMySQL 7.1.96. The MySQL database is located on a remote server. However, it was suggested if for some reasons the server is not available (due to connection problems, server maintenance, etc), the program should run in offline mode as well. In other words, users could reach and read data without the possibility of any modifications. Is there a better solution for this than manually copying data into an SQLite database in case of any modification and update, and in offline mode I can retrieve it from there?

Additionally, How can I tell from a database server if it is available or not in runtime, except for using SaveChanges() and we can see status from the result? I want to regularly monitor the status of the server in real time so that my program could automatically turn into offline mode if necessary.

Shalex
Devart Team
Posts: 8033
Joined: Thu 14 Aug 2008 12:44

Re: Offline database

Post by Shalex » Mon 29 Oct 2012 14:07

imre.dudas wrote:Is there a better solution for this than manually copying data into an SQLite database in case of any modification and update, and in offline mode I can retrieve it from there?
"Copying data into an SQLite database" is the only option.
imre.dudas wrote:How can I tell from a database server if it is available or not in runtime, except for using SaveChanges() and we can see status from the result?
Please call SaveChanges() and process the result correspondingly.

Post Reply