记得很久前写DAL的时候,将这两种方式搞混淆,以至于的到的连接对象始终是null,搞得十分狼狈。记录下来,仅当教训!
方式一:
配置:
<configuration>
<connectionStrings>
<add name="linq1" connectionString="Data Source=servername;initial catalog=DBName;persist security info=true;user id=sa;password=sa;"/>
</connectionStrings>
</configuration>
获取:
protected static string faceconn = ConfigurationManager.ConnectionStrings["linq1"].ConnectionString;
需要引用System.Configuration
<appSettings>
<add key="linq2" value="data source=ServerName;Initial Catalog=DBName;user id=sa;password=sa;Connect Timeout=800000;"/>
</appSettings>
获取:
protected static string baseconnstring = ConfigurationManager.AppSettings["linq2"].ToString();