New to Telerik Reporting? Download free 30-day trial

Overview

The Oracle Data Provider for .NET (ODP.NET) features optimized ADO.NET data access to Oracle databases.

There are three driver types: ODP.NET Core; ODP.NET, Managed Driver; and ODP.NET, Unmanaged Driver. ODP.NET Core is designed for multi-platform .NET (Core) applications. ODP.NET, Managed Driver is a 100% managed code .NET Framework provider.

Setting up the ODP.NET Data Provider in the .NET Standalone Report Designer

  1. Create a new .NET 8 Console Application project.
  2. Install the Oracle.ManagedDataAccess.Core NuGet package to it and build the project.
  3. Navigate to the bin/Debug/net8.0 subdirectory of the project, and copy all assemblies there except for the assembly with the name of the project.
  4. Paste the assemblies in the .NET Standalone Report Designer installation directory e.g. C:\Program Files (x86)\Progress\Telerik Reporting 2024 Q3\Report Designer\.NET.
  5. Start the .NET Standalone Report Designer from the same directory and add a new SqlDataSource component which should trigger the SqlDataSource Wizard. The ODP.NET Managaed data provider should now be listed among the rest of the data providers when building a new connection.

Setting up the ODP.NET Data Provider in the .NET Framework Standalone Report Designer

Visit the official Download ODP.NET, Oracle Developer Tools for Visual Studio (Code), and ODAC page and download the MSI installer for the Oracle Client for Microsoft Tools.

Choose between the 32-bit and 64-bit Oracle Client for Microsoft Tools installers depending on which .NET Framework Standalone Report Designer will be used. The default one is the 64-bit variant.

Setting up the ODP.NET Data Provider in .NET Applications

The Oracle Data Provider for .NET (ODP.NET) data provider is automatically registered in the Telerik.Reporting.Processing.Data.DbProviderFactories. To use this data provider, it should be enough to install the Oracle.ManagedDataAccess.Core NuGet package to the project.

If the SqlDataSource component uses a shared connection where it is retrieved from the configuration file of the project(e.g. appsettings.json), the provider name must be specified in the connection. For example:

{
    "ConnectionStrings":{
        "oracle":{
            "connectionString":"Data Source=TORCL;User Id=myUsername;Password=myPassword;",
            "providerName":"Oracle.ManagedDataAccess.Client"
            }
    }
}

See Also

In this article