Net classes adonet overview looking back odbc open

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: base management systems (DBMS) W idely accepted API Uses SQL as data access language OLE DB Broad access to data, relational and other Built on COM Not restricted to SQL for retrieving data Can use ODBC drivers Low-level (C++) interface ADO (ActiveX Data Objects) Simple component-based, object-oriented interface Provides a programming model to OLE DB accessible outside of C++ 13 5/29/2013 5/29/2013 ADO.NET Overview Looking Back Your Application ADO OLE DB ODBC OLE DB Provider OLE DB Provider Text File Mainframe Database Simple Provider Native Provider ODBC Driver Database ODBC Provider ADO.NET Overview Looking Back ADO was designed as a connected, tightly coupled model Appropriate for client/server architectures Primarily relational (not hierarchical like XML) Object design is not well factored Too many ways to do the same thing Objects try to do too much Not originally designed for a distributed, n-tier environment 14 5/29/2013 5/29/2013 ADO.NET Overview What Is ADO.NET? ADO .NET is a collection of classes, interfaces, structures, and enumerated types that manage data access from relational data stores within the .NET Framework These collections are organized into namespaces: System.Data, System.Data.OleDb, System.Data.SqlClient, etc. ADO .NET is an evolution from ADO. Does not share the same object model, but shares many of the same paradigms and functionality! ADO.NET Overview ADO.NET Goals Well-factored design Highly scaleable through a robust disconnected model Rich XML support (hierarchical as well as relational) Data access over HTTP Maintain familiar ADO programming model Keep ADO available via .NET COM interoperability 15 5/29/2013 5/29/2013 ADO.NET Overview Managed Providers Merges ADO and OLEDB into one layer Each provider contains a set of classes that implement common interfaces Initial managed provider implementations: ADO Managed Provider: provides access to any OLE DB data source SQL Server Managed Provider: provides optimal performance when using SQL Server Exchange Managed Provider: retrieve and update data in Microsoft Exchange ADO.NET Overview Managed Providers Your Application ADO.NET Managed Provider OLE DB Provider SQL Server Database SQL Managed Provider Database ADO...
View Full Document

{[ snackBarMessage ]}

Ask a homework question - tutors are online