Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Local Database Cache - how to handle changes to the data model RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    I'm using a Local Database Cache syncing with MSSQL

    Is there a best method for making changes to the data model and propagating those changes to the local .sdf file, Sync module and datasets?

    any suggestions would be appreciated.

     

    Thursday, September 16, 2010 9:36 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    unfortunately, schema change propagation is one of the weak points of Sync Fx regardless of whether you use the designer or you code yourself.

    the designer generated code are partial classes that you can extend, a bit more work though and even more work updating the Dataset XSDs.

    you may want to look up the sample code from MS for an Adapter Builder so you can generate the adapters programmatically and override the adapters generated by the designer.

    Thursday, September 16, 2010 2:38 PM