Summary

The chapter presents a conceptual and architectural review of ADO.NET concepts. It familiarizes you with .NET data providers and how they complement datasets. In particular, this presentation dwells on the OLE DB .NET Data Provider, which is the one to use with Access databases. Beyond an architectural and conceptual overview, the chapter demonstrates programming techniques for each of the four core ADO.NET classes: OleDbConnection , OleDbCommand , OleDbDataReader , and OleDbDataAdapter . The examination of datasets exposes you to the DataSet object model and highlights how to programmatically create and use relationships between DataTable objects.