OracleConnectionStringBuilder Class

In This Topic

Generates automatically connection strings used to connect to Oracle.

Syntax

Visual Basic
C#

'Declaration
 
Public Class OracleConnectionStringBuilder 
   Inherits Devart.Common.DbConnectionStringBuilder
   Implements System.Collections.ICollection, System.Collections.IDictionary, System.Collections.IEnumerable, System.ComponentModel.ICustomTypeDescriptor

public class OracleConnectionStringBuilder : Devart.Common.DbConnectionStringBuilder, System.Collections.ICollection, System.Collections.IDictionary, System.Collections.IEnumerable, System.ComponentModel.ICustomTypeDescriptor

Remarks

The OracleConnectionStringBuilder allows you to construct a connection string by assigning values to corresponding properties. After you have initialized all connection properties you need, use System.Data.Common.DbConnectionStringBuilder.ConnectionString property or ToString method to obtain the connection string built.

Example

This sample shows how to construct a connection string and pass it to OracleConnection object.

csharp

public void UseConnectionStringBuilder()
{
        OracleConnectionStringBuilder myCSB = new OracleConnectionStringBuilder();
        oraCSB.Direct = true;
        oraCSB.Server = "192.168.0.1";
        oraCSB.Port = 1521;
        oraCSB.Sid = "OracleSid";
        oraCSB.UserId = "scott";
        oraCSB.Password = "tiger";
        oraCSB.MaxPoolSize = 150;
        oraCSB.ConnectionTimeout = 30;
        OracleConnection myConnection = new OracleConnection(myCSB.ConnectionString);
        myConnection.Open();
        Console.WriteLine(myConnection.ServerVersion);
        myConnection.Close();
}

Visual Basic

Public Sub UseConnectionStringBuilder()
        Dim myCSB As OracleConnectionStringBuilder = New OracleConnectionStringBuilder
        oraCSB.Direct = true
        oraCSB.Server = "192.168.0.1"
        oraCSB.Port = 1521
        oraCSB.Sid = "OracleSid"
        oraCSB.UserId = "scott"
        oraCSB.Password = "tiger"
        oraCSB.MaxPoolSize = 150
        oraCSB.ConnectionTimeout = 30
        Dim myConnection As OracleConnection = New OracleConnection(myCSB.ConnectionString)
                myConnection.Open()
        Console.WriteLine(myConnection.ServerVersion)
        myConnection.Close()
End Sub

Inheritance Hierarchy

System.Object
   System.Data.Common.DbConnectionStringBuilder
      Devart.Common.DbConnectionStringBuilder
         Devart.Data.Oracle.OracleConnectionStringBuilder

Reference

OracleConnectionStringBuilder Members
Devart.Data.Oracle Namespace
ConnectionString Property

Send Feedback