Sync Framework - ComputedColumn is readonly!

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)

Answer 1

pre-create the table and exclude the computed column when you define your scope