DAT 200 Microsoft ADO NET for ADO Classic

DAT 200 Microsoft® ADO. NET for ADO Classic Developers: Introducing ADO. NET Jackie Goldstein Renaissance Computer Systems jackie@renaissance. co. il

Jackie Goldstein… General Manager of Renaissance Computer Systems Consulting, Training, & Development, with Microsoft Tools & Technologies Author of “Database Access with Visual Basic. Net” (ISBN 0 -67232 -3435, Addison-Wesley) MSDN Regional Director for Israel Founder and monthly host of IVBUG (Israel Visual Basic User Group) Speaker at local & international developer conferences: Microsoft Developer Days, Tech. Ed, VSLive!, VBITS, VB Dev. Con, SQL 2 The. Max Selected as SME (Subject Matter Expert) to help develop/review content for Dev. Days 2000 and Dev. Days 2001 with Microsoft team in Redmond

Session Topics ADO. NET Architecture ADO. NET Object Model ADO. NET and XML Summary and Questions

Session Topics ADO. NET Architecture ADO. NET Object Model ADO. NET and XML Summary and Questions

ADO. NET ADO Look and Feel… Direct OLE DB connectivity… Integrated with. NET Framework… Integrated with XML… "Designed for the Enterprise"…

The. NET Framework Applications Are Built Using the Framework System. Windows. Forms System. Web Services Web Forms ASP Application Services Controls Drawing Windows Application Services System Base Classes Data Oledb SQLClient XML IO Threading Security Service. Process Common Language Runtime Memory Mgmt Type System Lifetime

Data In The. NET Platform Controls, Designers, Code-gen, etc XSL/T, X-Path, Validation, etc Data. Set Sync Data. Adapter Data. Reader Command Connection . NET Data Provider Xml. Data. Document Xml. Reader Xml. Text- Xml. Node. Reader

Points to Note in ADO. NET vs. ADO Separation between connected data access model and disconnected programming model No Cursor. Type, Cursor. Location, or Lock. Type ADO Recordset functionality is split into smaller, specific objects, e. g. Data. Reader, Data. Table, Command ADO. NET allows manipulation of XML data, not just XML as I/O format

Comparison Between ADO and ADO. NET (1( Feature ADO. NET Memory-resident Data Representation Record. Set can contain one table Data. Set can contain one or more tables represented by Data. Table Object Relationship Between Require the JOIN query Multiple Tables Supports the Data. Relation object Data Visitation Uses a navigation paradigm for nonsequential access Scans Record. Set rows sequentially Disconnected Access Provided by Record. Set but typically supports connected access Communicates with standardized calls to the Data. Adapter

Comparison Between ADO and ADO. NET (2) Feature ADO. NET Sharing Disconnected Data Between Tiers or Components Uses COM marshalling to Transmits a Data. Set transmit disconnected with an XML file record set Transmitting Data Through Firewalls Problematic because firewall are typically configured to prevent system-level requests Supported, Data. Set object use XML, which can pass through firewalls Scalability Database locks and active database connections for long durations Disconnected access to database data without retaining database locks

Session Topics ADO. NET Architecture ADO. NET Object Model ADO. NET and XML Summary and Questions

. NET Data Providers Manage interaction to a data source Microsoft Implementations OLEDB. NET Data Provider SQLServer. NET Data Provider ODBC. NET Data Provider Oracle. NET Data Provider Main Objects: Connection, Command, Parameter Data. Reader, Data. Adapter Data Provider Data Store

demo Using. NET Data Providers Connection Object • Command Object • Data. Reader Object •

Data. Set Object Data. Set Data. Table Data. Column Data. Table Data. Row Relations XML Schema Constraints

Data. Adapter Object Data. Adapter Select. Command Database Insert. Command Update. Command Delete. Command Table. Mappings Data. Set

demo Using the Data. Adapter Simple Fill • Database Updates • Using the Data. Adapter Configuration Wizard •

Strongly Typed Data. Set Deal with Data. Sets, Tables, and Rows as Objects Columns and Relations as properties Class Generated At Design Time Inherits from Data. Set Schema coded into the class Benefits Compile time type checking Statement completion Concise, readable code

Session Topics ADO. NET Architecture ADO. NET Object Model ADO. NET and XML Summary and Questions

Unified Architecture Controls, Designers, Code-gen, etc XSL/T, X-Path, Validation, etc Data. Set Sync Data. Adapter Data. Reader Command Connection. NET Data Provider Xml. Data. Document Xml. Reader Xml. Text- Xml. Node. Reader

ADO. NET And XML (1( The Data. Set Loads/saves XML data into/out of Data. Set Schema can be loaded/saved as XSD Schema can be inferred from XML Data

ADO. NET And XML (2) Data is XML is Data Xml. Data. Document unifies XML and Data Simultaneously exposes data relationally or as XML Exposes a relational view over structured XML Plugs into entire stack of XML services Subclass of Xml. Document – it’s a DOM Retains fidelity of underlying document Plugs into entire stack of Data services Can obtain a Data. Set view of an Xml. Data. Doc Relational and XML views stay in sync

Scenarios Enabled Simultaneously expose data relationally or as XML Good for semi-structured data Multiple tools on same data Map interesting subset relationally using schema Use natural object model for each subset Both DOM and Data. Set can “grow up”

demo Accessing XML Data XML Navigation and Selection • XML Format in ADO. NET vs. ADO 2. X • Synchronization of Relational and XML Views of data •

Session Topics ADO. NET Architecture ADO. NET Object Model ADO. NET and XML Summary and Questions

Session Summary A natural evolution of ADO Designed with extensive XML support Closely integrated with the. NET Framework Provides fast and efficient mechanisms for connected data access and disconnected data manipulation Try it – You’ll Like it !!!

Community Resources http: //www. microsoft. com/communities/default. mspx Most Valuable Professional (MVP) http: //www. mvp. support. microsoft. com/ Newsgroups Converse online with Microsoft Newsgroups, including Worldwide http: //www. microsoft. com/communities/newsgroups/default. mspx User Groups Meet and learn with your peers http: //www. microsoft. com/communities/usergroups/default. mspx

Suggested Reading And Resources The tools you need to put technology to work! TITLE Microsoft® ADO. NET (Core Reference): 0 -7356 -1423 -7 Available Today Microsoft Press books are 20% off at the Tech. Ed Bookstore Also buy any TWO Microsoft Press books and get a FREE T-Shirt

Ask The Experts Get Your Questions Answered I will be in the Microsoft Ask The Experts area during the following hours: Wednesday Thursday 13: 00 – 14: 00

evaluations

Questions?

© 2003 Microsoft Corporation. All rights reserved. This presentation is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY.