SubSonic 配置 (连接SQLServer和Oracle数据库)

1、进行SubSonic节点定义

<configSections>
      <section name="SubSonicService" type="SubSonic.SubSonicSection, SubSonic" requirePermission="false"/>
    </configSections> 

2、配置连接字符串

<connectionStrings>
    <clear/>

    <!-- Oracle 连接串 -->
    <!-- <add name="ora" connectionString="Data Source=test;uid=test;pwd=test"/> -->

    <!-- SQLServer 连接串 -->
    <add name="sql" connectionString="Data Source=localhost;Initial Catalog=test;uid=sa;pwd=sa"/>
  </connectionStrings>

3、配置SubSonic节点

<SubSonicService defaultProvider="BK">
    <providers>
      <clear/>
      <!-- <add name="Ora" type="SubSonic.OracleDataProvider,SubSonic" connectionStringName="ora" generatedNamespace="Ora.DAL"/>-->
      <add name="Sql" type="SubSonic.SqlDataProvider,SubSonic" connectionStringName="sql" generatedNamespace="Sql.DAL"/>
    </providers>
  </SubSonicService>