Ado.net disconnected architecture

Posted by Gayathri under Interview Questions on 3/29/2012 | Points: 10 | Views : 5522 | Status : [Member] | Replies : 6
Hello All,

This question may seem to very basic. still please help on the clarification.

We all know Ado.net is disconnected architecture -
Ado - connected architecture.

Explain how..? In ado.net we open up a connection and close it immediately when the intended operation is over.
I hope we do the same thing with ado too. then in what way they are differentiated.




Responses

Posted by: Savariya on: 3/29/2012 [Member] Starter | Points: 25

Up
0
Down
Ado.net is called disconnected architecture because once you get data in your data set if you close the connection then also you can use that data and play with it like insert data updating data deleting data with out affecting actual database where in ado you must remain connection open while using the record set so that's why ado is called connected oriented architecture and ado.net is called disconnected architecture


Thanks
Chintan

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Yjreddy on: 6/13/2012 [Member] Starter | Points: 25

Up
0
Down
using data reader you can treat it as connected architecture..how long you use datareader it should maintain a connection..
datareader is typically is for display purpose..you can't perfoem any operations like inserting or deleting etc..
Dataset has been introduced to avoid such problems,we are getting the disconnected behaviour by data adapter,it well take the data from datasource and sends it to dataset..it can hold muliple tables..you can perform any operation like inserting,deleting ,updating..

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 6/13/2012 [Member] Silver | Points: 25

Up
0
Down
Please see this
http://www.coolinterview.com/interview/12574/

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 6/13/2012 [Member] Silver | Points: 25

Up
0
Down
Detailed explanation is here in MSDN
http://msdn.microsoft.com/en-us/library/904fck4k%28v=vs.90%29.aspx

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 6/23/2012 [Member] Silver | Points: 25

Up
0
Down
Mark as Answer if its helpful to you,that motivates...

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: CGN007 on: 6/23/2012 [Member] Silver | Points: 25

Up
0
Down
Mark as Answer if its helpful to you,that motivates...

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response