Microsoft 宣布其不再支持 System.Data.OracleClient，即 Microsoft OracleClient。许多使用 Microsoft OracleClient 连接到 Oracle 数据库的 .NET 开发人员为此感到困惑。Oracle 建议 .NET 开发人员使用 Oracle Data Provider for .NET (ODP.NET) 构建新的应用程序，并将现有的应用程序迁移到 ODP.NET。以下阐释了为什么 ODP.NET 是成千上万的开发人员中最流行的 Oracle ADO.NET 提供程序。
Oracle 数据访问组件 (ODAC) 下载 ：http://www.oracle.com/technology/global/cn/software/tech/windows/odpnet/index.html
ODP.NET: Free and Fully Supported
There is no charge to develop, test, deploy, or distribute ODP.NET....ever! Unlike third-party ADO.NET drivers which charge for use, ODP.NET is free. If you already have Oracle Database support, then ODP.NET support is included for free.
ODP.NET: Best Oracle Data Access Performance
ODP.NET is so popular because developers it is the fastest .NET data access to Oracle Database. Nobody knows Oracle database than Oracle. The ODP.NET development team uses this knowledge to deliver the largest set of Oracle .NET provider tuning options. Programmers can employ an impressive array of client tuning features, including statement caching, result set fetch tuning, Client Result Set Caching, and parameter array binding. With the latest ODP.NET release, data access tuning is even easier with the new ODP.NET self-tuning feature, which automatically optimizes data access in real-time.
Microsoft MVPs Use and Recommend ODP.NET
Many Microsoft Most Valuable Professionals (MVPs) already use and recommend ODP.NET. Microsoft officially recognizes MVPs as experts in the IT field. MVPs who endorse ODP.NET for Oracle .NET data access include Bill Evjen, founder of INETA; Andrew Brust; and John Cook. Each MVP writes books, articles, and/or consults on .NET data access, always looking for the best solutions for Microsoft developers.
Listen to the first few minutes of The Connected Show webcast where Andrew Brust discusses the Microsoft OracleClient deprecation and why he maintains a positive opinion of ODP.NET and recommends it.
Use a Single ODP.NET Version to Support All your Oracle Databases
Each ODP.NET client supports connectivity to any currently supported Oracle Database version, such as 10g, 11g, or 9i. That means your ODP.NET 11g (or 10g) client application can access any of these Oracle database versions. No need to install more than one client.
Multiple ODP.NET Versions Can Co-exist
If you do need to run multiple ODP.NET versions on the same machine, ODP.NET supports side by side deployments. No DLL Hell!
ODP.NET: Best .NET Developer Productivity
ODP.NET is just part of a family of .NET development components for Oracle database. Other major Oracle .NET products include Oracle Developer Tools for Visual Studio (ODT), Oracle Providers for ASP.NET, and Oracle Database Extensions for .NET.
ODP.NET supports the Microsoft Visual Studio 2008 and .NET Framework 3.5, compliant with ADO.NET 1.x and higher. ODP.NET will support Microsoft Visual Studio 2010 and .NET Framework 4 soon after their release. ODP.NET is fully integrated into Visual Studio so that it can auto-generate data access code for your Oracle .NET applications.
ODT is a tightly-integrated add-in for Microsoft Visual Studio which enhances .NET developer productivity. Programmers can automatically generate ODP.NET code; edit data and the Oracle schema; manage users and roles; edit and debug PL/SQL; automatically generate and edit Oracle SQL and PL/SQL scripts and check them into source control. Visual Studio 2008, 2005, and 2003 are all supported.
Oracle Providers for ASP.NET store web application state in the Oracle database to ensure high availability of application data, while making the data equally available to all web servers. For .NET developers already familiar with ASP.NET providers, the Oracle Providers for ASP.NET are easy to learn and use as they share a common schema and API with existing ASP.NET providers. They integrate seamlessly with existing ASP.NET services and controls, similar to other ASP.NET providers. Oracle offers the following providers:
- Membership Provider
- Role Provider
- Site Map Provider
- Session State Provider
- Profile Provider
- Web Events Provider
- Web Parts Personalization Provider
- Cache Dependency Provider
Oracle Database Extensions for .NET is an Oracle Database option on Windows that makes it easy to develop, deploy, and run stored procedures and functions written in a .NET managed language, such as C# or Visual Basic.
相关资料：
http://www.oracle.com/technology/software/tech/windows/odpnet/install10202.html
http://www.oracle.com/technology/software/tech/dotnet/ode10202rn.html
http://www.oracle.com/technology/software/tech/dotnet/odt10202rn.html
