I'm building a C# application that uses a PostgresSQL database (version 9.3) in the cloud for storage. While my office connection is fiber and extremely stable to the db provider that might not be so for my client.
I'm using Devart Entity Developer edition 5.5.164 and of course the dot connect PostgreSQL provider.
The question is if the connection to the database fails while the application is in use, what are the easy to implement options for saving the current status locally to the PC (if any) and secondly when the database comes back on line what synchronization options are available to ensure that the data on the local PC is written to the database successfully.
I have considered a master slave PostgreSQL type setup where a local machine is setup for to serve up the DB and then replicate each change to the Cloud. But the client does not want to manage another system. So this is not an option.
So... any ideas?
Thanks
What are the options for saving data local upon failed connection
Re: What are the options for saving data local upon failed connection
Among the dotConnect products, the cache mechanism is implemented only in dotConnect for Salesforce: http://www.devart.com/dotconnect/salesf ... cache.html.
With dotConnect for PostgreSQL, you should implement caching yourself.
With dotConnect for PostgreSQL, you should implement caching yourself.