确实用Oracleclient类很方便,但微软在vs2010里威胁说“The types in System.Data.OracleClient are deprecated. The types are supported in version 4 of the .NET Framework but will be removed in a future release. Microsoft recommends that you use a third-party Oracle provider.The .NET Framework Data Provider for Oracle provides access to an Oracle database using the Oracle Call Interface (OCI) as provided by Oracle Client software. ”,言外之意就是让用户投奔OCI,这可要出人命了。
你还是老实地使用Oracle.net库吧。用起来很方便。
你从Oracle官网上下载一个ODAC9207.exe或者Oracle.net安装一下就行。
它叫odp.net. 用的是Oracle.DataAccess.dll (Oracle.DataAccess.Client)
这个才是效率最高的实现。