Coffeehouse Thread

5 posts

Forum Read Only

This forum has been made read only by the site admins. No new threads or comments can be added.

Sqlite Sync with windows store app

Back to Forum: Coffeehouse
  • User profile image
    gerdi

    Hi

    I need to sync two sqlite databases over remote connection for a windows store application. The one device, a tablet is generally offline besides the time it needs to sync. I have looked at the sync framework but there seems to be very little documentation on it, or at at least what i can find. 

    The previous version of the app was using sqlserver but now because there is no support for it in the windows store side it makes writing line of business apps a bit tricky. I have the app running as it was with the new windows store ui ( and i just got the MVVM model impelmented => soooo much better! ) i am just struggling with the sync process at the moment. 

  • User profile image
    JoshRoss

    Deletes are a pain in the butt to handle. As long as your tables have a primaryKey and a dateModified column, sync is rather straightforward.

    -Josh

  • User profile image
    JoshRoss

    You could have a table that covered when things where deleted. 

    [Deletes](Id, FromTable, DeletedId, DeletedOn)

    -Josh

  • User profile image
    cbae

    @JoshRoss: Yup. Syncing deletes requires transferring all of the PKs of a given table unless you keep a separate transaction log.

  • User profile image
    JuneT

Conversation locked

This conversation has been locked by the site admins. No new comments can be made.