12. Understanding .NET Data Provider Connectivity : .NET Data Provider Classes : IngresConnectionStringBuilder Class : IngresConnectionStringBuilder Class Properties
 
Share this page                  
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.
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.
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