How can I use Visual Studio 2010 Express to connect to SqlExpress for Entity Framework?

entity-framework sql-server-express visual-studio-express

Question

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 http://dl.dropbox.com/u/4163528/images/StackOverflow/2010Express.png

but Visual Studio 2008 Professional has it.

Visual Studio 2008 Professional Screenshot http://dl.dropbox.com/u/4163528/images/StackOverflow/2008Professional.png

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 http://dl.dropbox.com/u/4163528/images/StackOverflow/2010EF.png.

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

1
12
5/23/2017 11:53:15 AM

Accepted Answer

You should be able to select SQL Server Database File, then change the connection string to connect to SqlExpress.

1
4/26/2010 1:52:36 AM

Popular Answer

I just ran into this same problem. Visual Studio C# Express 2010 SP1 only offers me Microsoft SQL Server Compact 3.5 and Microsoft SQL Server Database File when creating or updating ADO.NET Entity Data Model (*.edmx) files.

However my copy of Microsoft Visual Web Developer 2010 Express SP1 is allowing me to add and update ADO.NET Entity Data Model (*.edmx) files in existing solutions and is allowing me to choose the Microsoft SQL Server option when building connection strings.

So the workaround for me is to simply switch between C# & Web Developer when messing with connection strings. Not sure if that's out-of-the-box for everybody or whether I've installed something else that switched the Microsoft SQL Server option on in Web Developer.



Related Questions





Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow