CODEWITHSUNDEEP
entity-frameworksql-server-ce
id.ot
id.ot

Reputation: 3131

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

Project is using:

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.

Upvotes: 1

Views: 466

Answers (1)

id.ot
id.ot

Reputation: 3131

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

Upvotes: 1

Related Questions