This question is locked. New answers and comments are not allowed.
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!
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!