ADOX vs ADO.NET

  • Thread starter Thread starter Mitchell Vincent
  • Start date Start date
M

Mitchell Vincent

I'm brand new to .NET (and Visual Studio) so forgive me for asking some
simple questions..

What exactly is the difference between ADOX (ADO Extensions?) and ADO.NET ?

If I am starting from scratch is there any reason I should fool with
anything but ADO.NET?
 
Hi Mitch,

ADOX is used primarily for schema information in vb. ADO .Net is the object
model for access to the back end data source, and essentially replaces both
ado and adox. I find that when I need schema type information, I get it
inside sql itself, using the information_schema extensions available through
t-sql. So, at least for my purposes (and I access data always), no, ADOX is
not necessary in the net framework; ado .net is all I ever use.

HTH,

Bernie Yaeger
 
Mitchell.

The only thing I have seen till now where it is needed to use AdoDb is to
create a new Access database. As well the pesimistic concurrency is hard to
do in ADONET, when that is needed I do not know what will be my choise.

Just my thought,

Cor
 
Back
Top