DbConnectionStringBuilder Class

Generates automatically connection strings used to connect to database.

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

Inheritance Hierarchy

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

Syntax

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

[C#]
public class DbConnectionStringBuilder : DbConnectionStringBuilder, ICollection, IDictionary, IEnumerable, ICustomTypeDescriptor

Remarks

The DbConnectionStringBuilder class provides the base class from which the strongly typed connection string builders (Devart.Data.Oracle.OracleConnectionStringBuilder) are derived. The connection string builders let developers programmatically create syntactically correct connection strings, and parse and rebuild existing connection strings. The DbConnectionStringBuilder has been defined in a database-agnostic manner. Because of the addition of the Devart.Common namespace, developers require a base class against which they can program in order to build connection strings that can work against an arbitrary database. But it is possible using this class to create invalid connection strings. It is recommended to use the strongly typed connection string builders (Devart.Data.Oracle.OracleConnectionStringBuilder and so on) because they support only key/value pairs that are supported by particular RDBMS; trying to add invalid pairs will throw an exception. For more information, refer to the description of the DbConnectionStringBuilder class in MSDN.

Example

[C#]

Devart.Common.DbConnectionStringBuilder csb = new Devart.Common.DbConnectionStringBuilder(); 
csb["Direct"] = true; 
csb["Server"] = "192.168.0.1"; 
csb["Port"] = 1521; 
csb["Sid"] = "OracleSid"; 
csb["User Id"] = "scott"; 
csb["Password"] = "tiger"; 
csb["Max Pool Size"] = 150; 
csb["Connection Timeout"] = 30; 
Devart.Data.Oracle.OracleConnection myConnection = new Devart.Data.Oracle.OracleConnection(csb.ConnectionString);

[Visual Basic]

Dim csb As Devart.Common.DbConnectionStringBuilder = New Devart.Common.DbConnectionStringBuilder
 csb("Direct") = true
 csb("Server") = "192.168.0.1"
 csb("Port") = 1521
 csb("Sid") = "OracleSid"
 csb("User Id") = "scott"
 csb("Password") = "tiger"
 csb("Max Pool Size") = 150
 csb("Connection Timeout") = 30
 Dim myConnection As Devart.Data.Oracle.OracleConnection = New Devart.Data.Oracle.OracleConnection(csb.ConnectionString)

See Also

Language