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 |
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. |
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. |