Does SqlCE 4.0 have its own connection provider in Visual Studio 2010?

Question

I am trying to create a new SqlCE 4.0 sdf database , but I'm not sure which communication provider I need to use?

I download CE4.0 from Microsoft separately .... so is there a new provider that we intend to use? Or are we using a 3.5 provider?

Answer 1

An example connection string would look like this:

<add name="integration" connectionString="Data Source=testdb.sdf" providerName="System.Data.SqlServerCe.4.0" />

You should also reference the System.Data.SqlServerCe.dll and the ADO.NET classes that it provides.