C H A P T E R 1 ADO.NET XML ADO.NET ADO.NET.NET Framework.NET XML ADO.NET.NET Microsoft Visual Studio 200 ADO.NET ADO.NET
2 ADO.NET 1 1.1 1.1 1.1 1.2 Internet 1.2
1.1 Internet 2 1.2 (Internet) Web 1. ADO.NET ADO.NET ADO (ActiveX Data Object) ADO.NET ADO.NET ADO.NET.NET ADO.NET (Universal Data Access UDA) 2.0 ADO.NET
2 ADO.NET 1 ADO.NET API ADO.NET Managed Provider ADO.NET API 1. ADO.NET Managed Provider Native API 1. ADO.NET UDA UDA API Web XML ADO.NET.NET Framework XML ADO.NET ADO.NET ADO.NET XML ADO.NET (Cache) N (N-Tier )
ADO.NET Visual Studio 200 IntelliSense ADO.NET ADO.NET (Cache) XML.NET Framework XML ADO.NET XML.NET XML 1. 2 1. ADO.NET System.Data System.Xml 1. System Data Common Odbc OleDb OracleClient Sql SqlClient SqlTypes SqlServerCe Xml Schema Serialization 1. ADO.NET 2.0 ADO.NET
2 ADO.NET 1 System.Data ADO.NET System.Data.Common.NET Framework (.NET Framework Data Provider) System.Data.Odbc.NET Framework Data Provider for ODBC ODBC API System.Data.OleDb.NET Framework Data Provider for OLE DB S y s t e m.d a t a.o r a c l e C l i e n t.n E T Framework Data Provider for Oracle Oracle System.Data.Sql SQL Server SqlDataSourceEnumerator SQL Server SqlNotificationRequest SQL Server 200 System.Data.SqlClient.NET Framework Data Provider for SQL Server SQL Server 7.0 System.Data.SqlTypes SQL Server 200 System.Data.SqlServerCe SQL Server Mobile SQL Server System.Xml XML System.Xml.Schema XML System.Xml.Serialization XML
ADO.NET 2.0 1. ADO.NET 1. ADO.NET DataSet.NET Data Provider 1. Data Provider DataSet 2 DataTable DataSet DataTable.NET Framework Data Provider for SQL Server.NET Framework Data Provider for OLE DB.NET Framework Data Provider for ODBC.NET Framework Data Provider for Oracle SQL Server 7.0 OLE DB API ODBC API Oracle ADO.NET 1. ADO.NET DataSet Data Provider DataSet Data Provider DataAdapter DataReader Connection Command 1.
2 ADO.NET 1 ProviderFactory DataSet Connection DataTable Transaction DataColumn ConnectionStringBuilder DataRow DataAdapter Constraint Command DataRelation Parameter DataView DataReader DataRowView 1. P r o v i d e r F a c t o r y A D O.N E T 2.0.N E T D a t a P ro v i d e r C o n n e c t i o n Command DataAdapter Connection Transaction Command ConnectionStringBuilder DataAdapter DataReader DataSet DataTable DataSet DataTable Command Parameter
ADO.NET 2.0 DataReader (Forward Only) DataSet DataTable DataSet (Table) DataSet DataSet Tables DataSet DataTable DataTableCollection DataColumn DataTable ( ) DataRow DataTable ( ) Constraint UniqueConstraint DataRelation DataTable DataTable 1. 2 ADO.NET DataView DataTable DataRowView DataView DataRowView 1..1 DataSet DataSet DataSet XML DataSet DataSet Data Provider 1.7 DataSet
2 1 ADO.NET DataSet DataRelationCollection ExtendedProperties DataTableCollection DataTable DataRowCollection DataRow DataColumnCollection DataColumn DataView ChildRelations ParentRelations Constraints ExtendedProperties PrimaryKey 1.7 DataSet 1..2.NET Framework Data Provider.NET Framework Data Provider ADO.NET XML Web Service.NET Framework Data Provider ADO.NET 1.0.NET Data Provider.NET ADO.NET 2.0 Provider Provider.NET Framework Data Provider Data Provider 10
.NET Framework Data Provider XML Web Service Data Provider.NET Framework Data Provider.NET Framework Data Provider for SQL Server.NET Framework Data Provider for OLE DB.NET Framework Data Provider for ODBC.NET Framework Data Provider for Oracle 1..2.1.NET Framework Data Provider for SQL Server SQL Server 7.0.NET Framework Data Provider for SQL Server Microsoft SQL Server.NET Framework Data Provider for SQL Server TDS (Tabular Data Stream) SQL Server API SQL Server Microsoft Data Engine (MSDE).NET Framework Data Provider for SQL Server MSDE SQL Server Engine Data Provider System.Data.SqlClient Provider Connection Command SqlConnection SqlCommand 1. 2 ADO.NET ADO.NET 2.0 1..2.2.NET Framework Data Provider for OLE DB OLE DB Oracle Access SQL Server. 7.0 AS/00 DB2 OLE DB Provider.NET Framework Data Provider for OLE 11
2 1 ADO.NET DB OLE DB COM OLE DB Data Provider 1.1.NET Framework Data Provider for OLE DB OLE DB Provider for ODBC (MSDASQL) ODBC.NET Framework Data Provider for ODBC Data Provider System.Data.OleDB Provider Connection Command OleDbConnection OleDbCommand OLE DB.NET Data Provider Microsoft OLE DB Provider for SQL Server Microsoft OLE DB Provider for Oracle OLE DB Provider for Microsoft Jet Provider SQLOLEDB MSDAORA Microsoft.Jet.OLEDB..0 SQL Server Oracle Jet Access 1.1.NET Framework Data Provider for OLE DB 1..2..NET Framework Data Provider for ODBC OLE DB Oracle Access MySQL SQL Server. 7.0.NET Framework Data Provider for ODBC ODBC API (Application Programming Interface) ODBC.NET Data Provider System.Data.Odbc.dll ODBC Data Provider System.Data.Odbc 12
Provider Connection Command OdbcConnection OdbcCommand Data Provider 1.2 NET Framework Data Provider for ODBC Microsoft SQL ODBC Driver Microsoft ODBC Driver for Oracle Microsoft Jet ODBC Driver SQL Server. Oracle Jet Access 1.2 ODBC Data Provider 1. 2 1..2..NET Framework Data Provider for Oracle.NET Framework Data Provider for Oracle Oracle Oracle Call Interface (OCI) Oracle Oracle Client 8.1.7 Oracle Client ( Oracle ) Oracle Oracle 8.1.7 OLE DB Data Provider System.Data.OracleClient Provider Connection Command OracleConnection OracleCommand ADO.NET ADO.NET 2.0 1..2. Provider Provider Provider SqlConnection OleDbConnection DBConnection SqlCommand OleDbConneciton Provider Provider 1
2 1 ADO.NET ADO.NET 2.0 Provider Connection Command Provider Data Provider 1.. Data Provider SQL Server 7.0.NET Framework Data Provider for SQL Server.NET Framework Data Provider for OLE DB.NET Framework Data Provider for ODBC Data Provider.NET Framework Data Provider for SQL Server SQL Server OLE DB ODBC.NET Framework Data Provider for OLE DB OLE DB Service component Oracle.NET Framework Data Provider for Oracle.NET Framework Data Provider for ODBC 1.8.NET Framework Data Provider for SQL Server SQL Server 7.0.NET Framework Data Provider for OLE DB OLE DB Service Component OLE DB Provider OLE DB.NET Framework Data Provider for Oracle Oracle ( 8.1.7 ).NET Framework Data Provider for ODBC ODBC Service Component ODBC Provider ODBC 1.8 Data Provider 1
ADO.NET 1...1.NET Data Provider ADO.NET.NET Framework Data Provider 1.9 ADO.NET IDbConnection.NET Framework Data Provider for SQL Server SqlConnection IDbConnection.NET Framework Data Provider for OLE DB IDbConnection OleDbConnection.NET Framework Data Provider Connection Command DataAdapter DataReader 1. 2 1.9.NET Framework Data Provider ADO.NET SqlConnection OleDbConnection C o n n e c t i o n.n E T F r a m e w o r k Data Provider for SQL Server SqlDataAdapter SqlDataReader SqlCommand SqlParameter.NET Framework Data Provider for OLE DB OleDbDataAdapter OleDbDataReader OleDbCommand OleDbParameter ADO.NET 2.0 1
2 ADO.NET 1 S q l OleDb Odbc Oracle Connection Command DataReader DataAdapter DataReader DataSet DataSet 1. Data Provider Transaction Command CommandBuilder D b D a t a A d a p t e r D b D a t a A d a p t e r SelectCommand SQL Command ConnectionStringBuilder Parameter Exception Error ClientPermission.NET Framework data provider 1. Data Provider 1
SqlBulkCopy SqlClientFactory SQL Server S q l C l i e n t SqlConnection SqlCommand 1. SqlClient 1. 2 1...2 ADO.NET 1.x (Data Provider) SQL Server SqlConnection OleDbConnection ADO.NET 2.0 ADO.NET 2.0 Provider Factories ProviderFactory Provider Enumeration 1.. D a t a R e a d e r Command Connection 1.10 ADO.NET ADO.NET 2.0 Step1 Connection Connection Open Step2 Command SQL 17
2 ADO.NET 1 DataReader Step DataReader Close DataReader Step Connection Close DataReader Command Connection 1.10 1.. DataSet DataTable DataAdapter Connection 1.11 Step1 Connection Step2 DataAdapter DataAdapter SelectCommand UpdateCommand InsertCommand DeleteCommand Command DataAdapter Command Connection Open 18
ADO.NET DataAdapter DataAdapter DataSet D a t a A d a p t e r DataAdapter Step D a t a A d a p t e r F i l l D a t a S e t DataTable Step Step D a t a S e t D a t a Ta b l e D a t a S e t DataTable DataSet DataTable 1. 2 DataAdapter Connection 1.11 DataSet DataTable Step1 Step2 DataAdapter Update Step Step ADO.NET 2.0 19
2 ADO.NET 1 1. ADO.NET ADO.NET.NET Framework Try..Catch..Finally.N E T F r a m e w o r k D a t a Provider.NET System.Exception.NET Framework Data Provider System.Exception.NET Framework Data Provider for SQL Server SqlException.NET Framework Data Provider for OLE DB OleDbException 1.12.N E T Framework Data Provider Exception SystemException ExternalException DBException SqlException OleDbException OdbcException OracleException 1.12 Exception 20
1.7 ADO.NET XML 1.7 ADO.NET XML ADO.NET XML XML DataSet DataTable XML XML DataSet DataTable XML DataSet DataTable XML XML XML XML (Stream ) Stream XML DOM XML DataSet XML DataSet (Typed DataSet) DataSet DataSet XML 2 ADO.NET XML ADO.NET 2.0 21
2 ADO.NET 1 1.8 ADO.NET OLE DB Microsoft SQL Server 200 ADO.NET Microsoft Excel ADO.NET (DataSet DataTable) ( ) DataSet DataTable ADO.NET XML XML XML ADO.NET XML 22