C#.NET connect with Oracle

dpkbahuguna · March 15th, 2007, 03:45 AM

Hello Friends !!!

PLS tell me how to connect oracle to the C#.NET.

Waiting for any helpfull Reply!!!!!!!!!

DPK..

Morn · March 15th, 2007, 09:43 AM

You will just need to import the oracle namespace in your C# code.

Then it's just normal connection methods!

Not on my development system at the moment so don't have the exact coding but somthing like:

Code:

using System.Data.OracleClient;

should get you your data control elements.

Check this site out for more info.

http://msdn2.microsoft.com/en-us/lib...cleclient.aspx

DARSIN · March 16th, 2007, 09:08 AM

Also you can download ODP.Net from oracle its gives u better support for Oracle Types

jminatel · March 12th, 2008, 04:08 PM

You might also want to check the book Professional C# 2005 with .NET 3.0, Chapter 25 - Data Access with .NET discusses Oracle. Or Professional ASP.NET 2.0 Special Edition Chapter 11: Data Binding in ASP.NET 2.0. Both of them discuss using Oracle.

Jim Minatel
Acquisitions Director
Wiley Technology Publishing
WROX Press
Blog: http://wroxblog.typepad.com/
Wrox online library: http://wrox.books24x7.com