Entity Framework 5 and SQL Server CE: execute generated db schema

Question

Project is using:

ASP.NET MVC4
Entity Framework 5
SQL Server CE
IDE: Visual Studio Express 2012

Issue:

Entity Framework (model-first) has you add your models in the .edmx then you right-click the .edmx to generate database schema. However in VS Express we're unable to right-click the .sqlce file contents to load the option to "Execute Ctrl+Shift+E" the way we can in Visual Studio.

Question:

How can I run the script that was generated by the Entity Framework?

Previous attempts:

So far I've tried to open the Compact database in SQL Server Management Studio but I return an error that SSMS can't load the compact db because it's not the correct type also from Database Explorer I've pasted the script into a NewQuery window and ran the script but threw errors as well.

You may need to "fix" the script, as I describe here: erikej.blogspot.dk/2013/02/… - and the run it with the SQL Server Compact Toolbox (standalone) — ErikEJ
– ErikEJ, Commented Mar 11, 2013 at 8:40

id.ot · Accepted Answer · 2013-04-30 04:22:56Z

1

I downloaded SQL Server Compact Toolbox and was able to run the script. Thanks and credit to ErikEJ.

answered Apr 30, 2013 at 4:22

id.ot

3,1511 gold badge34 silver badges47 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework 5 and SQL Server CE: execute generated db schema

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related