.NET Data Provider Enhancements
Enhancements to the .NET Data Provider include:
• New keywords in the connection string:
dbms_user
Specifies the user name to be associated with the DBMS session. This keyword is equivalent to the Ingres -u flag, which can require administrator privileges.
dbms_password
Specifies the DBMS password for the user. This flag is equivalent to the Ingres -P flag.
character encoding
Specifies the .NET character encoding used for conversions between Unicode in the .NET application and character data types in the database. Typically, the character encoding is determined automatically by the data provider from the Data Access Server installation character set. This keyword allows an alternate character encoding to be specified or a valid character encoding to be used if the data provider is unable to map the server's character set.
• Integration with Visual Studio 2005 and Visual Studio 2008 is enabled by additional properties to IngresConnectionStringBuilder. New edit boxes are added to the Connection String Editor dialog.
• The current Interval data type is split into two data types: IntervalDayToSecond and IntervalYearToMonth. The IntervalYearToMonth remains mapped to .NET String data type. The IntervalDayToSecond is mapped to .NET TimeSpan data type.
For details, see the sections Connection String Keywords, Connection String Editor (Data Adapter Configuration Wizard), and Mapping of Ingres Native Types to .NET Types in the chapter "Understanding .NET Data Provider Connectivity" in the Connectivity Guide.