Course Hero Logo

Lab 11a Database Introduction.pdf - CT044-3-1-IOOP Lab 11a...

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 6 pages.

Asia Pacific Institute of Information TechnologyCT044-3-1-IOOPLab 11aDatabase IntroPage 1 of 6Database ApplicationsIntroduction to ADO.NETData processing has traditionally relied primarily on a connection-based, two-tier model. As dataprocessing increasingly uses multi-tier architectures, programmers are switching toadisconnected approach to provide better scalability for their applications.ADO.NET provides consistent access to data sources such as Microsoft SQL Server, as well asdata sources exposed through OLE DB and XML. Data-sharing consumer applications can useADO.NET to connect to these data sources and retrieve, manipulate, and update data.ADO.NET cleanly factors data access from data manipulation into discrete components that canbe used separately or in tandem. ADO.NET includes .NET Framework data providers forconnecting to a database, executing commands, and retrieving results. Those results are eitherprocessed directly, or placed in an ADO.NETDataSetobject in order to be exposed to the user inan ad-hoc manner, combined with data from multiple sources, or remote between tiers. TheADO.NETDataSetobject can also be used independently of a .NET Framework data provider tomanage data local to the application or sourced from XML.ADO.NET ArchitectureSource:(v=vs.71).aspxADO.NET contains the following components:Connectionobject provides connectivity to a data source. A data source may be adatabase, a text file, an object, a web service or a spreadsheet which contains data.
Asia Pacific Institute of Information TechnologyCT044-3-1-IOOPLab 11aDatabase IntroPage 2 of 6Commandobject enables access to database commands to return data, modify data, runstored procedures, and send or retrieve parameter information.DataReaderprovides a high-performance stream of data from the data source.

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 6 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Summer
Professor
N/A
Tags
Microsoft SQL Server, Asia Pacific Institute of Information Technology

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