Applied ADO.NET Building Data-Driven Solutions

Applied ADO.NET: Building Data-Driven Solutions provides extensive coverage of ADO.NET technology, including ADO.NET internals, namespaces, classes, and interfaces. Whereas most books cover only the SQL and OLE DB data providers, authors Mahesh Chand and David Talbot detail the SQL, OLE DB, and ODBC...

Full description

Bibliographic Details
Main Authors: Talbot, David, Chand, Mahesh (Author)
Format: eBook
Language:English
Published: Berkeley, CA Apress 2003, 2003
Edition:1st ed. 2003
Subjects:
Online Access:
Collection: Springer Book Archives -2004 - Collection details see MPG.ReNa
Table of Contents:
  • 1 ADO.NET Basics
  • 2 Data Components in Visual Studio .NET
  • 3 ADO.NET in Disconnected Environments
  • 4 ADO.NET in Connected Environments
  • 5 Handling ADO.NET Events
  • 6 Integrating XML with ADO.NET
  • 7 Data Binding and Windows Forms Data-Bound Controls
  • 8 Constraints and Data Relations
  • 9 ADO.NET Exception Handling
  • 10 Working with the ODBC .NET Data Provider
  • 11 Stored Procedures and Views
  • 12 Oracle, SQLXML, and Other .NET Data Providers
  • 13 Developing a Custom Data Provider
  • 14 Developing Database Web Applications Using ASP.NET
  • 15 Using ADO.NET in XML Web Services
  • 16 ASP.NET Server Controls and Data Binding
  • 17 Building Real-World Web Applications
  • 18 Object-Relational Mapping in .NET
  • 19 Mapped Objects: Performance Considerations and Data Binding
  • 20 COM Interoperability and ADO.NET
  • 21 Messaging
  • 22 SQL Server and ADO.NET: Notes on Performance
  • Appendix A Relational Databases: Some Basic Concepts
  • Understanding Normalization
  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
  • Boyce-Codd Normal Form (BCNF)
  • Fourth Normal Form (4NF)
  • Fifth Normal Form (5NF or PJ/NF)
  • Introducing Sets, Cursors, and ADO.NET
  • Using Locking
  • Isolation Levels
  • Locking Modes
  • Summary
  • Appendix B Commonly Used SQL Statements
  • Understanding SQL References
  • Using the SELECT Statement
  • Using the UPDATE Statement
  • Using the DELETE Statement
  • Using the CREATE TABLE Statement
  • Using the DROP TABLE Statement
  • Using the TRUNCATE TABLE Statement
  • Using the INSERT Statement
  • Using Joins and Aliases
  • Understanding Views
  • Using SQL Server’s SELECT...FOR XML Clause
  • Summary
  • Appendix C ADO.NET Frequently Asked Questions
  • Summary