adding sql server compact edition connection in Visual Studio 2013
Posted on 2014-03-06
I'm using Visual Studio 2013.
In my visual studio asp.net mvc 4 web application I have a database called MvcMusicStore.sdf in my App_Data folder. I believe this is a sql server compact edition 4.0 database.
I'm trying to create an entity framework data model for it.
When I reach the add connection to my data base window under data source my only choice is Micrsoft Sql Server (SqlClient).
My other Data Source choices are:
Microsoft Access Databas File
Microsoft ODBC Data Source
How to I add my sdf database.
Since there is no choice for a sql server compact edition database?
Anyone know how to create an entity data model for a sql server compact edition database using Visual Studio 2013?