Thursday, June 12, 2014

Always Add Two connection strings in ASP.NET Web.config

1) <add name="read" connectionString="Data Source=Test\SQLEXPRESS;Initial Catalog=DatabaseName;Integrated Security=false;uid=userid; password=password#123; Persist Security Info=True;" providerName="System.Data.SqlClient"/>

Use This Connection string for Read data from database

2) <add name="readandwrite" connectionString="Data Source=Test1\SQLEXPRESS;Initial Catalog=DatabaseName;Integrated Security=false;uid=userid1; password=password#1234; Persist Security Info=True;" providerName="System.Data.SqlClient"/>

Use This for Read and write data from and to database

3) With use of this performance will get better.

4)  TO get better Security

No comments:

Post a Comment