Of course there is one .sdf file for SQLCE database. I mean that there is a SqlCEEngine class in System.Data.SqlServerCe.dll library. And SqlCeEngine.Shrink function can be used for shrink SqlCE...

Hi,

Why dont you use SqlCeEngine.CreateDB() function to create database.

On the other hand sql server CE has some restrictions. For example there is no Varchar datatype. Instead you have to use...

Hi,

Firstly SqlServerCE.dll is not listed in the .NET referance list. When you install SQL Server CE Runtime it will put required dll's to "C:\Program Files\Microsoft SQL Server Compact Edition\v3.1" or...

Hi,

I dont know will be usefull, but you can shrink or verify your sql compact db via SqlCeEngine class which includes shrink function.

Hi

Instead of using many Insert statement, you can use DataAdapter.Update function. Before send data to SQL DB, insert data to any dataset or datatable which has same schema as database...