Differences

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


Previous revision
sqlways:ado-net-oracle-migration [May 31, 2023, 05:28:08 PM] (current) – external edit 127.0.0.1
Line 1: Line 1:
 +\\
 +[[https://www.ispirer.com|Ispirer Website]]
 +[[https://www.ispirer.com/products/oracle-migration|Ispirer Capabilities - Oracle Migration]]
 +[[https://www.ispirer.com/download/download-demo|Free Trial]]
 +====== 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.
 +
  

© 1999-2024, Ispirer Systems, LLC. All Rights Reserved.