Course Hero Logo

Introduction to ADO NET - ADO.NET Architecture Data...

Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e.g., in search results, to enrich docs, and more. This preview shows page 1 - 3 out of 7 pages.

1ADO.NET ArchitectureData processing has traditionally relied primarily on a connection-based, two-tier model. As dataprocessing increasingly uses multi-tier architectures, programmers are switching to adisconnected approach to provide better scalability for their applications.ADO.NETis a set of classes that comes with the Microsoft .NET framework to facilitate dataaccess from managed languages. ADO.NET has been in existence for a long time and it providesa comprehensive and complete set of libraries for data access. The strength of ADO.NET isfirstly that it lets applications access various types of data using the same methodology. If youknow how to use ADO.NET to access a SQL Server database then the same methodology can beused to access any other type of database (like Oracle or MS Access) by just using a different setof classes. Secondly, ADO.NET provides two models for data access: a connected model whereyou can keep the connection with the database and perform data access, and another way is to getall the data in ADO.NET objects that let us perform data access on disconnected objects.Note: Many developers and development houses are now using ORMs to perform data accessinstead of using ADO.NET. ORMs provide a lot of data access functionality out of the box andrelieves users from writing mundane data access code again and again. Still, I think that knowingand understanding ADO.NET is crucial as a .NET developer as it gives a better understanding ofthe data access methodologies. Also, there are many development houses that are still usingADO.NET.ADO.NET ComponentsThe two main components of ADO.NET 3.0 for accessing and manipulating data are the .NETFramework data providers and theDataSet..NET Framework Data ProvidersThe .NET Framework Data Providers are components that have been explicitly designed for datamanipulation and fast, forward-only, read-only access to data. The Connection object providesconnectivity to a data source. The Command object enables access to database commands toreturn data, modify data, run stored procedures, and send or retrieve parameter information. TheDataReader provides a high-performance stream of data from the data source. Finally, theDataAdapter provides the bridge between the DataSet object and the data source. TheDataAdapter uses Command objects to execute SQL commands at the data source to both loadthe DataSet with data and reconcile changes that were made to the data in the DataSet back to thedata source. For more information, see.NET Framework Data ProvidersandRetrieving andModifying Data in ADO.NET.The DataSet
2The ADO.NET DataSet is explicitly designed for data access independent of any data source. Asa result, it can be used with multiple and differing data sources, used with XML data, or used tomanage data local to the application. The DataSet contains a collection of one or moreDataTable

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 7 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
Tayek,R
Tags
NET Framework, Microsoft SQL Server, Stored procedure, DataReader

Newly uploaded documents

Show More

Newly uploaded documents

Show More

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture