How to setup connection string in C# ASP.NET for SQL Server 2012

Question

<connectionString>
  <add name="SchoolContext"
       connectionString="Data Source=(local); database=Sample; integrated security=true;"
       providerName="System.Data.SqlClient"      
   />

Above is my connection string. But when I run application it gives an error named:

The configuration section 'connectionString' cannot be read because it is missing a section declaration

How can I fix it?

Giorgi Nakeuri · Accepted Answer · 2015-04-15 13:27:16Z

6

There should be <connectionStrings>...</connectionStrings> not <connectionString>...

See www.connectionstrings.com for details about various configurations.

edited Apr 15, 2015 at 13:27

answered Apr 15, 2015 at 13:21

Giorgi Nakeuri

35.9k8 gold badges50 silver badges78 bronze badges

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

1 Comment

user4444350 Over a year ago

oh!! I didn't noticed at all. Thanks a lot @Giorgi Nakeuri

senthilkumar2185 · Accepted Answer · 2015-04-15 13:51:30Z

1

http://www.connectionstrings.com/sql-server-2012/

Try this connectionstring style

Server=(localdb)\v11.0;Integrated 
Security=true;AttachDbFileName=C:\MyFolder\MyData.mdf;Trusted_Connection=Yes;

edited Apr 15, 2015 at 13:51

senthilkumar2185

2,5983 gold badges23 silver badges38 bronze badges

answered Apr 15, 2015 at 13:20

er_jack

1169 bronze badges

Collectives™ on Stack Overflow

How to setup connection string in C# ASP.NET for SQL Server 2012

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related