OracleConnectionStringBuilder Class

On this page

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

'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

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(); }

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

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