does ado.net have a liveconnection?

[adshocker]

i know that datasets, datatables in VB.NET 2003 up dont use live connections but i was wondering if ado.net has a live connection feature like the ADO in VB6?

thanks!

 

[Bharathi]

Reply to ADO.Net live Connection

Hi,

ADO.net is what you will b eusing in most of your .Net applications, because
of its disconnected architecture. However, you should keep in mind that ADO.NET is firmly targeted at n-tier Web applications, or applications that are distributed over a number of different servers. So if you are building n-tier or Client-server solutions fo rthe indows platform only, you are better off sticking with ADO for the moment, but this will probably change with future versions of ADO.NET.

Database programming using Visual Basic 2005

 

[adshocker]

ok... i see... the reason i'm asking is because i'm having a hardtime doing a process here in ado.net compared to ado... probably because i know few about ado.net....

i posted a new thread for this one...
http://www.vbdotnetforums.com/showthread.php?p=62784#post62784

 

[cjard]

i know that datasets, datatables in VB.NET 2003 up dont use live connections but i was wondering if ado.net has a live connection feature like the ADO in VB6?

thanks!

Yes, it does - the dataset generator writes code that opens and closes connections automatically, but you can write code that opens it and leaves it open. This approach is strongly discouraged