优化ETL过滤模块
大石头 编写于 2017-08-29 17:11:46
X
<?xml version="1.0" encoding="utf-8"?>
<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>
<startup><supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.0" /></startup>
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="System.Net.Http" publicKeyToken="b03f5f7f11d50a3a" culture="neutral" />
        <bindingRedirect oldVersion="0.0.0.0-2.2.29.0" newVersion="2.2.29.0" />
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
</configuration>