Solved

adding sql server compact edition connection in Visual Studio 2013

Posted on 2014-03-06
1
1,445 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 79

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

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

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

Suggested Solutions

It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
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 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…

823 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