This is a migrated thread and some comments may be shown as answers.

Design/Capability Question

1 Answer 38 Views
Development (API, general questions)
This is a migrated thread and some comments may be shown as answers.
This question is locked. New answers and comments are not allowed.
Garry
Top achievements
Rank 1
Garry asked on 24 Mar 2010, 05:08 PM
I have a new application in which I am wanting to use OpenAccess as my DAL. However part of my requirements is that I must be able to create a local database cache which will contain some readonly data along with some tables that actually will need to be synchronized.

Basically the readonly tables will contain residents and unit information from an already existing application database. The tables that will need to be synch will be addon tables to track information not already contained in the existing application.

This application will be ran on laptops that will often be disconnected from the network thus the need for the local database cache.

What is the best way to use OpenAccess in this scenario? Also any tips on the best way to architect this thing out would be appreciated as well. This the first time I have been asked to do a disconnected model this way.

Thanks!

1 Answer, 1 is accepted

Sort by
0
Alexander
Telerik team
answered on 26 Mar 2010, 09:22 AM
Hi Garry Clark,

I think you can use the approach described in this thread. There is some code that shows how to obtain a connection to the local or to the distant database. However you will have to write manually the logic for synchronization and determining which connection to be used.
Please let us know if this does not suit your scenario or need more details.

Greetings,
Alexander
the Telerik team

Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Public Issue Tracking system and vote to affect the priority of the items.
Tags
Development (API, general questions)
Asked by
Garry
Top achievements
Rank 1
Answers by
Alexander
Telerik team
Share this question
or