How to: Consume ODP.NET Oracle, Managed Driver

This article is relevant to entity models that utilize the deprecated Visual Studio integration of Telerik Data Access. The current documentation of the Data Access framework is available here.

Telerik Data Access allows you to access Oracle databases through the ODP.NET Oracle, Managed Driver, version 4.121.1.0. The driver requires .NET Framework 4.0 or higher, and Visual Studio 2010 or higher. It is available for download from Oracle .NET Developer Center. During the installation process, Oracle Universal Installer performs the required configuration settings for the driver.

To utilize the driver in the applications, which use Telerik Data Access, you need to provide Oracle.ManagedDataAccess.Client as a value for the providerName attribute in the connection string used for instantiating the context. For example:

The new providerName value should be added not only in the config files of the projects that hold Telerik Data Access models, but in the config files of the projects, which consume them as well.

<connectionStrings>
    <add name="Connection"
         connectionString="data source=SERVERNAME;persist security info=True;
                           user id=SCHEMANAME;password=PASSWORD;unicode=True"
         providerName="Oracle.ManagedDataAccess.Client" />
</connectionStrings>