Ok! I'm ready to embark on some .NET development for the first time.
好!我已经准备好第一次开始一些.NET开发了。
I've recently installed Microsoft Visual Studio which included Microsoft SQL Sever 2005.
我最近安装了包含Microsoft SQL Sever 2005的Microsoft Visual Studio。
What is the prefered method for programming against a development database? I want to write an ASP.NET application that uses a database and I'm not sure how to create one. In my start menu for SQL Server 2005 all I have is:
对开发数据库进行编程的首选方法是什么?我想编写一个使用数据库的ASP.NET应用程序,我不知道如何创建一个。在我的SQL Server 2005的开始菜单中,我所拥有的是:
- SQL Server Configuration Manager
- SQL Server Error and Usage Reports
- SQL Server Surface Area Config
SQL Server配置管理器
SQL Server错误和使用情况报告
SQL Server表面区域配置
I don't see an intuitive program to create and design databases on that list, so how do I do it?! Will I be creating a full fledged SQL Server database or a "flat-file" fake database to program against?
我没有看到在该列表上创建和设计数据库的直观程序,所以我该怎么做?!我是否会创建一个完整的SQL Server数据库或一个“平面文件”假数据库来编程?
Can someone please tell me what is up on creating my first MS SQL Server 2005 database?
有人可以告诉我创建我的第一个MS SQL Server 2005数据库是什么?
4 个解决方案
#1
If you've Visual Studio, just goto server explorer, Add a new database connection to your database, and start off.
如果你是Visual Studio,只需转到服务器资源管理器,向数据库添加新的数据库连接,然后开始。
Or, create a new website project in Visual studio, right click the App_Data folder->Add New Item and add a SQL Server database mdf file, which will be attached to the sql server when you run the app. You need to deploy the mdf file when doing a production release :)
或者,在Visual Studio中创建一个新的网站项目,右键单击App_Data文件夹 - >添加新项并添加一个SQL Server数据库mdf文件,该文件将在您运行应用程序时附加到sql server。您需要在执行生产版本时部署mdf文件:)
You might want to watch the videos in ASP.NET website http://www.asp.net/learn/
您可能想在ASP.NET网站上观看视频http://www.asp.net/learn/
Otherwise, consider using Microsoft SQL Server Management Studio (an express edition is also available).
否则,请考虑使用Microsoft SQL Server Management Studio(也可以使用快速版)。
#2
You are looking for Microsoft SQL Server Management Studio Express. Its pretty easy to add a database once you get your head around it.
您正在寻找Microsoft SQL Server Management Studio Express。一旦你了解它就很容易添加一个数据库。
#3
To be clear, the SQL Server included with Visual Studio is an express edition. However, the one thing it is lacking is the SQL Server Management Studio (Express). I'd download and install the express edition that included the management studio (note that VS 2005 and 2008 include SQL Express 2005, you can use either SQL Express 2005 or 2008 for your purposes).
需要说明的是,Visual Studio附带的SQL Server是一个快速版本。但是,它缺少的一件事是SQL Server Management Studio(Express)。我下载并安装包含管理工作室的快速版(注意VS 2005和2008包括SQL Express 2005,您可以使用SQL Express 2005或2008用于您的目的)。
You can create a new database and do everything you need to from within the VS IDE but you'll probably find the SQL Management Studio environment much more intuitive and simpler to use as a beginner.
您可以在VS IDE中创建新数据库并执行所需的一切,但您可能会发现SQL Management Studio环境更直观,更易于初学者使用。
#4
A quick note on SQL Express - Microsoft doesn't suggest it for 'production' environments due to limitations placed on the amount of RAM that Express can see/use and a few other factors. This is one of the few cases in which I agree - if you're doing anything complex that involves large databases or dozens of users then invest in MSSQL Workgroup Edition at least, or for Enterprise projects use MSSQL Standard or Enterprise versions.
关于SQL Express的快速说明 - 由于对Express可以看到/使用的RAM数量以及一些其他因素的限制,Microsoft并未建议将其用于“生产”环境。这是我同意的少数情况之一 - 如果您正在做任何涉及大型数据库或数十个用户的复杂事件,那么至少投资MSSQL Workgroup Edition,或者企业项目使用MSSQL标准版或企业版。
#1
If you've Visual Studio, just goto server explorer, Add a new database connection to your database, and start off.
如果你是Visual Studio,只需转到服务器资源管理器,向数据库添加新的数据库连接,然后开始。
Or, create a new website project in Visual studio, right click the App_Data folder->Add New Item and add a SQL Server database mdf file, which will be attached to the sql server when you run the app. You need to deploy the mdf file when doing a production release :)
或者,在Visual Studio中创建一个新的网站项目,右键单击App_Data文件夹 - >添加新项并添加一个SQL Server数据库mdf文件,该文件将在您运行应用程序时附加到sql server。您需要在执行生产版本时部署mdf文件:)
You might want to watch the videos in ASP.NET website http://www.asp.net/learn/
您可能想在ASP.NET网站上观看视频http://www.asp.net/learn/
Otherwise, consider using Microsoft SQL Server Management Studio (an express edition is also available).
否则,请考虑使用Microsoft SQL Server Management Studio(也可以使用快速版)。
#2
You are looking for Microsoft SQL Server Management Studio Express. Its pretty easy to add a database once you get your head around it.
您正在寻找Microsoft SQL Server Management Studio Express。一旦你了解它就很容易添加一个数据库。
#3
To be clear, the SQL Server included with Visual Studio is an express edition. However, the one thing it is lacking is the SQL Server Management Studio (Express). I'd download and install the express edition that included the management studio (note that VS 2005 and 2008 include SQL Express 2005, you can use either SQL Express 2005 or 2008 for your purposes).
需要说明的是,Visual Studio附带的SQL Server是一个快速版本。但是,它缺少的一件事是SQL Server Management Studio(Express)。我下载并安装包含管理工作室的快速版(注意VS 2005和2008包括SQL Express 2005,您可以使用SQL Express 2005或2008用于您的目的)。
You can create a new database and do everything you need to from within the VS IDE but you'll probably find the SQL Management Studio environment much more intuitive and simpler to use as a beginner.
您可以在VS IDE中创建新数据库并执行所需的一切,但您可能会发现SQL Management Studio环境更直观,更易于初学者使用。
#4
A quick note on SQL Express - Microsoft doesn't suggest it for 'production' environments due to limitations placed on the amount of RAM that Express can see/use and a few other factors. This is one of the few cases in which I agree - if you're doing anything complex that involves large databases or dozens of users then invest in MSSQL Workgroup Edition at least, or for Enterprise projects use MSSQL Standard or Enterprise versions.
关于SQL Express的快速说明 - 由于对Express可以看到/使用的RAM数量以及一些其他因素的限制,Microsoft并未建议将其用于“生产”环境。这是我同意的少数情况之一 - 如果您正在做任何涉及大型数据库或数十个用户的复杂事件,那么至少投资MSSQL Workgroup Edition,或者企业项目使用MSSQL标准版或企业版。