在远程项目中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>