System.Data.OracleClient.OracleConnection is obsolete

The solution is as follows:

1. Put the original using System.Data.OracleClient; Remove

2. Locate the Oracle.DataAccess.dll Add reference under the Oracle installation directory:using Oracle.DataAccess.Client;

If you are installing Oracle 10g, you do not have a DLL registered in Visual Studio, you cannot find it when you add a reference, and 11g is registered by default.

Can be found in the Oracle installation directory via the Windows-brought file search feature .

If Oracle is installed in the D-packing directory, the path to the DLL file is as follows:

D:\oracle\product\10.2.0\client_1\ODP.NET\bin\1.x Client

D:\oracle\product\10.2.0\db_1\ODP.NET\bin\1.x Server

3. If the connection string is useful, user=xxx is changed to user id=xxx

System.Data.OracleClient.OracleConnection is obsolete