Essential ADO.NET,9780201758665

Essential ADO.NET

by
ISBN13: 9780201758665
ISBN10: 0201758660
Format: Paperback
Pub. Date: 2002-01-01
Publisher(s): Addison-Wesley Professional
List Price: $49.99

Rent Book

Select for Price
Add to Cart
There was a problem. Please try again later.

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $45.86

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

Comprehensive guide for developers of data ware applications who want to transition to Microsoft's new .NET data access architecture. Presents a thorough explanation of ADO.NET, exploring in depth the capabilities of classes, interfaces, properties, and methods. Softcover.

Table of Contents

Foreword xv
Tim Ewald
Foreword xvii
Richard Grimes
Preface xix
Acknowledgments xxvii
Data: Models, Applications, and APIs
1(24)
Information, Data Modeling, and Databases
1(1)
Database and API Fundamentals
2(3)
The Relational Model
5(4)
Relational Design Rules
6(1)
Benefits of the Relational Model
7(1)
Relational Model Support in ADO.NET
8(1)
Hierarchies, Objects, and Hybrids
9(7)
Modern Nonrelational Data
11(1)
Multidimensional Data
12(1)
Nonrelational Data and ADO.NET
13(1)
XML and the Infoset
14(1)
XML, Databases, and Universal Data Representation
15(1)
Data-centric Application Models
16(3)
Evolution of Data Access APIs
19(5)
Where Are We?
24(1)
ADO.NET Basics
25(44)
Data Access and the .NET Architecture
25(1)
Two Patterns of Data Access
26(1)
Connected Mode
27(15)
OleDb and SqlClient Data Providers
35(1)
Writing Generic Data Access Code with ADO.NET Data Providers
36(5)
Cursors in the Data Provider Model
41(1)
Disconnected Mode and the DataSet
42(4)
The XML APIs in .NET
46(19)
Streaming XML
47(4)
XML Schemas
51(3)
The XmlDocument, XPath, and XPathNavigators
54(6)
Mixing XML and Data Providers
60(5)
Layout of the Managed Data Classes
65(2)
Where Are We?
67(2)
The Connected Model: Streaming Data Access
69(58)
.NET Data Providers and the Connected Model
69(1)
Connection Classes
70(3)
Connection Pooling
73(1)
Metadata Methods
74(3)
Commands
77(5)
Command Behaviors
81(1)
Using Parameters
82(10)
Command Preparation, Cancellation, Timeouts, and Cleanup
92(2)
Streaming Data through a DataReader
94(3)
Reading Column Values through IDataRecord
97(6)
Handling Large Data Columns
101(2)
Error Handling
103(4)
Using Transactions
107(17)
Distributed Transactions
111(4)
How Connection Pooling Works
115(6)
How Declarative Transactions Work
121(3)
Permission Classes
124(2)
Database Security
126(1)
Where Are We?
126(1)
The DataSet Class: Sets of Relational Data
127(50)
DataSets
127(2)
DataSet as an In-memory Database
128(1)
What Can You Do with a DataSet?
129(1)
The DataSet Object Model
129(45)
DataColumns, DataRows, and DataTables
131(3)
DataTable and Its Uses
134(2)
DataRows
136(3)
Keys, Relations, and Constraints
139(4)
Navigating through Relationships: Select and Find
143(3)
Adding, Retrieving, Changing, and Deleting Rows
146(4)
Combining Changes
150(2)
Merging DataSets
152(2)
DataRow States and Versions
154(5)
Rules and Relationships
159(2)
Error Handling
161(4)
Events
165(6)
DataSets and Nonrelational Types
171(3)
Defining an Information Schema
174(2)
Where Are We?
176(1)
DataAdapters: Synchronizing Databases and Datasets
177(48)
Optimistic Concurrency
177(2)
DataAdapter Classes
179(1)
Populating a DataSet from a Managed Provider
179(11)
Using Fill with Schema and Mapping Information
183(5)
Error Handling during DataAdapter.Fill
188(2)
How DataAdapter.Fill Works
190(5)
ADO Integration in OleDbDataAdapter
195(1)
Updating a Database through DataAdapter
196(16)
The CommandBuilder Class
199(7)
Coding Update Logic Directly
206(6)
How Update Works
212(2)
Controlling Updates
213(1)
The DataSet Event Model
214(4)
Refreshing DataSet Using Update and Merge
216(2)
Writing General Customized Commands
218(2)
The ADOX CommandBuilder
218(1)
Building a Batch Update Command
219(1)
DataSets and Nonrelational Data Types Revisited
220(1)
Should You Use DataSet or DataReader?
221(2)
Where Are We?
223(2)
Data Binding: ADO.NET and Graphical User Interfaces
225(48)
Windows Forms and Web Forms
225(1)
Patterns of Data Presentation
226(1)
Using Databound Controls
227(16)
Web Forms Data Binding Types
230(3)
Anatomy of Databound Control Types
233(8)
Binding to a DataReader
241(2)
Data Binding with DataSets
243(3)
DataViews and Common Transformations
246(8)
Table and Column Mappings
254(2)
Editable List Controls: DataList and DataGrid
256(9)
DataList
256(3)
DataGrid
259(6)
Nonrelational Data and DataViews
265(1)
Integrating Visual Studio
266(4)
Server Explorer and Data Toolbox
267(3)
Controls and Data Forms
270(1)
Where Are We?
271(2)
XML and Data Access Integration
273(78)
XML and Traditional Data Access
273(1)
XML and ADO.NET
274(24)
Defining a DataSet's Schema
275(5)
Refining DataSet's XML Schema
280(3)
Reading XML into DataSet
283(5)
Writing XML Schemas from DataSet
288(3)
Microsoft-Specific Annotations
291(1)
Writing XML Data from DataSet
292(6)
Serialization, Marshaling, and DataSet
298(4)
Typed DataSets
302(20)
The XmlDataDocument Class
322(11)
XmlDataDocuments and DataSets
324(7)
XmlDataDocument and DataDocumentXPathNavigator
331(2)
Why Databases and XML?
333(1)
XML as a Distinct Type
333(1)
Document Composition and Decomposition
334(1)
SQL Server, XML, and Managed Data Access
334(5)
The FOR XML Keyword
335(1)
OpenXML
336(1)
The SQLOLEDB Provider
336(1)
The SqlXml Managed Classes
337(1)
The SQLXML Web Application
337(1)
Updategrams
337(2)
FOR XML in the SQLXMLOLEDB Provider
339(1)
Bulk Loading
339(1)
Future Support
339(1)
Using SQLXML and .NET
339(9)
Where Are We?
348(3)
Providers: ADO.NET and Data Providers
351(50)
What Are Your Choices?
351(2)
Staying with OLE DB: A Summary of OLE DB Concepts
353(3)
Staying with OLE DB: Interaction with the OleDb Data Provider
356(10)
Main Cotypes and Type Mapping
357(1)
Accessors
358(1)
Executing Commands, Returning Results, and Using OpenRowset
358(1)
Command Results Format and Behaviors
359(1)
Command Dialects
359(1)
Hierarchical Data
360(1)
Updating from a Rowset
360(1)
Errors
361(1)
Unsupported Functions
361(1)
Supported and Unsupported Providers
361(5)
Writing a Data Provider
366(2)
Implementing the Connection Class
368(3)
Specification
369(1)
Implementation
369(1)
Specialization
370(1)
Implementing the Command Class
371(4)
Specification
371(2)
Implementation
373(1)
Specialization
374(1)
Implementing the DataReader Class
375(5)
Specification
376(1)
Implementation
377(2)
Specialization
379(1)
Implementing the DataAdapter Class
380(2)
Specification
380(1)
Implementation
381(1)
Specialization
382(1)
Adding Enhanced Functionality
382(1)
Implementing XML Infoset Providers
383(3)
Implementing XmlReader
386(6)
Implementing XPathNavigator
392(4)
Implementation Alternatives: Conclusions
396(2)
Is a Single Universal Data Access Model Possible?
398(2)
Where Are We?
400(1)
Consumers: ADO.NET Migration for Consumers
401(58)
ADO.NET Migration Paths
401(1)
ADO.NET for OLE DB Programmers
402(5)
Cotype Equivalents
403(1)
Data Provider Transparency
404(1)
Using Provider-Specific Functionality
405(1)
Error Handling
405(1)
System-Supplied Services
406(1)
System-Supplied Components
406(1)
Service Providers
407(1)
Marshaling
407(1)
A Brief Overview of ADO
407(3)
ADO.NET for ADO Programmers
410(5)
Class Equivalences
410(5)
ADO Connections, Commands, and Transactions
415(2)
Connections and Connection Strings
416(1)
Using Transactions
416(1)
Commands and Command Behaviors
416(1)
Hierarchical Data
417(1)
Asynchronous Operations
417(1)
Properties
417(1)
ADO.NET Versus ADO Disconnected Model
417(8)
Class Equivalents
418(1)
Navigation
419(1)
What Happened to GetRows in ADO.NET?
420(2)
Updates
422(1)
Update Statement Creation
423(1)
Batch Updates
423(1)
ADO.NET DataSet Extensions
423(1)
Column and Table Naming
424(1)
Sorting and Filtering
424(1)
ADO DB Interoperability
425(8)
ADO.NET for ODBC Programmers
433(10)
Handles and Environment
434(1)
Commands
435(1)
Fetching Data
436(1)
Metadata and Schema Information
436(1)
Errors
437(6)
ADO.NET for JDBC Programmers
443(13)
Generic Code
443(1)
Provider Types
443(2)
Connection Pooling
445(1)
Nonrelational Data Types
445(1)
Object Databases
445(1)
Other SQL-99 Extensions
446(1)
Metadata
446(1)
Transactions
446(1)
Commands and Behaviors
447(1)
Executing Queries and Returning Results
447(1)
Server Cursors
448(1)
Errors
448(8)
ADO.NET JDBC Programmers and the Disconnected Model
456(1)
SQL/J Part 0 and Typed DataSets
457(1)
Where Are We?
458(1)
ADO.NET and Various Types of Data
459(12)
Evolution in Data Access
459(2)
ADO.NET with Server- and File-Based RDBMS
461(3)
ADO.NET with Homogeneous Hierarchical Data and ORDBMS
464(1)
ADO.NET and Network Data: Object Graphs, OODBMS, and Network DBMS
465(2)
ADO.NET and Structured Files, Multidimensional Data, and ORDBMS
467(1)
ADO.NET Flat Files and Semistructured Files
468(1)
Where Are We Going?
469(2)
Appendix A Data Types and Type Mappings 471(12)
Appendix B Expression Syntax 483(8)
Appendix C Schema Inference Rules 491(10)
Bibliography 501(2)
Index 503

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.