Oracle ADO.NET classes ??

[Mark]

I'm confused ... I've read in a number of places that in VS2005, ADO.NET
contains Oracle specific classes under the System.Data namespace (actually
this was supposed to be available for the v1.1 framework). But I don't see
the Oracle stuff in the Object Browser.

I see:
System.Data.Common
System.Data.Odbc
System.Data.OleDb
System.Data.Sql
System.Data.SqlClient
System.Data.SqlTypes

(only System.Data.Sql is new relative to the v1.1 framework)

So where is the Oracle stuff ? What am I missing??

Thanks

 

[Guest]

Hi Mark,

You need add reference by

Website -> Add Reference …
In Add Reference window, select System.Data.OracleClient

HTH

Elton Wang

 

[Mark]

Thanks Elton ... I guess that's a big "Duh!"

 

[Guest]

Make a reference to the Oracle DLL and then the using statement.

Note that ODP.NET (free download from Oracle TechNet) is a better library if
you are into serious Oracle development.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************