SKIP THE SHIPPING
Use code NOSHIP during checkout to save 40% on eligible eBooks, now through January 5. Shop now.
Register your product to gain access to bonus material or receive a coupon.
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.
ADO.NET and the .NET Framework v1.1
ADO.NET: More than a Matter of ABCs
Designing Framework Applications: Using Design Patterns with VS.NET Framework Applications
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.