ADO.NET - Aide mémoire - 4/4 : Tutoriel

Le présent article fait parti d'une suite logique de 4 articles: "ADO.NET - Aide mémoire - 1/4 : Execution, Parametres, StoredProc, DataReader",  "ADO.NET - Aide mémoire - 2/4 : DataSet", "ADO.NET - Aide mémoire - 2/4 : DataView" et "ADO.NET - Aide mémoire - 4/4 : Tutoriel"

eTutorial.org publie un Tuto Ado.Net plus que largement complet, le genre de référence que l'on place dans les perles du Net. Ce tutoriel prend sa source dans les excellents ouvrages de O'Reilly. Il faudra cependant composer avec l'affichage des publicités.

Admirez donc la magnifique table des matières que j'ai repris ci-dessous.
Si vous vous posez une question, tentez d'abord de trouver une réponse dans le tutoriel de eTutorial.

Preface
Audience
Contents of This Book
What's on the CD-ROM
Conventions Used in This Book
Comments and Questions
Acknowledgments

Part I: ADO.NET Tutorial

Chapter 1. Introduction

1.1 ADO.NET Data Providers
1.2 Connected and Disconnected Data

Chapter 2. .NET Data Providers

2.1 Data Providers
2.2 Selecting a Data Provider
2.3 Creating a Custom Data Provider

Chapter 3. Connections

3.1 Connection Object Overview
3.2 The Connection String
3.3 Opening and Closing Connections
3.4 Connection Pooling

Chapter 4. Commands

4.1 Command Object Overview
4.2 Creating and Executing a Command
4.3 Parameter Object Overview
4.4 Parameterized Commands
4.5 Commands with Stored Procedures
4.6 Commands and Data Definition Language (DDL)

Chapter 5. DataReaders

5.1 DataReader Object Overview
5.2 Performing a Query with a DataReader
5.3 Stored Procedures with the DataReader
5.4 DataReaders and Schema Information

Chapter 6. DataSets

6.1 Creating an Untyped DataSet
6.2 Working with Tables in the DataSet
6.3 Adding and Removing Relations
6.4 Adding Custom Information
6.5 Cloning the Schema
6.6 Copying the DataSet
6.7 Merging Two DataSets
6.8 Removing All Data
6.9 Resetting the DataSet
6.10 Committing and Discarding Changes

Chapter 7. DataTables

7.1 Creating a DataTable
7.2 Working with Columns
7.3 Constraints
7.4 Primary Key
7.5 Rows
7.6 Loading Data
7.7 Committing and Discarding Changes
7.8 Cloning the Schema of the Table
7.9 Copying the Table
7.10 Selecting a Subset of Rows
7.11 Performing Aggregate Calculations
7.12 Removing All Data
7.13 Resetting the Table
7.14 Identifying Errors in the Table
7.15 DataTable Events

Chapter 8. DataColumns

8.1 Creating DataColumns
8.2 Creating AutoIncrement Columns
8.3 Creating Expression Columns
8.4 Handling Null Values
8.5 Mapping .NET Data Provider Types to .NET Framework Types

Chapter 9. DataRows

9.1 Creating a DataRow
9.2 Updating Rows
9.3 Deleting Rows
9.4 Using Row State Information
9.5 Using Row Version Information
9.6 Accepting or Rejecting Changes to Rows
9.7 Navigating Parent and Child Rows
9.8 Using Row Error Information

Chapter 10. Constraints

10.1 Constraint Object Overview
10.2 The UniqueConstraint
10.3 The ForeignKeyConstraint

Chapter 11. DataRelations
11.1 DataRelation Object Overview
11.2 Navigating Relational Data

Chapter 12. DataViews and Data Binding

12.1 The DataView and DataViewManager
12.2 Sorting and Filtering
12.3 Accessing Data Through a DataView
12.4 Windows Data Binding
12.5 ASP.NET Data Binding

Chapter 13. Strongly Typed DataSets
13.1 Creating a Strongly Typed DataSet
13.2 Adding a Row
13.3 Editing a Row
13.4 Finding a Row
13.5 Null Data
13.6 Navigating Hierarchical Data
13.7 Annotations

Chapter 14. DataAdapters

14.1 Creating DataAdapter Object
14.2 Retrieving Data from the Data Source
14.3 Retrieving Schema Information from the Data Source
14.4 Updating the Data Source
14.5 Mapping Tables and Columns
14.6 AcceptChangesDuringFill
14.7 ContinueUpdateOnError
14.8 DataAdapter Events

Chapter 15. Updating the Data Source

15.1 SqlCommandBuilder Class Overview
15.2 Updating a Data Source Using Command Builder
15.3 Updating a Data Source Using Custom Logic
15.4 Refreshing Data After Updating
15.5 Retrieving Updated Values from the Data Source
15.6 Updating Data in Related Tables
15.7 Handling Concurrency Issues
15.8 Optimization

Chapter 16. Transactions

16.1 Manual Transactions
16.2 Isolation Levels
16.3 Savepoints
16.4 Nested Transactions
16.5 Transactions Using a DataAdapter
16.6 Automatic Transactions

Chapter 17. XML and the DataSet

17.1 DataSet XML Methods
17.2 Shaping DataSet XML
17.3 Other .NET XML Classes
17.4 XmlDataDocument Object Overview
17.5 Using the Data Objects to Edit XML
17.6 SQL Server 2000 XML

Part II: ADO.NET Core Classes

Chapter 18. The Connection Class
18.1 Comments/Troubleshooting
18.2 Properties Reference
18.3 Methods Reference
18.4 Events Reference

Chapter 19. The Command Class

19.1 Comments/Troubleshooting
19.2 Properties Reference
19.3 Collections Reference
19.4 Methods Reference

Chapter 20. The Parameter Class

20.1 Comments/Troubleshooting
20.2 Properties Reference

Chapter 21. The DataReader Class

21.1 Comments/Troubleshooting
21.2 Properties Reference
21.3 Methods Reference

Chapter 22. The DataSet Class

22.1 Comments/Troubleshooting
22.2 Properties Reference
22.3 Collections Reference
22.4 Methods Reference
22.5 Events Reference
 
Chapter 23. The DataTable Class

23.1 Comments/Troubleshooting
23.2 Properties Reference
23.3 Collections Reference
23.4 Methods Reference
23.5 Events Reference

Chapter 24. The DataColumn Class

24.1 Comments/Troubleshooting
24.2 Properties Reference
24.3 Collections Reference

Chapter 25. The DataRow Class

25.1 Comments/Troubleshooting
25.2 Properties Reference
25.3 Collections Reference
25.4 Methods Reference

Chapter 26. The Constraint Class

26.1 Comments/Troubleshooting
26.2 Properties Reference
26.3 Collections Reference

Chapter 27. The DataRelation Class

27.1 Comments/Troubleshooting
27.2 Properties Reference
27.3 Collections Reference

Chapter 28. The DataView Class

28.1 Comments/Troubleshooting
28.2 Properties Reference
28.3 Methods Reference
28.4 Events Reference

Chapter 29. The DataAdapter Class

29.1 Comments/Troubleshooting
29.2 Properties Reference
29.3 Collections Reference
29.4 Methods Reference
29.5 Events Reference

Chapter 30. The CommandBuilder Class

30.1 Comments/Troubleshooting
30.2 Properties Reference
30.3 Methods Reference

Chapter 31. The Transaction Class

31.1 Comments/Troubleshooting
31.2 Properties Reference
31.3 Methods Reference

Part III: API Quick Reference

Chapter 32. How to Use This Quick Reference

32.1 Finding a Quick-Reference Entry
32.2 Reading a Quick-Reference Entry

Chapter 33. Converting from C# to VB Syntax

33.1 General Considerations
33.2 Classes
33.3 Structures
33.4 Interfaces
33.5 Class, Structure, and Interface Members
33.6 Delegates
33.7 Enumerations

Chapter 34. The System.Data Namespace

Chapter 35. The System.Data.Common Namespace

Chapter 36. The System.Data.SqlClient Namespace

Chapter 37. The System.Data.OleDb Namespace

Chapter 38. The System.Data.SqlTypes Namespace

Part IV: Appendixes

Appendix A. ADO.NET Providers

A.1 The SQL Server Provider
A.2 The OLE DB Provider
A.3 The ODBC .NET Provider
A.4 The Oracle .NET Provider
A.5 The ODP.NET Provider

Appendix B. ADO.NET XML Extensions

B.1 codegen Namespace
B.2 msdata Namespace
B.3 diffgr Namespace

Appendix C. Microsoft Data Engine (MSDE)

C.1 Installing MSDE
C.2 MSDE Essentials
C.3 Adding the Northwind Data
C.4 Migrating MSDE to SQL Server

Type, Method, Property, and Field Index