Ispirer Ispirer
 

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

sqlways:ado-net-oracle-migration [May 07, 2018, 03:15:24 PM] (current)
Line 1: Line 1:
 +\\
 +[[http://www.ispirer.com|Ispirer Home Page]]
 +[[http://www.ispirer.com/products|Ispirer SQLWays Product Page]]
 +[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]
  
 +====== ADO.NET - Oracle Data Provider - Migration ======
 +
 +===== Overview =====
 +
 +You can access Oracle databases in .NET applications using Oracle Data Provider for .NET (ODP.NET) and Microsoft OracleClient for .NET
 +
 +  * **Oracle Data Provider for .NET (ODP.NET)**
 +
 +ODP.NET is an optimized ADO.NET provider developed by Oracle, its component name is **Oracle.DataAccess** (Add Reference list) and namespace is **Oracle.DataAccess.Client**
 +
 +Example:
 +
 +   using Oracle.DataAccess.Client;     -- C#
 +
 +   Imports Oracle.DataAccess.Client    ' VB.NET
 +
 +  * **Microsoft OracleClient for .NET**
 +
 +Microsoft OracleClient is the .NET Framework Data Provider for Oracle developed by Microsoft, its namespace is **System.Data.OracleClient** 
 +
 +Example:
 +
 +   using System.Data.OracleClient;     -- C#
 +
 +   Imports System.Data.OracleClient    ' VB.NET
 +
 +**Note.** Microsoft OracleClient is deprecated in .NET 4.0 and will be removed in future .NET versions.
 +
 +\\
 +[[http://www.ispirer.com|Ispirer Home Page]]
 +[[http://www.ispirer.com/products|Ispirer SQLWays Product Page]]
 +[[http://www.ispirer.com/?click=RequestSQLWays&from=IspirerWIKI|Request SQLWays]]
sqlways/ado-net-oracle-migration.txt · Last modified: May 07, 2018, 03:15:24 PM (external edit)
 
© 1999-2019, Ispirer Systems Ltd.
All Rights Reserved.  Privacy Statement