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. |
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. |
DataSource | get set | The name of the target server. |
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. |
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 | The number of data blocks to be prefetched. By default, the rows that fit in one communication data block are prefetched. When this property is set, the prefetch block count is multiplied by the default prefetch row count to determine the number of rows to be prefetched. Depending on the row size and unused space in the rows, the number of blocks retrieved may be different. |
PrefetchStream | get set | Specifies whether to enable high performance prefetch of data as a stream from the result set when using a select loop (a SELECT query that is neither prepared nor has parameters). Default is false, meaning no change in current 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 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. |