Visual Studio - Local Database Cache Designer Timeout ? RRS feed

  • Question

  • I am having an issue with the Local Cache Database designer in Visual Studio 2008.  The sqlce providers and sync framework work great in the application as i can override the command timeouts.  But when performing the full sync in the designer to generate the database to publish in the initial install it times out on a particular table. (file data).

    As a work around i have moved this table to the bottom of the list and disabled the table transaction feature, performed the sync, then moved it back to its original position with the transaction feature re-enabled.

    Does anyone have any idea how i can modify the command timeout of the designer code?  I would rather not have to write a separate application to simply generate the original database file to publish.

    Wednesday, March 3, 2010 10:10 PM


  • Hello Richard,

    You can modify the command timeouts by doing one of the two ways:

    1. On the generate code, iterate through DbSyncServer/ClientProvider ::  SyncAdapters collections and explicitly modify Command Timeout properties for each command.

    2. Write a partial class, and do the similar step as 1.

    Let me know how it works out.


    • Marked as answer by Richard_Y Monday, March 8, 2010 3:27 PM
    Friday, March 5, 2010 1:09 AM