<?xml version="1.0"?>
<configuration>
<connectionStrings>
<!--OLE DB Services=-1表示打开连接池-->
<add name="Access" connectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source=~\App_Data\Test.mdb;Persist Security Info=False;OLE DB Services=-1"/>
<add name="MSSQL" connectionString="Server=.;Integrated Security=SSPI;Database=Test" providerName="System.Data.SqlClient"/>
<!--DataPath指定数据库文件目录,反向工程创建数据库时用-->
<add name="MSSQL" connectionString="Server=.;User ID=sa;Password=sa;Database=Test;datapath=~\App_Data" providerName="System.Data.SqlClient"/>
<add name="SqlCe" connectionString="Data Source=test.sdf;" providerName="SqlCe"/>
<add name="SQLite" connectionString="Data Source=test.db;Version=3;" providerName="Sqlite"/>
<add name="MySql" connectionString="Server=.;Port=3306;Database=mysql;Uid=root;Pwd=;" providerName="MySql.Data.MySqlClient"/>
<add name="Oracle" connectionString="Data Source=orc;User ID=sys;Password=admin;" providerName="System.Data.OracleClient"/>
<!--角色名作为点前缀来约束表名,支持所有数据库-->
<add name="Oracle" connectionString="Data Source=(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.34)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ORC)));User ID=sys;Password=admin;Owner=mis" providerName="System.Data.OracleClient"/>
<add name="Oracle" connectionString="Data Source=orc;Integrated Security=yes;" providerName="System.Data.OracleClient"/>
<add name="Oracle_OLEDB" connectionString="Provider=OraOLEDB.Oracle;Data Source=orc;User Id=sys;Password=admin;"/>
<add name="Firebird" connectionString="Server=.;Database=test.fdb;User=SYSDBA;Password=masterkey;" providerName="FirebirdSql.Data.FirebirdClient"/>
<!--ServerType可取值"0"或者"1","0"表明连接对象为普通服务器,"1"才是嵌入式服务器-->
<add name="Firebird_Embed" connectionString="Database=test;User=SYSDBA;Password=masterkey;ServerType=1" providerName="FirebirdSql.Data.FirebirdClient"/>
<add name="PostgreSQL" connectionString="Server=.;Database=master;Uid=root;Pwd=root;" providerName="PostgreSQL.Data.PostgreSQLClient"/>
<add name="Network" connectionString="Server=tcp://data.NewLifeX.com:8089;User ID=test;Password=test" providerName="Network"/>
<add name="Distributed" connectionString="WriteServer='ConnA*1,ConnB';ReadServer='ConnC*8, ConnD';" providerName="Distributed"/>
</connectionStrings>
<system.web>
<httpModules>
<!--页面执行时间模块,用于在页面中输出页面执行时间和查询执行次数-->
<add name="DbRunTimeModule" type="XCode.Web.DbRunTimeModule,XCode"/>
</httpModules>
</system.web>
</configuration>
|