在开发框架中扩展微软企业库，支持使用ODP.NET（Oracle.ManagedDataAccess.dll）访问Oracle数据库

usingSystem;usingSystem.Data;usingSystem.Data.Common;usingMicrosoft.Practices.EnterpriseLibrary.Common;usingMicrosoft.Practices.EnterpriseLibrary.Data;usingMicrosoft.Practices.EnterpriseLibrary.Data.Configuration;usingOracle.ManagedDataAccess.Client;namespaceEntLibContrib.Data.OracleManaged

{/// <summary>
    /// <para>Oracle数据库对象(使用ODP驱动)</para>
    /// </summary>
    /// <remarks>
    /// <para>
    ///Internally uses OracleProvider from Oracle to connect to the database./// </para>
    /// </remarks>
    [DatabaseAssembler(typeof(OracleDatabaseAssembler))]public classOracleDatabase : Database

    {/// <summary>
        ///Initializes a new instance of the<see cref="OracleDatabase"/>class///with a connection string./// </summary>
        /// <param name="connectionString">The connection string.</param>
        public OracleDatabase(string connectionString) : base(connectionString, OracleClientFactory.Instance)

        {

        }/// <summary>
        /// <para>
        ///Gets the parameter token used to delimit parameters for the///Oracle database.</para>
        /// </summary>
        /// <value>
        /// <para>The '?' symbol.</para>
        /// </value>
        protected charParameterToken

        {get{return ':';

            }

        }



        .........

<?xml version="1.0"?>
<configuration>
  <configSections>
    <sectionname="dataConfiguration"type="Microsoft.Practices.EnterpriseLibrary.Data.Configuration.DatabaseSettings, Microsoft.Practices.EnterpriseLibrary.Data"/>
    <sectionname="oracleConnectionSettings"type="EntLibContrib.Data.OdpNet.Configuration.OracleConnectionSettings, EntLibContrib.Data.OdpNet" />
  </configSections>
  <connectionStrings>
    <!--SQLServer数据库的连接字符串-->
    <addname="sqlserver"providerName="System.Data.SqlClient"connectionString="Persist Security Info=False;Data Source=(local);Initial Catalog=WinFramework;Integrated Security=SSPI"/>
    
    <!--Oracle数据库的连接字符串-->
    <addname="oracle"providerName="System.Data.OracleClient"connectionString="Data Source=orcl;User ID=whc;Password=whc"/>
    
    <!--MySQL数据库的连接字符串-->
    <addname="mysql"providerName="MySql.Data.MySqlClient"connectionString="Server=localhost;Database=WinFramework;Uid=root;Pwd=123456;"/>
    
    <!--PostgreSQL数据库的连接字符串-->
    <addname="npgsql"providerName="Npgsql"connectionString="Server=localhost;Port=5432;Database=postgres;User Id=postgres;Password=123456"/>
    
    <!--路径符号|DataDirectory|代表当前运行目录-->    
    <!--SQLite数据库的连接字符串-->
    <addname="sqlite"providerName="System.Data.SQLite"connectionString="Data Source=|DataDirectory|\WinFramework.db;Version=3;" />
    <!--Microsoft Access数据库的连接字符串-->
    <addname="access"providerName="System.Data.OleDb"connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\WinFramework.mdb;User ID=Admin;Jet OLEDB:Database Password=;" />   
    
    <!--IBM DB2数据库的连接字符串-->
    <addname="db2"providerName="IBM.Data.DB2"connectionString="database=whc;uid=whc;pwd=123456"/>
    
    <!--采用OdpNet方式的Oracle数据库的连接字符串-->
    <addname="oracle2"providerName="Oracle.DataAccess.Client"connectionString="Data Source=orcl;User id=win;Password=win;" />
    <addname="oracle3"providerName="OracleManaged"connectionString="Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.mshome.net)));User ID=win;Password=win" />
  </connectionStrings>
  <dataConfigurationdefaultDatabase="oracle3">
    <providerMappings>
      <adddatabaseType="EntLibContrib.Data.MySql.MySqlDatabase, EntLibContrib.Data.MySql"name="MySql.Data.MySqlClient" />
      <adddatabaseType="EntLibContrib.Data.SQLite.SQLiteDatabase, EntLibContrib.Data.SqLite"name="System.Data.SQLite" />
      <adddatabaseType="EntLibContrib.Data.PostgreSql.NpgsqlDatabase, EntLibContrib.Data.PostgreSql"name="Npgsql" />      
      <adddatabaseType="EntLibContrib.Data.DB2.DB2Database, EntLibContrib.Data.DB2"name="IBM.Data.DB2" />
      <adddatabaseType="EntLibContrib.Data.OdpNet.OracleDatabase, EntLibContrib.Data.OdpNet"name="Oracle.DataAccess.Client" />
      <adddatabaseType="EntLibContrib.Data.Dm.DmDatabase, EntLibContrib.Data.Dm"name="Dm" />
      <!--增加ODP.NET（Oracle.ManagedDataAccess.dll）方式的扩展支持-->
      <adddatabaseType="EntLibContrib.Data.OracleManaged.OracleDatabase, EntLibContrib.Data.OracleManaged"name="OracleManaged" />
    </providerMappings>
  </dataConfiguration>
  
  <appSettings>

  </appSettings>
  <startupuseLegacyV2RuntimeActivationPolicy="true">
    <supportedRuntimeversion="v4.0"sku=".NETFramework,Version=v4.0"/>
    <supportedRuntimeversion="v2.0.50727"/>
  </startup>
</configuration>

private void btnGetData_Click(objectsender, EventArgs e)

{string sql = "select * from T_Customer";//+ " Where Name = :name";
    Database db =DatabaseFactory.CreateDatabase();

    DbCommand command=db.GetSqlStringCommand(sql);//command.Parameters.Add(new OracleParameter("name", "张三"));

    using (var ds =db.ExecuteDataSet(command))

    {this.dataGridView1.DataSource = ds.Tables[0];   

    }

}