An OracleClientFactory object allows applications to instantiate ODP.NET classes in a generic way.
System.Object
System.Data.Common.DbProviderFactory
Oracle.DataAccess.Client.OracleClientFactory
// C# public sealed class OracleClientFactory : DbProviderFactory
| Provider | ODP.NET, Unmanaged Driver | ODP.NET, Managed Driver |
| Assembly | Oracle.DataAccess.dll |
Oracle.ManagedDataAccess.dll |
| Namespace | Oracle.DataAccess.Client |
Oracle.ManagedDataAccess.Client |
| .NET Framework | 3.5, 4.0, 4.5, 4.6 | 4.0, 4.5, 4.6 |
All public static methods are thread-safe, although instance methods do not guarantee thread safety.
// 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);
}
}
}
See Also:
OracleClientFactory members are listed in the following tables.
The OracleClientFactory field is listed in Table 6-1
Table 6-1 OracleClientFactory Field
| Property | Description |
|---|---|
|
Gets an instance of the |
OracleClientFactory Constructor
The OracleClientFactory constructor is listed in Table 6-2
Table 6-2 OracleClientFactory Constructor
| Property | Description |
|---|---|
|
Instantiates a new instance of |
OracleClientFactory Public Properties
The OracleClientFactory public properties are listed in Table 6-3.
Table 6-3 OracleClientFactory Public Properties
| Property | Description |
|---|---|
|
Indicates whether or not the |
OracleClientFactory Public Methods
OracleClientFactory Public Methods are listed in Table 6-4.
Table 6-4 OracleClientFactory Public Method
| Method | Description |
|---|---|
|
Returns a |
|
|
Returns a |
|
|
Returns a |
|
|
Returns a |
|
|
Returns a |
|
|
Returns a |
|
|
Returns a |
|
|
Returns a |
The OracleClientFactory field is listed in Table 6-5
Table 6-5 OracleClientFactory Field
| Property | Description |
|---|---|
|
Gets an instance of the |
See Also:
The OracleClientFactory constructor creates a new instances of the OracleClientFactory class.
// C# public OracleClientFactory();
The OracleClientFactory public properties are listed in Table 6-6.
Table 6-6 OracleClientFactory Public Properties
| Property | Description |
|---|---|
|
Indicates whether or not the |
See Also:
The OracleClientFactory public method is listed in Table 6-7.
Table 6-7 OracleClientFactory Public Method
| Method | Description |
|---|---|
|
Returns a |
|
|
Returns a |
|
|
Returns a |
|
|
Returns a |
|
|
Returns a |
|
|
Returns a |
|
|
Returns a |
|
|
Returns a |
See Also:
This method returns a DbCommand object that represents an OracleCommand object.
// C# public override DbCommand CreateCommand();
A DbCommand object that represents an OracleCommand object.
This method returns a DbCommandBuilder object that represents an OracleCommandBuilder object.
// C# public override DbCommandBuilder CreateCommandBuilder();
A DbCommandBuilder object that represents an OracleCommandBuilder object.
This method returns a DbConnection object that represents an OracleConnection object.
// C# public override DbConnection CreateConnection();
A DbConnection object that represents an OracleConnection object.
This method returns a DbConnectionStringBuilder object that represents an OracleConnectionStringBuilder object.
// C# public override DbConnectionStringBuilder CreateConnectionStringBuilder();
A DbConnectionStringBuilder object that represents an OracleConnectionStringBuilder object.
This method returns a DbDataAdapter object that represents an OracleDataAdapter object.
// C# public override DbDataAdapter CreateDataAdapter();
A DbDataAdapter object that represents an OracleDataAdapter object.
This method returns a DbDataSourceEnumerator object that represents an OracleDataSourceEnumerator object.
// C# public override DbDataSourceEnumerator CreateDataSourceEnumerator();
A DbDataSourceEnumerator object that represents an OracleDataSourceEnumerator object.
This method returns a DbParameter object that represents an OracleParameter object.
// C# public override DbParameter CreateParameter();
A DbParameter object that represents an OracleParameter object.
This method returns a CodeAccessPermission object that represents an OraclePermission object.
// C#
public override System.Security.CodeAccessPermission CreatePermission(
System.Security.Permissions.PermissionState state);
state
A PermissionState object.
A CodeAccessPermission object that represents an OraclePermission object.
This method enables users, writing provider-independent code, to get a CodeAccessPermission instance that represents an OraclePermission object.