Allow to set a value to IsDbGenerated fields
SQLCE for WP7 should allow us to assign explicitely a value to Identity fields marked as IsDbGenerated fields. Currently SQL Server allows it throw this command. SET IDENTITY_INSERT dbo.TableName ON
It would be great SQLCE for WP7 allows us to set this option using attributes of the Table/Class. In fact other multiplatform databases that work for WP7 as Siaqodb include this and even other features SQLCE for WP7 still not.
Thank you for the suggestion. Going forward, SQLite is a recommended database engine for Universal Windows Platform applications and it always allows inserting a value into the primary key column. For the additional details, please see SQLite documentation – http://www.sqlite.org/autoinc.html
Himadri Sarkar (MSFT) commented
Just curious about what are the specific scenarios where you would like to use this feature?