My Blog

Architecture Of ADO.NET

ADO .NET Architecture

Description:
DataSource : DataSource was the initial name for Oracle Database, Microsoft SQL Server, XML file, etc.

Connection: Connection class can be set as “Open” or “Close”, with notes ”Open” was used for operation that directly access to Datasource.

DataReader: Data Reader was the best solution for “Forward Streaming“ , in another word, DataReader was the most appropriate to “SELECT”  Database Query Command, because it processed  faster  !

DataAdapter : DataAdapter has property “SELECT COMMAND“, “INSERT COMMAND“,”UPDATE COMMAND“, and “DELETE COMMAND“, these properties can be filled in by “Command” class and DataAdapter will definitely fill in DataSets With “fill()” method unless you did not specify the custome method.

DataSet : Equal to DataReader as temporary data storage, even though  Dataset Can be filled in by DataAdapter. DataSet uses XML to store dan send data between application and DataProvider, other than that DataSet was bunch of DataTable Object with it’s constraint and relation.

DataBound : ASP.NET component that support object binding will do “bound” to the data that’s stored on “DataSet”, “DataReader” and another object that store data collection.