Sams Teach Yourself ADO.NET in 21 Days |
By Dan Fox |
| |
Publisher | : Sams Publishing |
Pub Date | : June 12, 2002 |
ISBN | : 0-67232-386-9 |
Pages | : 656 |
Slots | : 1 | | | 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 DataSet s |
| | | Understanding the ADO.NET DataSet |
| | | Populating a DataSet |
| | | Manipulating Multiple DataSet s |
| | | 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 |