ADO.NET Application Development Technology


  ADO.NET Application.rtf (Size: 3.71 KB / Downloads: 0)

The rapid development of web applications makes software development companies review the existing methods of working with data sources and adapt them to the web application specifications. The unpredicted growth of the number of clients makes web developers move from client-server to three-tier architecture, which sometimes brings out problems. Databases are unable to support the unlimited number of active connections limiting the availability of the site and causing losses. The ADO.NET (ActiveX Data Objects) technology can solve these problems and at the same time keep convenience and simplicity of programming.

Advantages and innovations in ADO.NET technology

Using the disconnected model for accessing the data. ADO.NET application development technology offers an alternative to a traditional data access model. Normally, client-server applications use the technology of access to the data source where the connection with the base is maintained all the time. However, after the wide spread of the Internet based applications some vulnerabilities of this approach have been discovered. The experience of web developers has shown that the applications with the constant connection with the data source are difficult in scaling. All these problems are produced by the constant connection with database and are solved in ADO.NET. ADO.NET technology makes use of another data access model. ADO.NET access model establishes the connection only for some limited time when it’s necessary to take some actions with the database. Thus, ADO.NET allows sidestepping these limitations of web application development process.
Data string in the DataSet objects. In general, DataSet is a simplified relational database and can perform the most typical for these bases operations. Owing to ADO.NET application development technology, in contrast to Recordset, we can store several tables in one DataSet as well as the relations between them, perform the operations of selecting, deleting and updating the data. ADO.NET gives an opportunity any minute to get the latest information from the database using the call function FillDataSet. Thus, ADO.NET application development technology makes DataSet extremely convenient for most web applications. ADO.NET application development technology allows us to extract the data from the base and somehow handle it whenever it is necessary.