C# Web.config 关于connectionStrings的配置

在远程项目中web.config配置如下:
<connectionStrings>
    <add name="LocalSqlServer" connectionString="Data Source=远程服务器名;Initial Catalog=指定数据库;User ID=sa;Password=123456" providerName="System.Data.SqlClient" />
</connectionStrings>

在其他项目中web.config配置如下:
<connectionStrings>
    <add name="LocalSqlServer" connectionString="data source=localhost;Integrated Security=SSPI;AttachDBFilename=aspnetdb;User Instance=false" providerName="System.Data.SqlClient" />
</connectionStrings>
或者
<connectionStrings>
    <add name="LocalSqlServer" connectionString="data source=localhost;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb;User Instance=false" providerName="System.Data.SqlClient" />
</connectionStrings>

在我的项目中web.config配置如下:
<connectionStrings>
    <remove name="LocalSqlServer"/>
      <add name="LocalSqlServer" connectionString="data source=localhost;Integrated Security=SSPI;AttachDBFilename=F:\WEBSITE1\APP_DATA\ASPNETDB.MDF;Integrated Security=True;User Instance=false" providerName="System.Data.SqlClient" />
   </connectionStrings>

Ado.net2.0中新增加了一个MagicValue,可以在应用程序的配置文件的数据库链接串种使用|DataDirectory| ,例如

<connectionStrings>
        <add name="ConnectionString" connectionString="data   source=.\SQLEXPRESS;Integrated   Security=SSPI;AttachDBFilename=|DataDirectory|data.mdf;User   Instance=true" providerName="System.Data.SqlClient" />
</connectionStrings>

 

<connectionStrings>
        <add name="ConnectionString" connectionString="data   source=.\SQLEXPRESS;Integrated   Security=SSPI;AttachDBFilename=|DataDirectory|App_Data\data.mdf;User   Instance=true" providerName="System.Data.SqlClient" />
</connectionStrings>

posted @ 2013-10-25 17:10  冻豺  阅读(2538)  评论(0编辑  收藏  举报