combit List & Label 30 - .NET Help
combit.Reporting.DataProviders Namespace / OracleConnectionDataProvider Class
Members


OracleConnectionDataProvider Class

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
OracleConnectionDataProvider Class
Syntax
'Declaration
 
Public NotInheritable Class OracleConnectionDataProvider 
   Inherits DbConnectionDataProvider
   Implements 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).

See Also