OracleConnectionDataProvider Class

In This Topic

This data provider can be used to consume data from an Oracle database and uses the ADO.NET providers Oracle.ManagedDataAccess.Client (not included - see section Requirements).

Object Model

Syntax

Visual Basic
C#
C++/CLI

'Declaration
 
Public NotInheritable Class OracleConnectionDataProvider 
   Inherits DbConnectionDataProvider
   Implements ICanHandleUsedIdentifiers, IDataProvider, combit.Reporting.ISupportsLogger

public sealed class OracleConnectionDataProvider : DbConnectionDataProvider, ICanHandleUsedIdentifiers, IDataProvider, combit.Reporting.ISupportsLogger

public ref class OracleConnectionDataProvider sealed : public DbConnectionDataProvider, ICanHandleUsedIdentifiers, IDataProvider, combit.Reporting.ISupportsLogger

Remarks

As the connection object will be cloned multiple times, the connection string needs to set Persist Security Info to True (see sample below) if user/password authentication is used. This class is serializable.

Example

using combit.Reporting;
using combit.Reporting.DataProviders;
using Oracle.ManagedDataAccess.Client;

OracleConnectionStringBuilder oracleConnectionStringBuilder =
    new OracleConnectionStringBuilder
    {
        DataSource = Properties.Resources.OracleInstance,
        UserID = Properties.Resources.OracleUsername,
        Password = Properties.Resources.OraclePassword,
        PersistSecurityInfo = true
    };

OracleConnectionDataProvider oracleDataProvider =
    new OracleConnectionDataProvider(
        oracleConnectionStringBuilder.ConnectionString,
        "HR"
        );

using (ListLabel LL = new ListLabel())
{
    LL.DataSource = oracleDataProvider;
    LL.Design();
}

Inheritance Hierarchy

System.Object
combit.Reporting.DataProviders.DbConnectionDataProvider
combit.Reporting.DataProviders.OracleConnectionDataProvider

Requirements

This data provider requires the NuGet package Oracle.ManagedDataAccess which contains the Oracle ODP.NET (Oracle Data Provider for .NET).

Reference

OracleConnectionDataProvider Members
combit.Reporting.DataProviders Namespace

Send Feedback