How can I upgrade my Sql Server CE 3.5 sdf database to Sql Server CE 4.0?

visual-studio-2010 entity-framework-4 sql-server-ce sql-server-ce-4
Pure.Krome picture Pure.Krome · Jan 20, 2011 · Viewed 27.2k times · Source

I need to update my SqlCE3.5 database to 4.0.

I get the following error message when I'm trying to access my 3.5 sdf/database using the new CE4.0 connection provide :-

System.Data.EntityException: The underlying provider failed on Open. ---> System.Data.SqlServerCe.SqlCeInvalidDatabaseFormatException: The database file has been created by an earlier version of SQL Server Compact. Please upgrade using SqlCeEngine.Upgrade() method.

Anyone know how I can do this? Obviously I need to do it programatcially but i'm not sure what I should do / what references I need to add, etc.

Cheers!

Answer

Timores picture Timores · Aug 8, 2012

Call System.Data.SqlServerCe.SqlCeEngine.Upgrade. See MSDN, which contains sample code.

Related questions

Add Controller Model Classes not shown

I managed to create a Model First DBContext model (before it was a normal ObjectContext derived model). Strangly now my VS is not showing ANY of my classes in the Model selectlist in "Add Controller". More or less everything external …

Read More
Using NuGet Package Manager console outside Visual Studio to run Entity Framework Migrations

Is there anyway to open NuGet Package Manager console outside Visual Studio ? My objective is to run some migrations, which I created using EntityFramework.Migrations Basically I want to run Update-Database –Verbose command in an environment which does not have …

Read More
Entity framework doesn't save data entries in database

At first I should mention that this problem only occurs in windows forms applications and the same program in web mode for example with MVC3 works perfect. Some days ago I wrote a very simple windows form program using Visual …

Read More