SQL Server CE and Visual Studio 2013

.net sql-server-ce visual-studio-2013 localdb
Brady Moritz picture Brady Moritz · Nov 23, 2013 · Viewed 8.5k times · Source

So we now know that SQL Server CE is no longer supported with Visual Studio 2013. We can get some access to it via the SQL Server CE Toolbox add-in, but this does not fix the fact that a data provider is not included and thus we can no longer use SQL Server CE with Entity Framework etc.

I haven't yet found an explanation from MS as to why this is now missing, but I've accepted it for now and am looking for ways to move on.

My question is - what is the best migration path for this? I've been using data-first Entity Framework with SQL Server CE, and deploying small websites that use a small .sdf file for the database, and updates are simple to deploy - just copy the file over. SQL Server Express won't work this way. For desktop/WPF/winforms apps I imagine this is even more confusing, as the in-process SQL Server CE database was a great fit for small desktop applications.

Answer

ErikEJ picture ErikEJ · Nov 23, 2013

You can use Database First with the Toolbox in VS 2013, not sure what you are missing? Just right click the database file, and select Create Entity Data Model in current Project. See my blog post here for screenshots: http://erikej.blogspot.dk/2013/10/sql-server-compact-toolbox-36visual.html PS: I am the developer of the Toolbox, let me know what else you are missing.

Related questions

Correct way to close database connection in event of exception

Does the following code leave the connection open if there is an exception? I am using a Microsoft SQL compact edition database. try { SqlCeConnection conn = new SqlCeConnection(ConnectionString); conn.Open(); using (SqlCeCommand cmd = new SqlCeCommand("SELECT stuff FROM SomeTable", conn)) { // …

Read More
Create SQL Server CE database file programmatically

How can I create a new SQL Server Compact database file (.sdf) programmatically, without having an existing template file to copy from?

Read More
Entity Framework Code-First: How to manually update the database?

I've build a little WPF demo app which uses EF Code-First to save its data in a SQL CE 4.0 DB. It works fine unless I remove a property from a model object. For example, if I remove "HosteBy" from this …

Read More