How to connect to SqlExpress for Entity Framework using Visual Studio 2010 Express?

Posted by Mike on Stack Overflow See other posts from Stack Overflow or by Mike
Published on 2010-04-26T01:27:41Z Indexed on 2010/04/26 1:33 UTC
Read the original article Hit count: 462

Filed under:

visual-studio-express

|

sql-server-express

|

entity-framework

Hi everyone,

I'm trying to use the Visual Studio 2010 Express editions to set up an ASP.NET MVC 2 Web Application using SqlExpress + Entity Framework as the data access. I have both the "C# Edition" and "Web Developer Edition" installed.

If I try to add a data source using the "C# edition", I'm missing the "Microsoft SQL Server" data source type.

Visual Studio 2010 Express Screenshot

but Visual Studio 2008 Professional has it.

Visual Studio 2008 Professional Screenshot

as noted by another StackOverflow question, the "Web Developer Edition" has this. However, the Web Developer Edition doesn't support the Entity Framework items: EntityFramework .

I'd want to stick with only the Express Editions. Is my use case one that Microsoft forgot about? What can I do here to use SqlExpress + MVC 2 + Entity Framework?

Thanks!

-Mike

© Stack Overflow or respective owner

Related posts about visual-studio-express

IE7 Debugging with Visual Studio Express

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I debug IE7 javascript with Visual Studio Express and which version should I use? >>> More
IE Debugging with Visual Studio Express

as seen on Stack Overflow - Search for 'Stack Overflow'
How do I debug IE javascript with Visual Studio Express and which version should I use? >>> More
Behavior of deployment tool in Visual Studio Express

as seen on Stack Overflow - Search for 'Stack Overflow'
I created a quick game in VS Express (2008) and used the built-in deployment tool (click once?) to create an installer. I took it to another computer, ran it (Windows XP) to install from a burned CD. It created the program but only for the logged in user. Is there a setting I'm missing for installing… >>> More
Windows Forms in Visual Studio Express

as seen on Stack Overflow - Search for 'Stack Overflow'
Good day, can I ask one question about Windows Forms? As far as I know Windows Forms is Win32 wrapper like MFC, created for use with .NET. But, what I dont know is, can you use windows forms and compile directly to native code? Becouse in Visual Studio Express, there is windows forms available only… >>> More
Source Versioning for Visual Studio Express

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there any Visual Studio Express plug ins for source versioning? I am starting a project on my own and only have the Express version of Visual Studio 2008. >>> More

Related posts about sql-server-express

SQL SERVER – Dedicated Access Control for SQL Server Express Edition – An error occurred while obtaining the dedicated administrator connection (DAC) port.

as seen on SQL Authority - Search for 'SQL Authority'
Recently I had faced very interesting situation. Due to some reason we were not able to login into the production server for one of client. The reason for the same was that server was very busy, we had to login into the system and bring server to normal situation. When all the attempts failed, I decided… >>> More
How to create SQL Server Express DB from SQL Server DB

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a SQL Server 2008 DB. I want to extract SOME tables (and associated schema, constraints, indexes, etc) and create a SQL Server Express DB. It isn't a sync of the target, we stomp on it. We ONLY need to do this in the file system (not across the wire). We are not fond of the synchronization… >>> More
Problem with importing an mdf created with SQL Server Express 2008 into SQL Server 2005

as seen on Stack Overflow - Search for 'Stack Overflow'
The question is probably extremely easy to resolve, but I need to resolve it because I need to carry on with my project. I am using SQL Server Express 2008 at home, and I've been working on an ASP.NET MVC app that stores my DB in an mdf file in the project's folder. The problem is that the SQL Server… >>> More
Scheduling Jobs in SQL Server Express - Part 2

as seen on SQL Team - Search for 'SQL Team'
In my previous article Scheduling Jobs in SQL Server Express we saw how to make simple job scheduling in SQL Server 2005 Express work. We limited the scheduling to one time or daily repeats. Sometimes this isn't enough. In this article we'll take a look at how to make a scheduling solution based… >>> More
Scheduling Jobs in SQL Server Express

as seen on SQL Team - Search for 'SQL Team'
As we all know SQL Server 2005 Express is a very powerful free edition of SQL Server 2005. However it does not contain SQL Server Agent service. Because of this scheduling jobs is not possible. So if we want to do this we have to install a free or commercial 3rd party product. This usually isn't allowed… >>> More