ADO.NET Programmer's Reference

ADO.NET is Microsoft's latest data access technology, and, as an integral component of the .NET framework, is far more than simply an upgrade of an existing technology. ADO.NET is a large set of .NET classes that enable us to interact with data sources, manipulate data, and communicate with other applications and Web Services in entirely new ways.

This book provides a wealth of information about the ADO.NET. We describe the features and how to use them, as well as providing advice and explanation that will enable you to use ADO.NET effectively. The code examples are concise, and demonstrate how to use a specific techniques rather than how to build entire applications.

This book covers:

An overview of ADO.NET, including differences to ADO and its new class structure

How to access and query databases using ADO.NET

The DataSet, DataReader and DataAdapter objects

How to implement transactions in ADO.NET

XML support

Working with database permissions

Incorporating classic ADO components in .NET applications

Real-world programming tasks using the SQL Client, OLEDB and ODBC providers

Extensive reference sections

Adil Rehan works as an independent consultant for a Fortune 500 company. He has been involved in several books in different roles. He has been actively involved in design and implementation of enterprise Internet enabled solutions for different clients. He can be reached at adilrehan@yahoo.com.

Dushan Bilbija works as a consultant with clients in areas from academia to software development to wireless communications. He specializes in Visual Basic, Enterprise Applications, Application Integration, Database Development and System Architecture. He can be reached at dbilbija@pantheoncorp.com.

Fabio Claudio Ferracchiati is a software developer and technical writer.

Jan D. Narkiewicz is Chief Technical Officer at Software Pronto, Inc (jann@softwarepronto.com). In his spare time Jan is Academic Coordinator for the Windows curriculum at U.C. Berkeley Extension, teaches at U.C. Santa Cruz Extension and writes for ASP Today.

Jeffrey Hasan is a technical architect specializing in Microsoft technology at LiveMarket, Inc. He has extensive experience developing N-Tier applications. He has written numerous articles on application development, and is a contributing author to several books by Wrox Press. Email Jeff at: JHasan85@hotmail.com.

John McTanish has written many control systems and various other application and drivers, mostly for PC hardware. John currently works as a team leader developing public safety software for computer aided dispatch systems used by Police, Fire and Ambulance vehicles.

Jon Reid is the Chief Technology Officer for Micro Data Base Systems, Inc.His primary current activity is developing database tools for the Microsoft.NET environment.

Matt Milner works as a Technical Architect for BORN in Minneapolis where he designs and builds Microsoft solutions for clients in a variety of industries. Matt's primary focus has been using Windows DNA architecture and he is excited about the move to .Net and all the powerful new features.

Naveen Kohli is an independent software developer. He's been developing ranging from Chemical Reactor Optimisation to N-tier web applications. He has a vast experience in writing middle tier components for extracting data from data sources like SQL Server, Oracle, Exchange Server and Access database.

Paul Dickinsons most recent resting place involves developing information management systems for laboratories.