Design/Capability Question

2 posts, 0 answers
  1. Garry
    Garry avatar
    205 posts
    Member since:
    Nov 2010

    Posted 24 Mar 2010 Link to this post

    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.

  2. Alexander
    Alexander avatar
    727 posts

    Posted 26 Mar 2010 Link to this post

    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.

    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.
  3. DevCraft banner
Back to Top