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.
Thanks