Different classes of ADO.NET

Question

Hi What are different classes of connected and disconnected architecture in ADO.NET? Thanks.

Jignesh Trivedi · Answer

hi Connected classes ProviderFactory Class Connection Class ConnectionStringBuilder Class DataAdapter Command Class Parameter Class DataReader Class Transaction Class disConnected classes DataSet Class DataTable Class DataColumn Class DataRow Class Constraints Class DataRelation Class DataView Class hope this help.

A K · Answer

Thanks to all.

Hemant Kumar · Answer

DataReader is connected architecture since it keeps conneection open untill all records are fetched DataSet is disconnected architecture gets all records at once and closes connection and are available even after connection is closed http://www.sitepoint.com/article/dataset-datareader/ http://forums.asp.net/t/1410294.aspx