.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> ADO.Net >> Post New QuestionBookmark and Share Subscribe to Forum

Ado.net

Posted By: softraj     Posted Date: March 18, 2009    Points:2   Category :ADO.Net
What's the diff b/w connectioin oriented database connectivity and connectionless database connectivity?

Responses
Author: Kumar             
Posted Date: March 19, 2009     Points: 5   

Hi softraj,

ADO is connection Oriented whereas ADO.NET is Connectionless.
ADO has current record pointer. Where ADO.NET do not have
dataset is a connectionless service but data reader is a
connection oriented service..

Connectionless means that it's not necessary to get connected to the database all the time when the application is running . It can fetch data offline or it will make a connection automatically when data is to be fetched from the database and the connection will be closed

Thanks and regards,
Kumar

Author: Syed Shakeer Hussain             
Posted Date: April 10, 2009     Points: 5   

Hi

DataSet is a connectionless Architecture
DataProvider is a connection oriented Architecture.

when data is retreiving from a database using DataReader the connection should be always connected and connection opend with a DataBase.

but DataSet dose not required connection be opend ..

Author: Syed Shakeer Hussain             
Posted Date: April 10, 2009     Points: 5   

Hi

DataSet is a connectionless Architecture
DataProvider is a connection oriented Architecture.

when data is retreiving from a database using DataReader the connection should be always connected and connection opend with a DataBase.

but DataSet dose not required connection be opend ..

Author: Syed Shakeer Hussain             
Posted Date: April 10, 2009     Points: 5   

Hi

DataSet is a connectionless Architecture
DataProvider is a connection oriented Architecture.

when data is retreiving from a database using DataReader the connection should be always connected and connection opend with a DataBase.

but DataSet dose not required connection be opend ..

Author: Abhisek Panda             
Posted Date: December 13, 2009     Points: 5   

In the connected approach, the client had to be connected with the server
and remain connected till the whole procedure or transaction was completed. Time resources and bandwidth became major constraints on such architecture.

To solve this problem the latter version of ADO used RecordSet. All the contents from the data source were copied into RecordSet. This allows clients to get disconnected from the server, work on the RecordSet and copy the changes back to the data source again.

For more details please read my article on ADO.NET at the following link,

http://www.dotnetspark.com/kb/1006-adonet.aspx



Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend