9. Understanding .NET Data Provider Connectivity : .NET Data Provider Classes : IngresConnectionStringBuilder Class
 
Share this page                  
IngresConnectionStringBuilder Class
The IngresConnectionStringBuilder class provides a series of properties and methods to create syntactically correct connection string and to parse and rebuild existing connection strings.
IngresConnectionStringBuilder Class Declaration
The IngresConnectionStringBuilder class can be declared as follows:
C#: public sealed class IngresConnectionStringBuilder : DbConnectionStringBuilder
VB.NET: NotInheritable Public Class IngresConnectionStringBuilder
Inherits DbConnectionStringBuilder
IngresConnectionStringBuilder Class Properties
The IngresConnectionStringBuilder class has the following properties:
Property
Accessor
Description
BrowsableConnectionString
get set
Indicates whether the ConnectionString Property is visible in Visual Studio designers.
BlankDate
get set
BlankDate=null specifies that an Ingres blank (empty) date result value is to be returned to the application as a null value. The default is to return an Ingres blank date as a DateTime value of "9999-12-31 23:59:59".
CharacterEncoding
get set
Specifies the .NET character encoding (for example, ISO-8859-1) used for conversions between Unicode and character data types.
Compress
get set
Specifies whether network communication blocks are compressed between the data provider and server.
ConnectTimeout
get set
The time, in seconds, to wait for an attempted connection to time out if the connection has not completed. Default is 15.
Count
get
The number of keys contained within the ConnectionString property.
CursorMode
get set
Specifies the default cursor concurrency mode, which determines the concurrency of cursors that have no explicitly assigned option in the command text. For example, FOR UPDATE or FOR READONLY.
Database
get set
Name of the Ingres or Vector database being connected to.
DateAlias
get set
Specifies the alias data type for the DATE data type:
ansidate—Sets ANSIDATE as the alias for DATE
ingresdate—Sets INGRESDATE is the alias for DATE
DateFormat
get set
Specifies the Ingres date format to be used by the Ingres server for date literals. Corresponds to the Ingres environment variable II_DATE_FORMAT and is assigned the same values.
DbmsUser
get set
The user name associated with the DBMS session.
DbmsPassword
get set
The DBMS password of the user.
DecimalChar
get set
Specifies the character that the Ingres DBMS Server is to use to separate fractional and non-fractional parts of a number—the comma (',') or the period ('.'). Default is the period.
Encrypt
get set
If set to true, encrypt the data between the data provider and server. Default is true.
EncryptionAESKeySize
get set
Size of the AES key in bits. Supported values are: 128, 192, and 256. Default is 128.
EncryptionRSAKeySize
get set
Size of the RSA key in bits. Supported values are: 1024, 2048, 3072, and 4096. Default is 1024
EncryptionRSAKeyScope
get set
Defines the scope where an RSA key is used:
process—(Default) One RSA key is generated in a process and used for all connections originating from that process.
connection—An RSA key is generated for each connection and used only for that connection.
Enlist
get set
If set to true and if the creation thread is within a transaction context as established by System.EnterpriseServices.ServicedComponent, the IngresConnection is automatically enlisted into the transaction context. Default is true.
GroupID
get set
Group identifier that has permissions for a group of users.
IdentifierDelimiter
get set
The character recognized by the data provider to delimit an identifier:
dquote—(Default) Recognizes only double-quotes
bracket—Recognizes both double-quotes and brackets
Item
get set
The value associated with the key. This property is the C# indexer for the IngresConnectionStringBuilder class.
Keys
get
An ICollection of keys of type String in the IngresConnectionStringBuilder.
MaxPoolSize
get set
Maximum number of connections that can be in the connection pool. Default is 100.
MinPoolSize
get set
Minimum number of connections that can be in the connection pool. Default is 0.
MoneyFormat
get set
Specifies the Ingres money format to be used by the Ingres server for money literals. Corresponds to the Ingres environment variable II_MONEY_FORMAT and is assigned the same values.
MoneyPrecision
get set
Specifies the money precision to be used by the Ingres server for money literals. Corresponds to the Ingres environment variable II_MONEY_PREC and is assigned the same values.
Password
get set
The password to the Ingres database.
PersistSecurityInfo
get set
Indicates whether password information is returned in a get of the ConnectionString.
Pooling
get set
Enables or disables connection pooling. By default, connection pooling is enabled (true).
Port
get set
Port number on the target server machine that the Data Access Server is listening to. Default for Ingres is II7. Default for Vector is VW7.
PreFetchBlocks
get set
Pre-fetch blocking factor to override the default algorithm for computing the number of row blocks to fetch from a result-set. Default is 1 (no changes in default pre-fetch behavior).
RoleID
get set
Role identifier that has associated privileges for the role.
RolePassword
get set
Role password associated with the Role ID.
SendIngresDates
get set
Specifies whether DateTime, Date, and Time values should be sent as INGRESDATE data type. Valid values are:
false–(Default) Sends values as ANSI timestamp_with_timezone, ANSI date, ANSI time respectively.
true–Sends values as INGRESDATE type.
This option can be used for compatibility with semantic rules from older releases of Ingres
Server
get set
The Ingres or Vector host server to connect to.
Timezone
get set
Specifies the Ingres or Vector time zone associated with the user's location. Used by the Ingres server only. Corresponds to the Ingres environment variable II_TIMEZONE_NAME and is assigned the same values.
UserID
get set
The name of the authorized user connecting to the DBMS Server. This value may be case-sensitive depending on the target server.
Values
get
An ICollection of values of type Object in the IngresConnectionStringBuilder.
VnodeUsage
get set
Allows the .NET application to control the portions of the vnode information that are used to establish the connection to the remote DBMS server through the Ingres Data Access Server:
connect—(Default) Uses only the vnode connection information
login—Uses both the vnode connection and login information
IngresConnectionStringBuilder Class Methods
The public methods available to the IngresConnectionStringBuilder class are:
Method
Description
Add
Adds a key and value to the collection within IngresConnectionStringBuilder.
Clear
Clears all keys and values from IngresConnectionStringBuilder. Sets ConnectionString propery to “”.
ContainsKey
Returns true if IngresConnectionStringBuilder contains the specified key.
EquivalentTo
Returns true if keys and values are comparable to the specified IngresConnectionStringBuilder object.
Remove
Removes the entry with the specified key from IngresConnectionStringBuilder.
ToString
Returns the ConnectionString associated in the IngresConnectionStringBuilder.
TryGetValue
Returns a value corresponding to the specified key from the IngresConnectionStringBuilder. Returns false if the key was not found.
IngresConnectionStringBuilder Class Constructors
The IngresConnectionStringBuilder class has the following constructors:
Constructor Overloads
Description
IngresConnectionStringBuilder ()
Instantiates a new instance of the IngresConnectionStringBuilder class using default property values
IngresConnectionStringBuilder (string)
Instantiates a new instance of the IngresConnectionStringBuilder class using the specified connection string.