Using Up Memory With Insert On SQLServerCE

I have an open connection object in my mobile app. I noticed that whenever I use this to do Insert into my DB the memory in use by the application increase everytime and does not get released until I close down the app (or if I close and dispose the connection object = which I dont want to do really). Just 40 inserts will take up serveral MB of memory.

Any ideas on this?

Using version 3.0.3600.0

Some sample code (cnn is a public variable SqlCeConnetion):


Dim cmdText As String = "INSERT INTO MyTable (theName, theValue) VALUES ( 'Name','Value')"

Try

Dim cmd As SqlCeCommand = New SqlCeCommand

cmd.Connection = cnn

cmd.CommandText = cmdText

cmd.ExecuteNonQuery()

Catch

End Try

cmdText = "SELECT @@Identity"

Try

Dim cmd As SqlCeCommand = New SqlCeCommand

cmd.Connection = objCnn

cmd.CommandText = strCmd

.Id = cmd.ExecuteScalar

Catch

End Try