SQL Server 2005 : What's New in ADO 2.6

ADO MD CubeDef.GetSchemaObject Method
ADO MD objects can now be retrieved using unique names, as specified by the UniqueName property. The names of parent objects do not need to be known, and parent collections do not need to be populated to retrieve a schema object. See GetSchemaObject Method.

ADOX Group and User Properties

ADOX Group and User objects now surface a Properties collection, which can be populated with provider-specific properties. Specifically, the OLEDB:Trustee PIN property can be specified.

Command Streams
The Command object supports commands in stream format as an alternative to using the CommandText property. The CommandStream property can be used to specify XML Templates or updategrams as the Command input with the Microsoft OLE DB Provider for SQL Server.

Dialect Property
Dialect is a new property that defines the syntax and general rules that the provider uses to parse the string or stream.

Execute Method (ADO Command)
The Execute method of the Command object has been enhanced to use streams for input and output.

Field Status

Values If the user encounters a DB_E_ERRORSOCCURRED error when modifying a Field of a Recordset, ADO will now fill the Field.Status property with the appropriate status information so that the user will have more information about what went wrong. See Status Property (ADO Field).

NamedParameters Property
NamedParameters is a new property of the Command object that indicates that the provider should use named parameters.

Resultsets in Streams
ADO can return resultsets from a data source in a Stream, rather than a Recordset object. Using the latest version of the Microsoft OLE DB Provider for SQL Server, you can get XML results from the provider by executing a "For XML" query. A Stream that receives the resultset can be opened with a "For XML" command as the source.

Single Row Resultset
The ADO Record object can now be opened on a command string or Command object that returns one row of data from the provider. This results in improved performance with MDAC 2.6 providers.

No comments:

Post a Comment