Solved

adding sql server compact edition connection in Visual Studio 2013

Posted on 2014-03-06
1
1,451 Views
Last Modified: 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
Oracle Database

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?
0
Comment
Question by:maqskywalker
1 Comment
 
LVL 80

Accepted Solution

by:
David Johnson, CD, MVP earned 500 total points
ID: 39910468
you will have to add sql server compact
http://www.microsoft.com/en-US/download/details.aspx?id=17876
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question