To search, Click below search items. |
| All Published Papers Search Service |
|
|
|
Title |
ADO and ADO.NET Object Model Comparisons: A Relational Perspective |
|
Author |
Alfred J. Lendvai, Hao Shi |
| Citation |
Vol. 7 No. 1 pp. 330-337 |
|
Abstract |
Microsoft has, and still is, a significant contributor toward the development and innovation of software technology. An important aspect to any software technology is the creation, storage, processing and transfer of data. This paper focuses on two Microsoft data-access technologies, ADO and ADO.NET, the later being the more recent technology. ADO is an acronym for ActiveX Data Objects and though the literal ‘ADO’ is used in both, ADO.NET is a part of the new .NET platform, a different architecture to the one in which ADO was designed. ADO and ADO.NET are part of two different Microsoft technology infrastructure strategies. Although .NET framework has been released by Microsoft for more than five years, migrating from ADO to ADO.NET was relative slow for the existing IT projects due to concerns associated with .NET reliability and robustness. Many IT companies started to adopt .NET as their future platform until the release of .NET framework 3.0 in November 2006. This paper aims to shed some insights for Microsoft web developers to understand the two technologies in depth. An overview of ADO and ADO.NET from a relational perspective is presented, with particular emphasis on the ADO Recordset and the ADO.NET Dataset objects. A comparative analysis is performed providing an assessment of strengths and limitations of each technology. Conclusions drawn show that ADO.NET presents some significant advantages over its predecessor such as a superior disconnected model with greater control over the update process, improved management for multi-table processing, as well as improved scalability and object model extensibility. |
|
Keywords |
ADO, ADO .NET, Recordset, DataSet, relational database, scalability, extensibility |
|
URL |
