INSERT Not Working Via Emulator SmartPhone WM 5.0

It would be great to get some feedback on this, I've wasted nearly the whole day trying to figure it out.

I've created a simple test database called test.sdf. It contains a few tables but no data. My plan is to populate the database programatically; however, the INSERT command does not seem to be working correctly. I can see that the data actually gets added to the database when I add it and iterate over it programatically (using SqlCeCommands), but after the program completes and I look at the Table in "Server Explorer" via VS 2005, the data is no longer there!

Now note that the location of the sdf is in the Emulator's "shared folder." I have read from other posts (http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=173589&SiteID=1) that you cannot create a database on emulated "storage card" with PPC 2005 emulators but I've read nothing about modifying a database which exists there. Unfortunately I do not currently have access to a "real" device so I can't test this in any other way.

Here's the test function:

public void Test()

{

SqlCeConnection conn = null;

try

{

conn = new SqlCeConnection();

conn.ConnectionString = @"Data Source = Storage Card est.sdf";

conn.Open();

SqlCeCommand cmd1 = conn.CreateCommand();

cmd1.CommandText = "INSERT INTO Customers VALUES ('Joe Schmoe')";

int n = cmd1.ExecuteNonQuery();

cmd1.CommandText = "INSERT INTO Customers VALUES ('Alice Wonderland')";

n = cmd1.ExecuteNonQuery();

SqlCeCommand cmd2 = conn.CreateCommand();

cmd2.CommandText = "SELECT * FROM Customers";

SqlCeDataReader rdr = cmd2.ExecuteReader();

//this correctly prints out Joe Schmoe and Alice Wonderland

while (rdr.Read())

{

String str = rdr.GetString(0);

Console.WriteLine(str);

}

rdr.Close();

}

finally

{

conn.Close();

}

}

After running this test function, I open the Customers table in VS2005 and no Customer rows exist despite the fact that the SqlCeDataReader correctly iterated through the previously added 2 customers.