Visual Studio 2008: Database changes not commited. Everything works outside of VS after building.

Question

I have a simple application that fills data into a Microsoft SQL Compact 3.5 database. The database is included into the designtime of Visual Studio 2008 Express.

Example:

NorthwindTableAdapters.ProductsTableAdapter productsAdapter = new NorthwindTableAdapters.ProductsTableAdapter(); 

// Add a new product 
productsAdapter.Insert("New Product", 1, 1, "12 tins per carton", 14.95m, 15, 0, 10, false);

When I run this application in Visual Studio, it executes without any errors. However, the database stays just empty. No modifications show up in the database.

When I build the project and run the application manually from the Projects...\bin\release\ folder it runs just fine and the database is edited normally.

What is wrong in Visual studio that the database changes are not commited?