Sams Teach Yourself ADO.NET in 21 Days

by Fox, Dan

• ISBN13: 9780672323867
• ISBN10: 0672323869
• Edition: 1st
• Format: Paperback
• Copyright: 2002-06-12
• Publisher: Sams Publishing

Summary

ADO.NET refers to a set of classes that ship with Visual Studio .NET that allow developers to access data typically stored in relational databases. The purpose of this book is to explain the important features of ADO.NET to corporate developers who use VS .NET. Dan Fox also provides architectural guidance and Best Practices for using ADO.NET in corporate applications. Reference Tables sho how members of ADO.NET classes fit into the bigger picture by denoting why or where the method or property is used. This book is filled with code snippets and code listings in both VB .NET and VC# .NET, sidebars, and mini Case Studies that briefly explore peripheral issues, tips, cautions, and additional resources.

Author Biography

Dan Fox is a Technical Director for Quilogy in Overland Park, Kansas. Quilogy (www.quilogy.com) is a leading Microsoft Gold Certified Partner and Solution Provider.

Dan is a Microsoft Certified Solutions Developer, Systems Engineer, and Trainer who has been a consultant, instructor, and managing consultant on a variety of projects. In his role as a Technical Director, Dan provides technical guidance to Quilogy's consultants and customers.

Before joining Quilogy in 1995, Dan worked for Chevron in Houston, Texas, and the National Association of Insurance Commissioners in Kansas City, Missouri. Dan got his B.S. in computer science from Iowa State University in 1991. Dan has been a columnist for .NET Magazine and a frequent contributor to the Visual Basic ProgrammerÕs Journal and Visual Studio Magazine and has written numerous articles for SQL Server Magazine, Advisor journals, MSDN Magazine, and InformIT.com. He authored the books Building Distributed Applications with Visual Basic .NET and Pure Visual Basic from Sams and coauthored a book on the Visual Basic 6 Distributed Exam (70-175) for Certification Insider Press. He has spoken at TechEd and several Developer Days conferences and Microsoft events. Dan, with his ever-patient wife, Beth, and two young daughters, Laura and Anna, lives in Shawnee, Kansas, where as another spring arrives hope is renewed for a Cubs victory in the Fall Classic.

Table of Contents

Introduction.

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. Answers for Day 2

Day 3. Working with DataSets.

Understanding the ADO.NET DataSet. Populating a DataSet. Manipulating Multiple DataSets. Using a DataView. Summary. Workshop. Answers for Day 3

Day 4. DataSet Internals.

Data Table Structure. Constraints. Extended Properties. Summary. Workshop. Answers for Day 4

Day 5. Changing Data.

Making Modifications. Handling Changes. Summary. Workshop. Answers for Day 5

Day 6. Building Strongly Typed DataSet Classes.

Strongly Typed DataSet Classes Defined. DataSet Serialization. Summary. Workshop. Answers for Day 6

Day 7. XML and the DataSet.

Writing Data as XML. Creating the XSD Schema. Using a DataSet as XML. Summary. Workshop. Answers for Day 7.

Week 1. In Review.

WEEK 2. AT A GLANCE.

Day 8. Understanding .NET Data Providers.

Provider Architecture. Provider Functionality. Summary. Workshop. Answers for Day 8.

Day 9. Using Connections and Transactions.

Opening Connections and Handling Events. Specifying Connection Strings. Storing Connection Strings. Pooling Connections. Using Transactions. Summary. Workshop. Answers for Day 9.

Day 10. Using Commands.

Using Command Objects. Handling Parameters. Summary. Workshop. Answers for Day 10.

Day 11. Using Data Readers.

Data Reader Characteristics. Traversing a Data Reader. Advanced Features. Summary. Workshop. Answers for Day 11.

Day 12. Using Data Adapters.

Retrieving Data. Updating a Data Store. Summary. Workshop. Answers for Day 12.

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. Answers for Day 14.

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. Answers for Day 16.

Day 17. ADO.NET in the Data Services Tier.

Using an Abstract Base Class. Designing Data Access Classes. Summary. Workshop. Answers for Day 17.

Day 18. Building a Data Factory.

Creating a Data Factory. Summary. Workshop. Answers for Day 18.

Day 19. ADO.NET and XML Web Services.

Exposing Data Through a Web Service. Consuming Data in a Web Service. Summary. Workshop. Answers for Day 19.

Day 20. Performance and Interoperation.

Performance and Scalability Optimizations. Interoperating with ADO. Summary. Workshop. Answers for Day 20.

Day 21. Futures and Wrap Up.

Programming SQL Server .NET. Using ObjectSpaces. Summary and Final Thoughts. Workshop.

Week 3. In Review.
Index.