hello everybody. thanks in advance for your help.

i'm doing a connection to an oracle database with visual c#.
I now my programs must have a look like this:

public void ConnectToOracle()
{
    OracleClient.OracleConnection conn =
        new OracleClient.OracleConnection ();
    // TODO: Modify the connection string and include any
    // additional required properties for your database.
    conn.ConnectionString = "Data Source=" +
        "<oracle data source name>;Integrated Security=yes";
    try
    {
        conn.Open();
        // Insert code to process data.
    }
        catch (Exception ex)
    {
        MessageBox.Show("Failed to connect to data source");
    }
    finally
    {
        conn.Close();
    }
}

my problem is how can i access to the class "oracleconnection". it belongs to:

System.Object
   System.MarshalByRefObject
      System.ComponentModel.Component
         System.Data.OracleClient.OracleConnection

but i don't know how to add this namespaces or classes. any help will be really apreciated. thanks.

                                   silvi

You'll need an assembly reference to the assembly that contains that class. For the oracle client it's the System.Data.OracleClient.dll assembly of the framework.

-Peter

Could you please explain me how to do that? this is the first time i work with C# and I'm not familiarized with it. Thanks a lot.

                                      silvi

Hi silvia,

In your solution explorer right click on References-->Add Reference. Select System.Data.OracleClient.dll in .Net tab and then press ok. Then make sure you'll see System.Data.OracleClient.dll has added to your References.



nalaka hewage

Thanks to everybody who answered. I think it works now. I was going mad with something so simple.

                             silvi