Connecting ASP.NET MVC2 App to SQL Server

Question

So I have a database running in SQL Server Management Studio.

The server information in the top of the Object Explorer says this:

(local)(SQL Server 10.0.2531 - Scott-PC\Scott)

How do I connect my ASP.NET MVC2 App to this instance. I want a connection string in the web.config and then I want to be able to have a Database.cs class that performs all the stored proc and queries.

JoR · Accepted Answer · 2010-11-07 17:02:43Z

1

Data Source=Scott-PC;Initial Catalog=DatabseName;User Id=Scott;Password=password;

check here for other options

answered Nov 7, 2010 at 17:02

JoR

3051 gold badge4 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

cHao · Accepted Answer · 2011-07-10 09:21:47Z

0

Here is a sample...

<connectionStrings>
 <add name="ProductionServerEntities"
      connectionString="metadata=res://*/Models.MyDBEntityModel.csdl|res://*/Models.MyDBEntityModel.ssdl|res://*/Models.MyDBEntityModel.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=MYSQLSERVER;attachdbfilename=C:\inetpub\domains\MyDomainName\App_Data\MyDB03.mdf;Database=MyDB06;integrated security=False;User ID=sa;Password=MyPassword;multipleactiveresultsets=True;App=EntityFramework&quot;"
      providerName="System.Data.EntityClient" />
</connectionStrings>

edited Jul 10, 2011 at 9:21

cHao

87.1k21 gold badges147 silver badges178 bronze badges

answered Jul 10, 2011 at 8:22

Ben

1

Collectives™ on Stack Overflow

Connecting ASP.NET MVC2 App to SQL Server

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related