Error Using SQLCE 3.5 In A VS.NET 2008 Desktop Application

Hi,

I was migrating one of my applications to VS.NET 2008 to start testing the new platform and encountered an error. One of my application requires the use of System.Data.SqlServerCe namespace to create a SQL Server CE database on a desktop machine.

The error is raised when I try to use a SqlCeCommand to insert rows in a table using parameters. If the order of the fields in the INSERT command does not match the order of the fields in which the table was created, an error is raised.

Investigating further, I noticed that the INSERT command was trying to insert the value of a parameter in an incorrect field. For example, the value for the field23 was being inserted into field22.

It looks like the SQL CE engine is rearranging the fields in the INSERT command to match the order of the fields in the table, but forgets to rearrange the parameters of the SqlCeCommand as well.

I give the example codes in the next posts. I will give it in both VB.NET and C#.

For both versions, you just need to create a Windows Application and add a reference to System.Data.SqlServerCe.dll. Insert the corresponding code into the Form1 partial class.

In the example, the constant RaiseError can be set to Boolean.True in order to raise the error. Set it to Boolean.False to execute correctly.