difference between two connection strings?

Question

what is the difference between the below connection strins?

1. cn.ConnectionString = ConfigurationManager.AppSettings["CnnStr"].ToString();

2. cn.ConnectionString = ConfigurationManager.Connectionstring["CnnStr"].ToString();

Pankaj Pandey · Answer

hii in your config file there are two keywords, AppSettin and ConnectionString. MS define the Connectionstring for connect with ado.net with specified parameter but many times we use appsetting. Appsetting also do same task, it store value but it is not a good practice, always use connectionstring for connectivity, and appstring for storing the other data.

Sanjeeb Lenka · Answer

The main difference is in appsettings section we can store any data string values including database connection strings also but in connectionStrings section only database connection strings can store those are our application connection strings and new features (Membership, Personalization and Role Manager) connection strings only. for more detail check this link http://www.aspdotnet-suresh.com/2012/10/aspnet-difference-between-appsettings.html

Iftikar Hussain · Answer

Hi, 1. ConfigurationManager.AppSettings["CnnStr"].ToString() will read app setting value i.e. from 2. ConfigurationManager.Connectionstring["CnnStr"].ToString() will read value from connectionStrings block of web.config The connectionStrings element specifies a collection of database connection strings, as name/value pairs, for ASP.NET applications and features. In previous versions of ASP.NET, connection strings were stored in the appSettings. In ASP.NET 2.0, features, such as Session, Membership, Personalization, and Role Manager, rely on connection strings that are stored in the connectionStrings element. You can also use the connectionStrings element to store connection strings for your own applications. Regards, Iftikar

Abhineet Srivastava · Answer

In Connection string section,we can only store database connection. Otherhand,AppSetting is used to store different data like website name,admin email etc in Web.config

Ravi Shekhar · Answer

Hi, ConfigurationManager.AppSettings["CnnStr"].ToString() called your connectionstring from Appsetting file. ConfigurationManager.Connectionstring["CnnStr"].ToString() called your connectionstring from web config file.