How to connect Oracle to my C# program

Hi

How to connect Oracle to my C# program ?

thank's

From stackoverflow

• Use ADO.Net.

• Here are some tutorials detailing how this can be done:

  Connect to ORACLE database using C#

  Using Microsoft .NET and C# with Oracle 9i

  Connect to an Oracle Database

• This is the way you should ask your question:

• Use the System.Data.OracleClient namespace. Also you will need the Oracle client drivers installed on your workstation/server.

• You have to choose a data provider. There are different data providers for combining .NET and Oracle: ODP.NET (http://www.oracle.com/technology/tech/windows/odpnet/index.html), Devart's provider (http://devart.com/dotconnect/oracle/) and a provider from Microsoft (System.Data.OracleClient). Maybe there are other providers too. Google them.

  System.Data.OracleClient has a very limited set of features so I wont use that provider.