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

  • Question

  • 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

  • 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