C # VS2010, using Microsoft's own System.Data.OracleClient to connect to the Oracle database

Because of Microsoft in the. NET Framework 4.0 has decided to revoke the use of System.Data.OracleClient, resulting in the inability to connect to the Oracle database in VS2010, but it still exists in the. NET schema and we can refer to it by ourselves

C:\Windows\Microsoft.NET\Framework\v2.0.50727\System.Data.OracleClient.dll to gain support for Oracle databases.

Method:

1. Open in VS2010 [solution Manager]--Right click [Reference]--[Add Reference]

2, select [Browse] to find the "C:\Windows\Microsoft.NET\Framework\v2.0.50727" directory, select the following System.Data.OracleClient.dll

You can then use the using System.Data.OracleClient in the Program editing window.

In addition: Microsoft decided to revoke System.Data.OracleClient content as follows:

For those development. NET application and the database is Oracle, this news is particularly meaningful, and Microsoft is planning to remove the Oracle data provider from the ADO roadmap.

Microsoft decided to revoke System.Data.OracleClient because a significant number of MVP would prefer to select a third-party Oracle data provider and be responsible for the Product manager at ADO OracleClient Himanshu Vasishth announced the decision in the ADO Team blog post.

But in. NET Framework 4.0, Microsoft will continue to support System.Data.OracleClient, but will be labeled "unsuitable", according to Vasishth, which has no impact on existing applications, they will work as expected.

He mentions in the article that "it is still possible to use OracleClient to develop new applications, but when compiling in. Net 4.0 a warning dialog pops up and the runtime no longer pops up a warning dialog box, we strongly recommend that users use our partners ' ADO Provider for Oracle replaces Microsoft OracleClient for new application development ".

Third-party providers of Oracle data providers are DataDirect and Devart technology companies, and Oracle data providers are also known as Oracle Database Provider for. NET (Odp.net), These are very popular Oracle database providers.

C # VS2010, using Microsoft's own System.Data.OracleClient to connect to the Oracle database