Solved

adding sql server compact edition connection in Visual Studio 2013

Posted on 2014-03-06
1
1,373 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 78

Accepted Solution

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

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

How to install Selenium IDE and loops for quick automated testing. Get Selenium IDE from http://seleniumhq.org (http://seleniumhq.org) Go to that link and select download selenium in the right hand columnThat will then direct you to their downlo…
Real-time is more about the business, not the technology. In day-to-day life, to make real-time decisions like buying or investing, business needs the latest information(e.g. Gold Rate/Stock Rate). Unlike traditional days, you need not wait for a fe…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now