ADO.NET in a Nutshell

Front Cover
"O'Reilly Media, Inc.", 2003 - Computers - 599 pages

Written by experts on the Microsoft® .NET programming platform, ADO.NET in a Nutshell delivers everything .NET programmers will need to get a jump-start on ADO.NET technology or to sharpen their skills even further. In the tradition of O'Reilly's In a Nutshell Series, ADO.NET in a Nutshell is the most complete and concise source of ADO.NET information available.ADO.NET is the suite of data access technologies in the .NET Framework that developers use to build applications services accessing relational data and XML. Connecting to databases is a fundamental part of most applications, whether they are web, Windows®, distributed, client/server, XML Web Services, or something entirely different. But ADO.NET is substantially different from Microsoft's previous data access technologies--including the previous version of ADO--so even experienced developers need to understand the basics of the new disconnected model before they start programming with it.Current with the .NET Framework 1.1, ADO.NET in a Nutshell offers one place to look when you need help with anything related to this essential technology, including a reference to the ADO.NET namespaces and object model. In addition to being a valuable reference, this book provides a concise foundation for programming with ADO.NET and covers a variety of issues that programmers face when developing web applications or Web Services that rely on database access. Using C#, this book presents real world, practical examples that will help you put ADO.NET to work immediately.Topics covered in the book include:

  • An Introduction to ADO.NET
  • Connections, Commands and DataReaders
  • Disconnected Data
  • Advanced DataSets
  • Transactions
  • DataViews and Data Binding
  • XML and the DataSet
Included with the book is a Visual Studio .NET add-in that integrates the entire reference directly into your help files. When combining ADO.NET in a Nutshell with other books from O'Reilly's .NET In a Nutshell series, you'll have a comprehensive, detailed and independent reference collection that will help you become more productive.
 

What people are saying - Write a review

We haven't found any reviews in the usual places.

Contents

Parti AD0 NETTutorial
3
Connections
13
Commands
28
DataReaders
46
DataSets
66
DataTables
75
DataColumns
86
DataRows
89
TheDataSetClass
279
The DataTable Class
304
The DataColumn Class
331
TheDataRowClass
341
The Constraint Class
358
The DataRelation Class
364
The DataView Class
370
The DataAdapter Class
381

Constraints
96
DataRelations
103
DataViews and Data Binding
115
Strongly Typed DataSets
149
DataAdapters
160
Updating the Data Source
173
Transactions
192
XMLandtheDataSet
203
AD0 NET Core Classes
235
The Command Class
248
The Parameter Class
261
The DataReader Class
268
The CommandBuilder Class
401
The Transaction Class
408
API Quick Reference
417
Converting from C to VB Syntax
423
The System Data Namespace
431
The System Data Common Namespace
488
The System Data SqICIient Namespace
500
The System Data OleDb Namespace
515
The System Data SqITypes Namespace
532
Appendixes
557
Index
587
Copyright

Other editions - View all

Common terms and phrases

About the author (2003)

Bill Hamilton is a software architect specializing in designing, developing and implementing distributed applications using .NET and J2EE technologies. Over the last ten years, he has provided consulting services in B2B, B2C, B2E, data integration, and portal initiatives for banking, retail, accounting, manufacturing, and financial services. An early technology adopter, he frequently evaluates, recommends, and helps his clients use new technologies effectively. Bill has designed and helped build several award winning software packages. Bill is the co-author of O'Reilly's ADO.NET in a Nutshell and author of ADO.NET Cookbook.

is President of ProseTech, a software documentation consultancy, and a project manager at VoiceIQ (http://www.voiceiq.com/), a provider of software for interactive voice-enabled applications and services. Matthew is a coauthor of the ASP.NET in a Nutshell (O'Reilly), and a contributor to the C# in a Nutshell (O'Reilly) API reference.

Bibliographic information