Ado.net disconnected architecture

Posted by Gayathri under Interview Questions on 3/29/2012 | Points: 10 | Views : 6847 | Status : [Member] | Replies : 2

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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.

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

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

Latest Posts