Data is automatically deleted from SQL Server CE <p>I am trying to write an application in VS2010 c# (Winforms) with SQL Server CE 3.5 as backend. I used the transactions for insertion of data in a table, while testing I inserted 18 rows and everything was OK.</p> <p>But on the next day I found some rows missing, and when I tried to insert new rows, some primary key related error occurred. When I opened the database in SSMS and tried <code>@@Identity</code>, it returned the number 19.</p> <p>I inserted a value into the database from SSMS and when I tried the application everything worked fine. Now the identity column contains values from 1 to 14 and from 19 to 25 (15 to 18 are missing).</p> <p>Now I ask you experts to kindly help me to figure out the reason behind this automatic deletion of data.</p> <p>Thanks a lot </p>