Ndo 配置

         Ndo 的配置方式非常灵活,可以有如下的几种方式
   
         1: 默认的配置方式-单数据库(支持解析SqlClientDriver,OledbDriver,OracleClientDriver,JetDriver,OdbcDriver,SqlOledbDriver,OracleOledbDriver,如果是其它数据源可以通过后面的其它方式)Ndo自动在appSettings 的配置节中找key= "ConnectionString"的配置项,然后进行加载,如果找不到就会抛异常.

                配置Access数据库(默认)

<appSettings>
        <add key="ConnectionString" value="Data Source=localhost; Database=Northwind; Integrated Security=true;"/>
        <add key="JetConnectionString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Northwind.mdb;"/>
        <add key="OracleConn" value="Provider=MSDAORA.1;Data Source=***;User ID=***;Password=***;"/>
        <add key= "SqlOledb" value="Provider=SQLOLEDB;Data Source=localhost;Initial Catalog=Northwind;User ID=sa;Password=;"/>
        <add key="Oracle" value="Data Source=***;User ID=***;Password=***;"/>
</appSettings>

                用NdoManager 连接数据库

INdoManager nm = NdoManager.Instance;
INdoManager nm2 = NdoManager.GetInstance(ConfigurationSettings.AppSettings["SqlOledb"]);

       2: 显式的配置数据驱动器(针对SqlClientDriver,OledbDriver,OracleClientDriver,OdbcDriver,SqlOledbDriver,OracleOledbDriver这几种驱动可以不需要配置数据库方言,NDO内部自动会加载与之相关的数据库方言)
         配置项有:
                           name: 提供者名称(必须)
                           type : 数据驱动器类型(必须)
                           dialect : 数据库方言类型(可选)
                           dataSource:指的是appSettings配置节中配置项的建名
                           connectionString: 数据库连接字符串,如果同时配置了dataSource和connectionString,系统会选择后者
                           commandTimeout:命令超时(可选),默认30秒
                           isEnableParamCache: 是否使用参数缓冲(可选),默认true
                           autoClose: 是否自动关闭连接(可选) ),默认true
     
       

<configSections>
        <section name="ndo" type="Ndo.Configuration.ProviderConfigurationHandler, Ndo"/>
</configSections>

            配置SqlServer数据库(直连)

<ndo defaultProvider="sqlClient">
        <providers>
            <clear/>
            <add 
                    name="sqlClient" 
                    type="Ndo.Driver.SqlClientDriver,Ndo"
                    connectionString = "Data Source=localhost; Database=Pubs; Integrated Security=true;"/>
        </providers>
    </ndo>

                用NdoManager 连接数据库

INdoManager nm = NdoManager.Instance;

      配置SqlServer数据库(通过Oledb连接)

<ndo defaultProvider="sqlOledb">
        <providers>
            <clear/>
            <add 
                    name="sqlOledb" 
                    type="Ndo.Driver.SqlOledbDriver,Ndo"
                    dialect ="Ndo.MsSql2000Dialect,Ndo"
                    dataSource = "SqlOledb"
                    />
        </providers>
</ndo>

      配置Access数据库

    <ndo defaultProvider="Jet">
        <providers>
            <clear/>
            <add 
                    name="Jet" 
                    type="Ndo.Driver.JetDriver,Ndo"
                    dialect ="Ndo.MsAccessDialect,Ndo"
                    dataSource = "JetConnectionString"
                    />
        </providers>
    </ndo>

      配置Oracle 数据库（直连）

<ndo defaultProvider="oracleClient">
        <providers>
            <clear/>
            <add 
                    name="oracleClient" 
                    type="Ndo.Driver.OracleClientDriver,Ndo"
                    dataSource = "Oracle"
                    />
        </providers>
</ndo>

     配置Oracle 数据库（通过Oledb,不建议，速度慢）

<ndo defaultProvider="oracleOledb">
        <providers>
            <clear/>
            <add 
                    name="oracleOledb" 
                    type="Ndo.Driver.OracleOledbDriver,Ndo"
                    dialect ="Ndo.OracleDialect,Ndo"
                    dataSource = "OracleConn"/>
        </providers>
</ndo>

        前面的配置都是单数据库，那么多数据库的配置请看下面：

<ndo defaultProvider="sqlClient">
        <providers>
            <clear/>
            <add 
                    name="sqlClient" 
                    type="Ndo.Driver.SqlClientDriver,Ndo"
                    dataSource = "ConnectionString"/>
            <add 
                    name="oracleClient" 
                    type="Ndo.Driver.OracleClientDriver,Ndo"
                    dataSource = "Oracle"/>
        </providers>
</ndo>

       

                用NDOManager 连接数据库

INdoManager sqlClient = NdoManager.Instance;
   INdoManager oracle = NdoManager.Config("oracleClient");

      最后如果没有配置,可以用INdoManager nm = NdoManager.GetInstance("server=localhost;database=northwind;user=sa;password=**;")的方式进行连接.

      上一篇  下一偏