ZLPMS/Assemblys/Config/database.config

<?xml version="1.0" encoding="utf-8" ?>
<configuration>
  <connectionStrings>
    <!--数据库连接字符串,数据底层访问实现DLL名称-->
    <add name="conn" connectionString="F56C7231FEEAA32E229F6E7248AD68C0827C92AA6EB9C6996599C7E90CDAA95F4857900EC8D9508EE362EE4406B7FCC86FEB6348F45D71068CA5EA17ABD0E2D863AAFA2D04333D7339E67DC7418EAF71A4D9DDE1CD7FD357922CFB5002662AB5DFD9435A9D80BF5552283FB776544323C0DD8B09BCF3CA37DEE58F71BDD2679D32BDFF19B0EB5E794F2FCCB58510812D513A7A14088BB733EAF83FE006D68F7342022E041C6FEE6065036AF8BCA9922185F9CD67FBAA285064917CFC34DAA01D" providerName="NoClientOracleDALAssembly"/>
    <!--连接字符串Data Source=192.168.8.251/rhip;Persist Security Info=True;
      Connection Timeout=120;
      Connection Lifetime=10;
      Max Pool Size=200;
      Min Pool Size=100;
      Incr Pool Size=50;
      User ID=zlbase;Password=zlbase2017-->
  <!--
    其中Connection Timeout是控制连接超时时间
     Connection Lifetime是控制空闲连接超时时间
  -->
    
    
    <!--SQL数据库连接字符串-->
    <add name="sqlcon" connectionString="4ECE4F042ABBC90467BFC8122EC3FC28B4DEB669B3000D71E5486D1D7D3C79E31A31CBA87078C731" providerName="SQLServerDALAssembly"/>

    <!--SQLite数据库连接字符串-->
    <add name="mysqlite" connectionString="F56C7231FEEAA32E7DF0097B77BB38775982EDE2C2D5296D701DE8A3D2468AC8004BB54AF24320CF7830F295DF353C18F96DC2CEBC71DBF6536DE4BB97916E29" providerName="SQLiteAssembly"/>

    <!--使用WebService调用服务-->
    <!--目前配置是http://localhost:7071/-->
    <add name="webservice" connectionString="D74FB94809081FCCF43632ACDE90E85452FA014EFD5D489B" providerName="WebServiceAssembly"/>
  </connectionStrings>
  <appSettings>
    <!--Oracle数据库实现层的dll及实现数据库供应者-->
    <add key="OracleDALAssembly" value="ZLSoft.QWPlatform.OraDataAccess.dll,QWPlatform.OraDataAccess.Provider.OracleProvider"/>

    <!--免安装Oracle客户端，使用非托管方式实现-->
    <add key="NoClientOracleDALAssembly" value="ZLSoft.QWPlatform.OraNoClientDataAccess.dll,QWPlatform.OraNoClientDataAccess.Provider.OracleProvider"/>

    <!--SQLSERVER数据库实现层, dll,namespace-->
    <add key="SQLServerDALAssembly" value="ZLSoft.QWPlatform.SQLServerDataAccess.dll,QWPlatform.SQLServerDataAccess.Provider.SqlServerProvider"/>

    <!--使用WebService代理实现调阅-->
    <add key="WebServiceAssembly" value="ZLSoft.QWPlatform.WebServiceDataProxy.dll,QWPlatform.WebServiceDataProxy.Provider.ServiceProxyProvider"/>

    <!--SQLite数据库连接-->
    <add key="SQLiteAssembly" value="ZLSoft.QWPlatform.SqliteDataAccess.dll,QWPlatform.SqliteDataAccess.Provider.SQLiteProvider"/>

    <!--设置数据库连接字符串是否加密,true表示加密, false明文连接-->
    <add key="EncryptDatabaseString" value="true"/>
    
    <!--SQL监听是否启用,true表示启用脚本监听,false表示不监听执行脚本-->
    <add key="SQLListen" value="false"/>

    <!--基础服务配置，包括了SQL监听功能-->
    <add key="ZLBaseServer" value="192.168.31.47:1100"/>

  </appSettings>
  
  <!--指定oralce的版本，在web.config文件目录下进行配置runtime节点
  当一个服务器安装多个oracle客户端版本访问异常时使用
  异常如下：未能加载文件或程序集“Oracle.DataAccess, Version=2.112.1.2, Culture=neutral, PublicKeyToken=89b483f429c47342”或它的某一个依赖项。
  或者是：Could not load file or assembly 'Oracle.DataAccess, Version=2.112.1.2, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. An attempt was made to load a program with an incorrect format
  -->
  <runtime>
    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
      <dependentAssembly>
        <assemblyIdentity name="Oracle.DataAccess" publicKeyToken="89b483f429c47342" culture="neutral" />
        <bindingRedirect oldVersion="2.112.1.0" newVersion="4.112.1.0"/>
      </dependentAssembly>
    </assemblyBinding>
  </runtime>
</configuration>