When setup database merge replication, rowguid columns are added to every table automatically, identity cannot be used as primary key in this replication.
This rowguid column has default value, so your app doesn’t need to be updated … but, in EF you can update model from database schema, then all these rowguid columns are imported … and EF will raise error build. 😦
Column MyTable.rowguid in table MyTable must be mapped: It has no default value and is not nullable.
The quick&dirty solution is: edit .edmx file, and delete all rowguid columns, and everything related.
A better solution is to write an EF
add-in extension, in order to filter away rowguid columns …
unfortunately, I can’t provide any link because can’t remember where I read that tip 😦
here is a post: Error 3032 during EF 4.0 validation , last reply by JendaPearl
hope it helps! 😉
Technorati tags: SQL Server, Entity Framework