ASP.NET connection string metadata syntax

Question

I'm new to ASP.NET-ville, be gentle.

I have been troubleshooting a ASP.NET setup, where the server/database values are changing, therefore web.config needs to be updated.

There are multiple <add name="NameXYZ" connectionString="blah" /> instances (multiple ASP.NET components), but some of these are marked up differently to others.

I've got the following provided:

<add name="CONNECTION-B" connectionString="metadata=res://*/ZZZZ.ssdl;provider=System.Data.SqlClient;provider connection string=&quot;Data Source=XXX;Initial Catalog=YYY;Persist Security Info=True;User ID=AAA;Password=BBBB;MultipleActiveResultSets=True&quot;" providerName="System.Data.EntityClient" />


<add name="CONNECTION-A" connectionString="server=XXX;database=YYY;user id=XXX;password=BBB" />

I've used substituted values in the above, making the assumption that for both format types:

XXX is the server (MSSQL host)
YYY is the database name
AAA is the database user, and
BBB is the user password.

(ZZZZ is a pipe-delimited list of something)

Questions are as follows:

A) Is my assumption of synonymous connection string terms accurate? (Data Source <=> server, database <=> initial catalog)

B) Are there any syntax errors in the markup? Some MSDN documents I've looked up use double, single, and " marks interchangeably.

philhobgen · Accepted Answer · 2011-05-27 07:09:21Z

14

There are two different types of connection strings here. The best bet (IMO) is to have a read up in the docs -

The first is an ADO.Net connection string: http://msdn.microsoft.com/en-us/library/ms254500.aspx

The second is an Entity Framework connection string: http://msdn.microsoft.com/en-us/library/cc716756.aspx

It's all explained in those two links, certainly clearer than I can explain it!

answered May 27, 2011 at 7:09

philhobgen

2,29417 silver badges28 bronze badges

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

Comments

Ira Rainey · Accepted Answer · 2011-05-27 08:59:04Z

3

A great source of connection string information can be found here:

http://www.connectionstrings.com/

answered May 27, 2011 at 8:59

Ira Rainey

5,2152 gold badges36 silver badges42 bronze badges

Comments

Dbl · Accepted Answer · 2014-03-27 21:17:14Z

1

I felt the need to post this since i also had some problems with this and later on discovered that there's a difference in connection string requirements for codefirst/model/database approaches:

MS Blog post about configuration settings for entitiy framework connection strings

answered Mar 27, 2014 at 21:17

Dbl

5,9944 gold badges52 silver badges74 bronze badges

Collectives™ on Stack Overflow

ASP.NET connection string metadata syntax

3 Answers 3

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related