is that the main difference between ADO and ADO.net is

ADO = native C++, need write more code to do query

ADO.net = managed C++, write less code to do the same thing?

Not exactly.

ADO is COM, usable from, for instance, VB or other high-ish level languages that can use COM. Of
course, a low level language like C++ can also use ADO, assuming that lower level language can use
COM.
ADO in turn uses OLDEB, which is a lower level API.

ADO.NET is indeed managed code (framework). Which you can use from any language that supports
managed code.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Eric Kaplan" <tobycraftse@yahoo.com> wrote in message
news:g7jmu39oj1ci5v993m0ung604uroqgesed@4ax.com...
> is that the main difference between ADO and ADO.net is
>
> ADO = native C++, need write more code to do query
>
> ADO.net = managed C++, write less code to do the same thing?

The ability to 'write less code' is more a function of the wrappers
(classes/functions/routines) that the higher level languages sit on top of
the very low level code that actually communicates with the database
(oledb/sqlnativeclient).

--
Kevin G. Boles
Indicium Resources, Inc.
SQL Server MVP
kgboles a earthlink dt net


"Eric Kaplan" <tobycraftse@yahoo.com> wrote in message
news:g7jmu39oj1ci5v993m0ung604uroqgesed@4ax.com...
> is that the main difference between ADO and ADO.net is
>
> ADO = native C++, need write more code to do query
>
> ADO.net = managed C++, write less code to do the same thing?

> is that the main difference between ADO and ADO.net is
>
> ADO = native C++, need write more code to do query
>
> ADO.net = managed C++, write less code to do the same thing?

To add on to the other responses, the System.Data.SqlClient namespace
objects of ADO.NET provide native SQL Server data access from managed code.
This is in contrast with COM-based ADO, which is basically provides a
higher-level interface to lower level OLEDB drivers like SQLOLEDB.

--
Hope this s.

Dan Guzman
SQL Server MVP
http://weblogs.sqlteam.com/dang/

"Eric Kaplan" <tobycraftse@yahoo.com> wrote in message
news:g7jmu39oj1ci5v993m0ung604uroqgesed@4ax.com...
> is that the main difference between ADO and ADO.net is
>
> ADO = native C++, need write more code to do query
>
> ADO.net = managed C++, write less code to do the same thing?

It seems to me today, everybody use ADO.net instead of ADO. is it
true?

I cannot found much ebook book on ADO but ADO.net got tons?

why everyone use ADO.net now?




>Not exactly.
>
>ADO is COM, usable from, for instance, VB or other high-ish level languages that can use COM. Of
>course, a low level language like C++ can also use ADO, assuming that lower level language can use
>COM.
>ADO in turn uses OLDEB, which is a lower level API.
>
>ADO.NET is indeed managed code (framework). Which you can use from any language that supports
>managed code.

Yes, ADO.NET is a more modern API since .NET is more modern than COM.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Carmen Sei" <fatwallet951@yahoo.com> wrote in message
news:toqnu3930lp8isip341j111k4gttvkuull@4ax.com...
> It seems to me today, everybody use ADO.net instead of ADO. is it
> true?
>
> I cannot found much ebook book on ADO but ADO.net got tons?
>
> why everyone use ADO.net now?
>
>
>
>
>>Not exactly.
>>
>>ADO is COM, usable from, for instance, VB or other high-ish level languages that can use COM. Of
>>course, a low level language like C++ can also use ADO, assuming that lower level language can use
>>COM.
>>ADO in turn uses OLDEB, which is a lower level API.
>>
>>ADO.NET is indeed managed code (framework). Which you can use from any language that supports
>>managed code.