webconfig中配置各种数据库的连接字符串

一、在appSettings配置

<appSettings>

<!--SQL Server-->

<!--<add key="SQLString" value="Database=MyData;Data Source=NICKYAN-PC;User Id=sa;Password=123123;"/>

<add key="DataDAL" value="RedGlovePermission.SQLServerDAL" />-->

<!--My SQL-->

<add key="SqlString" value="host=192.168.0.222;userid=root;password=123456;database=hr_db"/>    

<add key="DataDAL" value="RedGlovePermission.MySqlDAL" />

<!--Oracle-->

<!--<add key="SqlString" value="Data Source=NICKYAN-PC;User Id=PB_DB_USER;Password=123123;Integrated Security=no"/>    

<add key="DataDAL" value="RedGlovePermission.OracleDAL" />-->

<!--OleDB-->

<!--<add key="SQLString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=RedGlovePermission.Web\DB\MyData.mdb;Persist Security Info=False"/>

<add key="DataDAL" value="RedGlovePermission.OleDBDAL" />-->

<!--在找不到语言版本时则设定为该版本-->

<add key="InitLanguages" value="zh-cn" />

<!--初始化样式-->

<add key="InitStyle" value="default" />

<!--认证状态(From/SSO)-->

<add key="IsLogin" value="SSO" />

</appSettings>

二、在connectionStrings配置    

<!--SQL Server-->

 

    <add name="ApplicationServices" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|\aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
    <add name="ConnStr" connectionString="Database=DIS;Server=192.168.1.148;User ID=sa;Password=sa;" providerName="System.Data.SqlClient"/>

 

<!--My SQL-->

 

<connectionStrings>

<add name="conStr" connectionString="server=localhost;uid=root;pwd=123;database=test" providerName="System.Data.SqlClient"/>

 

<!--Oracle-->

<connectionStrings>
     <add name="TYRCC_connstr" connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=china-007cb92da)

           (PORT=1521))(CONNECT_DATA=(SERVICE_NAME=TYNHRK)));User ID=tytc;Password=123456;Unicode=True"
           providerName="System.Data.OracleClient" />
     <add name="ConnectionString" connectionString="Data Source=TYNHRK;User ID=tytc;Password=123456.;Unicode=True"
             providerName="System.Data.OracleClient" />
     <add name="ConnectionString2" connectionString="Expression: test_dataConnectionString"
      providerName="System.Data.SqlClient" />
     </connectionStrings>