1 / 7

ADO.NET Architecture

ADO.NET Architecture. MIS3502: Application Integration and Evaluation Paul Weinberg weinberg@temple.edu Adapted from material by Arnold Kurtz, David Schuff, and Paul Weinberg. The Database Server. Made up of Database Management System (DBMS) SQL APIs Database-level Security

grady
Download Presentation

ADO.NET Architecture

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ADO.NET Architecture MIS3502: Application Integration and Evaluation Paul Weinberg weinberg@temple.eduAdapted from material by Arnold Kurtz, David Schuff, and Paul Weinberg

  2. The Database Server • Made up of • Database Management System (DBMS) • SQL APIs • Database-level Security • Network Operating System (NOS) • Network Protocols • OS-level Security Database Server Has: Oracle 10Oracle’s APIWindows Server 2003TCP/IP Client/Application Server Has: Windows XPOracle DriverTCP/IP

  3. When things get messy… Database Server A: Oracle 10Oracle’s APIWindows Server 2000TCP/IP Client/Application Server Has: Database Server B: Windows XPOracle DriverMSSQL DriverDB2 DriverTCP/IP MSSQL 2005MSSQL APIWindows Server 2003TCP/IP Database Server C: The node communicating with the database servers have to have a driver for each type of server (a lot of management). IBM DB2 9DB2 APISolaris (Sun)TCP/IP

  4. One solution: Microsoft Data Access Components (MDAC) • Defines a standard set of routines with which an application can access data in a data source (from Windows online help) • Several components • ODBC – Open Database Connectivity • OLEDB – Object Linking and Embedding for Databases • ADO (.NET) – ActiveX Data Objects for .NET • We’ll look at ODBC/OLEDB • The server has a single API, and the clients know how to “talk” that API • Works through the Operating System

  5. How it looks with OleDB… Database Server A: Oracle 10OleDb APIWindows 2000TCP/IP Client/Application Server Has: Database Server B: Windows XPMS OleDB driverOracle DSNMSSQL DSNDB2 DSNTCP/IP MSSQL 2005 OleDb APIWindows 2000TCP/IP Database Server C: Instead of three drivers on the client, there is a single driver with multiple data sources defined. IBM DB2 9 OleDb APISolaris (Sun)TCP/IP

  6. Basic ADO.NET objects(Microsoft Access example) DataSet .NET data provider • The adapter is the interface between the application and .NET • The command object contains the SQL statement • The connection object manages the direct interaction with the database server Data table Data adapter Command The GUI is populated with data from the DataSet Database server Connection Database topmovies.mdb “Disconnected data model” The connection is only established when data is retrieved or sent to the database server via the Microsoft “Jet Engine” From Murach, M. and Boehm, A. “ASP.NET 2.0 Web Programming with C# 2005,” 2006, page 363.

  7. Closer look at the Dataset • The data table object consists of columns, rows, and constraints. • A column object represents the metadata for a field in the table. • A row object represents a record (set of column data). • A constraint object maintains data integrity through primary key rules and referential integrity. • A relation object contains information about the relationships between the tables. Dataset Data table Data relation Data column Data row Constraint From Murach, M. “C# 2005,” 2006, page 519.

More Related