Re: ADO Properties

From: Edward Diener (diener_no_spam_ok_at_ORsoftware.com)
Date: 12/22/04


Date: Wed, 22 Dec 2004 07:19:04 -0500


"Mona(Grapecity)" <mona@discussions.microsoft.com> wrote in message
news:%23w%23sVNA6EHA.1260@TK2MSFTNGP12.phx.gbl...
> 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

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.

>
> HTH
>
> Mona
>
>
> "Edward Diener" <diener_no_spam_ok@ORsoftware.com> wrote in message
> news:eMzsqh35EHA.2624@TK2MSFTNGP11.phx.gbl...
>> 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 ?
>>
>>
>
>



Relevant Pages

  • Re: ADOCommand and grave accent problem
    ... problem - Paolo has spotted the solution. ... a parameterised command I do not know. ... >> when using an ADO Command, and not when using an ADO Connection object. ...
    (borland.public.delphi.database.ado)
  • Re: SET IDENTITY_INSERT tablename ON problem
    ... Try to do next - run SQL profiler and see if ADO Command ... Another way is to use Execute method of ADO connection. ... > database I add a new tmp table with the new structure. ...
    (microsoft.public.vb.database.ado)
  • Re: Use DAO or ADO?
    ... ADO Objects ... Source Property (ADO Recordset) ... Resync Command Property-Dynamic (ADO) ... Execute Method (ADO Connection) ...
    (comp.databases.ms-access)
  • Re: C++ support for ADO
    ... TESTHR(pConn.CreateInstance(__uuidof(Connection))); ... In answer to your question I'm interested in ADO not the ADO.net. ... data classes for working with ADO/OLE DB. ... You can also use the OLE SDK. ...
    (microsoft.public.data.ado)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.inetserver.asp.db)