Skip Headers
Oracle® Data Provider for .NET Developer's Guide
11g Release 2 (11.2.0.3)

Part Number E23174-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

OracleClientFactory Class

An OracleClientFactory object allows applications to instantiate ODP.NET classes in a generic way.

Supported Only in ADO.NET 2.0-Compliant ODP.NET

Class Inheritance

System.Object

  System.Data.Common.DbProviderFactory

    Oracle.DataAccess.Client.OracleClientFactory

Declaration

// C#
public sealed class OracleClientFactory : DbProviderFactory

Thread Safety

All public static methods are thread-safe, although instance methods do not guarantee thread safety.

Example

// C#
 
using System;
using System.Data;
using System.Data.Common;
using Oracle.DataAccess.Client;
 
class FactorySample
{
  static void Main()
  {
    string constr = "user id=scott;password=tiger;data source=oracle";
 
    DbProviderFactory factory =
            DbProviderFactories.GetFactory("Oracle.DataAccess.Client");
 
    DbConnection conn = factory.CreateConnection();
 
    try
    {
      conn.ConnectionString = constr;
      conn.Open();
 
      DbCommand cmd = factory.CreateCommand();
      cmd.Connection = conn;
      cmd.CommandText = "select * from emp";
 
      DbDataReader reader = cmd.ExecuteReader();
      while (reader.Read())
        Console.WriteLine(reader["EMPNO"] + " : " + reader["ENAME"]);
    }
    catch (Exception ex)
    {
      Console.WriteLine(ex.Message);
      Console.WriteLine(ex.StackTrace);
    }
  }
}

Requirements

Namespace: Oracle.DataAccess.Client

Assembly: Oracle.DataAccess.dll

ODP.NET Version: ODP.NET for .NET Framework 2.0 or ODP.NET for .NET Framework 4


OracleClientFactory Members

OracleClientFactory members are listed in the following tables.

OracleClientFactory Public Properties

The OracleClientFactory public properties are listed in Table 7-1.

Table 7-1 OracleClientFactory Public Properties

Property Description

CanCreateDataSourceEnumerator

Indicates whether or not the CreateDataSourceEnumerator method is supported


OracleClientFactory Public Methods

OracleClientFactory Public Methods are listed in Table 7-2.

Table 7-2 OracleClientFactory Public Method

Method Description

CreateCommand

Returns a DbCommand object that represents an OracleCommand object

CreateCommandBuilder

Returns a DbCommandBuilder object that represents an OracleCommandBuilder object

CreateConnection

Returns a DbConnection object that represents an OracleConnection object

CreateConnectionStringBuilder

Returns a DbConnectionStringBuilder object that represents an OracleConnectionStringBuilder object

CreateDataAdapter

Returns a DbDataAdapter object that represents an OracleDataAdapter object

CreateDataSourceEnumerator

Returns a DbDataSourceEnumerator object that represents an OracleDataSourceEnumerator object

CreateParameter

Returns a DbParameter object that represents an OracleParameter object

CreatePermission

Returns a CodeAccessPermission object that represents an OraclePermission object



OracleClientFactory Public Properties

The OracleClientFactory public properties are listed in Table 7-3.

Table 7-3 OracleClientFactory Public Properties

Property Description

CanCreateDataSourceEnumerator

Indicates whether or not the CreateDataSourceEnumerator method is supported


CanCreateDataSourceEnumerator

This property indicates whether or not the CreateDataSourceEnumerator method is supported.

Declaration

// C#
public override bool CanCreateDataSourceEnumerator { get; }
 

Property Value

Returns true.

Remarks

ODP.NET supports the OracleDataSourceEnumerator object.


OracleClientFactory Public Methods

The OracleClientFactory public method is listed in Table 7-4.

Table 7-4 OracleClientFactory Public Method

Method Description

CreateCommand

Returns a DbCommand object that represents an OracleCommand object

CreateCommandBuilder

Returns a DbCommandBuilder object that represents an OracleCommandBuilder object

CreateConnection

Returns a DbConnection object that represents an OracleConnection object

CreateConnectionStringBuilder

Returns a DbConnectionStringBuilder object that represents an OracleConnectionStringBuilder object

CreateDataAdapter

Returns a DbDataAdapter object that represents an OracleDataAdapter object

CreateDataSourceEnumerator

Returns a DbDataSourceEnumerator object that represents an OracleDataSourceEnumerator object

CreateParameter

Returns a DbParameter object that represents an OracleParameter object

CreatePermission

Returns a CodeAccessPermission object that represents an OraclePermission object


CreateCommand

This method returns a DbCommand object that represents an OracleCommand object.

Declaration

// C#
public override DbCommand CreateCommand();

Return Value

A DbCommand object that represents an OracleCommand object.

CreateCommandBuilder

This method returns a DbCommandBuilder object that represents an OracleCommandBuilder object.

Declaration

// C#
public override DbCommandBuilder CreateCommandBuilder();
 

Return Value

A DbCommandBuilder object that represents an OracleCommandBuilder object.

CreateConnection

This method returns a DbConnection object that represents an OracleConnection object.

Declaration

// C#
public override DbConnection CreateConnection();
 

Return Value

A DbConnection object that represents an OracleConnection object.

CreateConnectionStringBuilder

This method returns a DbConnectionStringBuilder object that represents an OracleConnectionStringBuilder object.

Declaration

// C#
public override DbConnectionStringBuilder CreateConnectionStringBuilder();
 

Return Value

A DbConnectionStringBuilder object that represents an OracleConnectionStringBuilder object.

CreateDataAdapter

This method returns a DbDataAdapter object that represents an OracleDataAdapter object.

Declaration

// C#
public override DbDataAdapter CreateDataAdapter();
 

Return Value

A DbDataAdapter object that represents an OracleDataAdapter object.

CreateDataSourceEnumerator

This method returns a DbDataSourceEnumerator object that represents an OracleDataSourceEnumerator object.

Declaration

// C#
public override DbDataSourceEnumerator CreateDataSourceEnumerator();
 

Return Value

A DbDataSourceEnumerator object that represents an OracleDataSourceEnumerator object.

CreateParameter

This method returns a DbParameter object that represents an OracleParameter object.

Declaration

// C#
public override DbParameter CreateParameter();
 

Return Value

A DbParameter object that represents an OracleParameter object.

CreatePermission

This method returns a CodeAccessPermission object that represents an OraclePermission object.

Declaration

// C#
public override System.Security.CodeAccessPermission CreatePermission(
  System.Security.Permissions.PermissionState state);

Parameter

Return Value

A CodeAccessPermission object that represents an OraclePermission object.

Remarks

This method enables users, writing provider-independent code, to get a CodeAccessPermission instance that represents an OraclePermission object.