Visual Studio 2010 和 SQL Server [英] Visual studio 2010 and Sql Server

问题描述

visual studio 2010 是否已经包含Sql Server 实例，或者我需要安装Sql Server 开发版来开发需要Sql Server db 的应用程序.

Do visual studio 2010 include already Sql Server instance, or I need to install Sql Server developer edition to develop an application that need a Sql Server db.

如果安装了Sql Server express版，就这样就够了还是最好有Sql Server开发版?

If it installs a Sql Server express edition, it this enough or it's better to have Sql Server developer edition?

推荐答案

我认为，如果您进行认真的数据库开发，安装完整的"SQL Server 开发版是有意义的.

I would second that installing the "full" SQL Server Development Edition makes sense if you do serious database development.

但是，您可以同时安装两者，并且 SQL Server Express 非常有用，原因之一是它支持将数据库文件放置在 ASP.NET 应用程序的 App_Data 文件夹中.虽然我不会为我自己的项目这样做，但对于您从 Web 下载的演示或开源应用程序来说，这是一个非常好的功能:只需解压缩，启动 VS，按 F5，您就拥有一个正在运行的解决方案，包括数据库.如果没有 SQL Express，您首先必须移动 MDF 文件、附加数据库、设置用户权限、替换连接字符串等...

However you can have both installed side by side, and having SQL Server Express is very useful for one reason - it supports placing database files in the App_Data folder of ASP.NET applications. While I don't do this for my own projects, it's a very nice feature for demos or open source applications you download from the web: just unzip, start VS, hit F5, and you have a running solution including database. Without SQL Express, you first have to move the MDF file, attach the database, set up user rights, replace the connection strings etc...

这篇关于Visual Studio 2010 和 SQL Server的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！