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:// | ||
+ | [[https:// | ||
+ | [[https:// | ||
+ | ====== 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; | ||
+ | |||
+ | | ||
+ | |||
+ | * **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; | ||
+ | |||
+ | | ||
+ | |||
+ | **Note.** Microsoft OracleClient is deprecated in .NET 4.0 and will be removed in future .NET versions. | ||
+ | |||