dotConnect for Oracle Documentation
Devart.Data.Oracle Namespace / OracleConnectionStringBuilder Class
Members Example

On this page
    OracleConnectionStringBuilder Class
    On this page
    Generates automatically connection strings used to connect to Oracle.
    Syntax
    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.
    public void UseConnectionStringBuilder()
    {
            OracleConnectionStringBuilder oracleCSB = 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 oracleConnection = new OracleConnection(oracleCSB.ConnectionString);
            oracleConnection.Open();
            Console.WriteLine(oracleConnection.ServerVersion);
            oracleConnection.Close();
    }
    Public Sub UseConnectionStringBuilder()
            Dim oracleCSB 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 oracleConnection As OracleConnection = New OracleConnection(oracleCSB.ConnectionString)
                    oracleConnection.Open()
            Console.WriteLine(oracleConnection.ServerVersion)
            oracleConnection.Close()
    End Sub
    Inheritance Hierarchy

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

    See Also