Sync Framework - ComputedColumn is readonly! RRS feed

  • Question

  • I am currently upgrading my application moving it to Windows 8  and SQL Express running on the desktop (formerly I was using CE - but it doesn't look like it will be supported in the long term).  When I call  SqlSyncScopeProvisioning.apply it fails because it is trying to create an insert procedure which updates a computed column.  I used SqlSyncDescriptionBuilder to create the table description but I do see not any way to indicate that this is a readonly computed column.

     (BTW - I am very disappointed  that MS never released a working SQLExpressClientSyncProvider as my topology is Hub Spoke and peer-to-peer is overkill and much more complicated than offline using ChangeTracking - this is even worse given the lack of any future plans for SqlServer CE)

    • Edited by PapaStoke Monday, March 11, 2013 11:08 PM
    Monday, March 11, 2013 2:18 PM


  • pre-create the table and exclude the computed column when you define your scope
    • Marked as answer by PapaStoke Wednesday, March 13, 2013 4:30 PM
    Tuesday, March 12, 2013 11:31 AM