---

Sams Teach Yourself ADO.NET in 21 Days

ISBN: 0672323869
EAN: 2147483647

Year: 2002
Pages: 158

Authors: Dan Fox

BUY ON AMAZON

• Table of Content
• Starting Page
• Copyright
• About the Author
• About the Technical Editors
• Acknowledgments
• We Want to Hear from You
• Introduction
• The Structure of This Book
• Conventions Used in This Book
• The Audience for and Purpose of This Book
• Week 1: At a Glance
• Day 1. ADO.NET in Perspective
• Microsoft Data Access Technologies
• ADO.NET Design Goals
• ADO.NET in .NET
• Summary
• Workshop
• Day 2. Getting Started
• ADO.NET in Visual Studio .NET
• ADO.NET in Code
• Summary
• Workshop
• Day 3. Working with DataSets
• Understanding the ADO.NET DataSet
• Populating a DataSet
• Manipulating Multiple DataSets
• Using a DataView
• Summary
• Workshop
• Day 4. DataSet Internals
• Data Table Structure
• Constraints
• Extended Properties
• Summary
• Workshop
• Day 5. Changing Data
• Making Modifications
• Handling Changes
• Summary
• Workshop
• Day 6. Building Strongly Typed DataSet Classes
• Strongly Typed DataSet Classes Defined
• DataSet Serialization
• Summary
• Workshop
• Day 7. XML and the DataSet
• Writing Data as XML
• Creating the XSD Schema
• Using a DataSet as XML
• Summary
• Workshop
• Week 1 In Review
• Week 2: At a Glance
• Day 8. Understanding .NET Data Providers
• Provider Architecture
• Provider Functionality
• Summary
• Workshop
• Day 9. Using Connections and Transactions
• Opening Connections and Handling Events
• Specifying Connection Strings
• Storing Connection Strings
• Pooling Connections
• Using Transactions
• Summary
• Workshop
• Day 10. Using Commands
• Using Command Objects
• Handling Parameters
• Summary
• Workshop
• Day 11. Using Data Readers
• Data Reader Characteristics
• Traversing a Data Reader
• Advanced Features
• Summary
• Workshop
• Day 12. Using Data Adapters
• Retrieving Data
• Updating a Data Store
• Summary
• Workshop
• Day 13. Working with SQL Server
• SqlClient Internals
• Database Design
• Alternative Data Access Techniques
• Summary
• Workshop
• Day 14. Working with Other Providers
• Accessing ODBC Data Sources
• Building a .NET Data Provider
• Summary
• Workshop
• Week 2 In Review
• Week 3: At a Glance
• Day 15. Using ADO.NET in a Multi-Tier Application
• The Multi-Tiered Architecture
• ADO.NET in Context
• Summary
• Workshop
• Day 16. ADO.NET in the Presentation Services Tier
• Windows Forms Applications
• Web Forms Applications
• Summary
• Workshop
• Day 17. ADO.NET in the Data Services Tier
• Using an Abstract Base Class
• Designing Data Access Classes
• Summary
• Workshop
• Day 18. Building a Data Factory
• Creating a Data Factory
• Summary
• Workshop
• Day 19. ADO.NET and XML Web Services
• Exposing Data Through a Web Service
• Consuming Data in a Web Service
• Summary
• Workshop
• Day 20. Performance and Interoperation
• Performance and Scalability Optimizations
• Interoperating with ADO
• Summary
• Workshop
• Day 21. Futures and Wrap Up
• Programming SQL Server .NET
• Using ObjectSpaces
• Summary and Final Thoughts
• Workshop
• Week 3 In Review
• Index
• A_Index
• B_Index
• C_Index
• D_Index
• E_Index
• F_Index
• G_Index
• H_Index
• I_Index
• J_Index
• K_Index
• L_Index
• M_Index
• N_Index
• O_Index
• P_Index
• Q_Index
• R_Index
• S_Index
• T_Index
• U_Index
• V_Index
• W_Index
• X_Index