Search code examples
sql-server-ce

Update requires a valid DeleteCommand when passed DataRow collection with deleted rows

While trying to delete the data from my SQL Server CE 3.5 database, I am getting error:

Update requires a valid DeleteCommand when passed DataRow collection with deleted rows"

While it is ok with Access database.

Please advise. Thanks!

Solution

  • I browsed through several forums and found that we need to follow following to get rid of this error: 1) Add a field in database, say PK, 2) Data Type Bigint, then set Primary Key property to Yes In the lower grid you will see Identity filed getting enabled. By default it is False. 3) Make it True.
    4) IdentityIncrement and IdentitySeed should contain the value 1

    The error shall be resolved.