?
Solved

adding sql server compact edition connection in Visual Studio 2013

Posted on 2014-03-06
1
Medium Priority
?
1,601 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 84

Accepted Solution

by:
David Johnson, CD, MVP earned 2000 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

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
Suggested Courses
Course of the Month15 days, 15 hours left to enroll

850 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