OracleConnectionStringBuilder Class

Generates automatically connection strings used to connect to an Oracle database.

For a list of all members of this type, see OracleConnectionStringBuilder members.

Inheritance Hierarchy

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

Syntax

[Visual Basic]
Public Class OracleConnectionStringBuilder 
   Inherits DbConnectionStringBuilder
   Implements ICollection, IDictionary, IEnumerable, ICustomTypeDescriptor

[C#]
public class OracleConnectionStringBuilder : DbConnectionStringBuilder, ICollection, IDictionary, IEnumerable, 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 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.

[C#]

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

See Also

Language