SQLCE - Ignoring query execution

Question

Deploying database(*.sdf) to Pocket PC WM 5.0. Via C# i am attempting to DELETE records. The DELETE query returns that 5 rows are affected(there are 5 rows). However, when i view database in Pocket PC under its Query Tool the rows remain. No error or issue arise at my code level.

What is missing? It is the right database because if i rename or delete i get an erro on open. What's wrong?

Answer 1

Are you doing the DELETE in a transaction, and forgetting to .Commit() it?