Problem Retrieving Data From SQL CE

Hi,

I am using Visual Studio 2008 with .NET 3.5 Visual Basic. I'm having a problem retrieving data from my SQL CE database.
I have a function that imports a file, parses it and writes the contents to a database. When I then query the database from my code, the data I have just written doesnt seem to be there. Even when i close and re-run the program. Only when I first view the table contents through Visual Studio then re-run the program does the data show up.

The things I know are. When I insert data there is no problem. I can view the data through visual studio server explorer. only when I view data through the server explorer can my code retrieve it.

Could this be something to do with caching? Any help would be appreciated. The (stripped down) code I use to insert data is below

kevin


Dim rowsAffected = 0

Dim connection As New SqlServerCe.SqlCeConnection(connectionstring)
Dim transaction As SqlCeTransaction

' command objects for inserting a ContactList and retrieving its last identity
Dim cmdInsertContactList As New SqlServerCe.SqlCeCommand("INSERT INTO ContactLists (Name, FolderID) VALUES (@Name,@FolderID)")
cmdInsertContactList.Parameters.Add("@Name", SqlDbType.NVarChar)
cmdInsertContactList.Parameters.Add("@FolderID", SqlDbType.NVarChar)

Try

connection.Open()
transaction = connection.BeginTransaction()

cmdInsertContactList.Connection = connection
cmdInsertContactList.Transaction = transaction

' insert a new list
cmdInsertContactList.Parameters("@Name").Value = list.Name
cmdInsertContactList.Parameters("@FolderID").Value = folder.ID
rowsAffected += CInt(cmdInsertContactList.ExecuteScalar())


transaction.Commit()

Finally
connection.Close()
End Try