Should I use System.Data.OracleClient .NET data provider to retrieve data for reports from an Oracle database?

AUTHOR: Stephania Tapela

DATE POSTED: July 07, 2017

Article information
Article relates to	Telerik Reporting
Created by	Stef, Telerik
Modified By	Stef, Telerik
Last modified	July 7, 2017

PROBLEM 
Should I use System.Data.OracleClient .NET data provider to retrieve data for reports from an Oracle database?

DESCRIPTION
System.Data.OracleClient is a Microsoft .NET data provider allowing you to connect to an Oracle database. The provider is deprecated and it should not be used - Oracle and ADO.NET (docs.microsoft.com).

SOLUTION 
We recommend the usage of Oracle Data Provider for .NET/ODP.NET. More .NET data providers and how they can be used for connecting to an Oracle database can be found in Oracle connection strings.

Note: Each .NET data provider has its own specification how to read SQL queries. If you use SQL parameters, please check the valid syntax for typing parameters in the SQL query.


You may find also interesting Data provider is missing in the SqlDataSource wizard.