tags:

views:

756

answers:

5

Hi

How to connect Oracle to my C# program ?

thank's

+2  A: 

Use ADO.Net.

Paulo Guedes
+4  A: 

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

nan
+2  A: 

This is the way you should ask your question:

A: 

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

Michael Kniskern
A: 

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.

tuinstoel