ADO Properties

  • Thread starter Thread starter Edward Diener
  • Start date Start date
E

Edward Diener

I ADO various objects, such as Connection, Command Parameters, and
Recordsets have a Properties collection which give information about the
underlying RDBMS. What is the equivalent to these Property collections in
ADO .NET ?
 
Hi Edward,

ADO.NET has same objects like Connection , Command object as ADO does. But,
in ADO.NET
there is Dataset in place of Recordset. Dataset is a disconnected
Recordset.The DataSet is explicitly
designed for data access independent of any data source. As a result it can
be used with multiple and
differing data sources, used with XML data, or used to manage data local to
the application.

The System.Data namespace consists mostly of the classes that constitute the
ADO.NET architecture.
The ADO.NET architecture enables you to build components that efficiently
manage data from multiple
data sources. In a disconnected scenario (such as the Internet), ADO.NET
provides the tools to request,
update, and reconcile data in multiple tier systems.

For e better insight into this topic,you can refer to the following link
[System.Data Namespace]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataodbc.asp

HTH

Mona
 
Mona(Grapecity) said:
Hi Edward,

ADO.NET has same objects like Connection , Command object as ADO does.
But,
in ADO.NET
there is Dataset in place of Recordset. Dataset is a disconnected
Recordset.The DataSet is explicitly
designed for data access independent of any data source. As a result it
can
be used with multiple and
differing data sources, used with XML data, or used to manage data local
to
the application.

The System.Data namespace consists mostly of the classes that constitute
the
ADO.NET architecture.
The ADO.NET architecture enables you to build components that efficiently
manage data from multiple
data sources. In a disconnected scenario (such as the Internet), ADO.NET
provides the tools to request,
update, and reconcile data in multiple tier systems.

For e better insight into this topic,you can refer to the following link
[System.Data Namespace]
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpref/html/frlrfsystemdataodbc.asp
Click to expand...

I know all of this. What does this have to do with my initial question ?
Where are the equivalent in ADO .NET to the ADO properties ? There appears
to be no information in the ADO .NET connection, command, and dataset
classes to the sort of RDBMS specific properties which ADO exposes through
its Properties collection in its Connection, Command, and Recordset ActiveX
classes. I can understand that for particular implementations in ADO .NET,
like SqlClient and OracleClient, one can use what one knows specifically
about Sql Server and Oracle, but for OleDb or Odbc one can not hard-code
RDBMS properties since the RDBMS is not know until run-time.
 
Back
Top