I want to access SqlServerCe database through my desktop C#.Net application, so that I can insert huge records very fast and then copy this database file to Pocket PC device.

For inventory purpose, I have to insert 14,000 records in SqlServerCe database. It is taking much time. I am building a desktop application/smart device application and giving the path for SqlCeConnection("Data Source=C:\\mydatabase; Password=p;");

I added the reference to System.Data.SqlServerCe.dll by browing to "D:\Program Files\Microsoft Visual Studio .NET 2003\CompactFrameworkSDK\v1.0.5000\Windows CE".
But doing this gives me a waning message this will alter your existing references. and then my form designer corrupts, however code exists.

Alternatively I build Smart Application and give the same path SqlServerCe database. Compilation OK, and even run if i don't use SqlServerCe database statements. But when write SqlServerCe statements , at runtime this gives me message "The assembly System.Data.SqlServerCe.dll was invalid".

I have another idea to use Emulator to get my fast database insertion, but don't know how to invoke Emulator through my application.

Please help me in achieving my fast SqlServerCe database insertions. Because 14,000 records is taking much time.
I will be very thankful.

Arif