ODP.NET Developer’s Guide Table of Contents

Back to BOOK PAGE

Preface
Chapter 1: Introduction to ODP.NET
Chapter 2: Connecting to Oracle
Chapter 3: Retrieving Data from Oracle Using ODP.NET
Chapter 4: Manipulating Data in Oracle Using ODP.NET
Chapter 5: Programming ODP.NET with PL/SQL
Chapter 6: Dealing with Large Objects (LOBs)
Chapter 7: XML and XML DB Development with ODP.NET
Chapter 8: Application Development Using ODP.NET
Chapter 9: Introduction to Oracle Developer Tools for Visual Studio 2005
Index

Preface

Chapter 1: Introduction to ODP.NET
- Introduction to ODP.NET
- Why Use ODP.NET?
  - Oracle Database Access from .NET Applications
  - What Do We Require to Work with ODP.NET?
- Introduction to Oracle Database Extensions for .NET
  - Oracle Database Extensions for .NET
    - How does .NET Work within Oracle Database?
    - Processing of .NET Stored Procedure with Oracle
- Introduction to Oracle Developer Tools for Visual Studio
- Summary

Chapter 2: Connecting to Oracle
- Provider-Independent Model in ADO.NET 2.0
  - Listing All Installed .NET Data Providers
  - Enumerating all Oracle Data Sources Available
- Connecting to Oracle Databases from .NET
  - Connecting Using .NET Data Provider Factory Classes
  - Connecting Using .NET Data Provider for OLEDB
  - Connecting Using .NET Data Provider for ODBC
  - Connecting using Microsoft's .NET Data Provider for Oracle
  - Connecting Using Oracle Data Provider for .NET (ODP.NET)
  - Connecting with Connection Pooling
  - Connecting with System-Level Privileges or DBA Privileges
  - Dynamic Connecting String Using OracleConnectionStringBuilder and app.config
  - Embedding a "tnsnames.ora" Entry-like Connection String
  - Connecting to a Default Oracle Database
  - Connecting Using Windows Authentication (Single SignOn)
- Summary

Chapter 3: Retrieving Data from Oracle Using ODP.NET
- Fundamental ODP.NET Classes to Retrieve Data
- Retrieving Data Using OracleDataReader
  - Retrieving a Single Row of Information
  - Using "Using" for Simplicity
  - Retrieving Multiple Rows on to the Grid
  - Pulling Information Using Table Name
  - Retrieving Typed Data
- Working with Data Tables and Data Sets
  - Retrieving Multiple Rows into a DataTable Using OracleDataAdapter
  - Filling a DataTable Using OracleDataReader
  - Retrieving a Single Row of Information Using OracleDataAdapter
  - Working with DataTableReader
  - Populating a Dataset with a Single Data Table
  - Populating a Dataset with Multiple Data Tables
  - Presenting Master-Detail Information Using a Dataset
- More About the OracleCommand Object
  - Retrieving a Single Value from the Database
  - Handling Nulls when Executing with ExecuteScalar
  - Handling Nulls when Working with OracleDataReader
  - Working with Bind Variables together with OracleParameter
  - Working with OracleDataAdapter together with OracleCommand

Techniques to Improve Performance while Retrieving Data
Summary

Chapter 4: Manipulating Data in Oracle Using ODP.NET
- Executing DML or DDL Statements Using OracleCommand
  - Using INSERT with OracleCommand
  - Using UPDATE with OracleCommand
  - Using DELETE with OracleCommand
  - Multiple Inserts Using Statement Caching
  - Multiple Inserts Using Array Binding
  - Creating an Oracle Table Dynamically Using ODP.NET
- Updating Offline Data to the Database Using OracleDataAdapter
- Working with OracleCommandBuilder and OracleDataAdapter
- Working with Transactions Using ODP.NET
- Handling Oracle Errors and Exceptions
  - Displaying a Single or First Error
  - Displaying Multiple Errors
- Summary

Chapter 5: Programming ODP.NET with PL/SQL
- Working with Anonymous PL/SQL Blocks
  - Executing Anonymous PL/SQL Blocks
  - Passing Information to Anonymous PL/SQL Blocks
  - Retrieving Information from Anonymous Blocks
- Working with PL/SQL Stored Procedures and Functions
  - Executing a PL/SQL Stored Procedure
  - Passing Parameter Values to a PL/SQL Stored Procedure
  - Using an Anonymous PL/SQL Block to Execute a PL/SQL Stored Procedure
  - Retrieving Output Parameters from a PL/SQL Stored Procedure
  - Passing IN and Getting OUT Simultaneously
  - Handling User-Defined Application Errors
  - Executing a PL/SQL User-Defined Function
- PL/SQL Packages, Tables, and REF CURSOR
  - Executing Routines in a PL/SQL Package
    - Executing a Procedure in a PL/SQL Package
    - Executing a User-Defined Function in a PL/SQL Package
  - Passing Arrays to and Receiving Arrays from Oracle Database
    - Sending an Array to Oracle Database
    - Receiving an Array from Oracle Database
  - Working with REF CURSOR Using ODP.NET
    - Pulling from REF CURSOR Using OracleDataReader
    - Filling a Dataset from REF CURSOR
    - Working with Multiple Active Result Sets (MARS)
- Summary

Chapter 6: Dealing with Large Objects (LOBs)
- Working with BFILEs
  - Setting Up the Environment to Work with BFILEs
  - Adding a New Row Containing BFILE
  - Updating an Existing BFILE Row
  - Retrieving BFILE Information from a Database
  - Retrieving Properties of a BFILE
  - Working with CLOBs
  - Inserting Huge Text Information into Oracle Database
  - Updating CLOB Information Using OracleClob
  - Retrieving CLOB Information from Oracle Database
  - Reading a Text File and Uploading as CLOB
- Working with BLOBs
  - Setting Up the Environment to Work with BLOBs
  - Uploading Images to Oracle Database Using BLOB
  - Retrieving Images from Oracle Database Using BLOB
  - Uploading Documents to and Retrieving Documents from Oracle Database
- Summary

Chapter 7: XML and XML DB Development with ODP.NET
- A Fast Track on XML with Oracle
- Generating XML from Existing Rows in Tables
  - Generate XML Using ADO.NET DataSet
  - Generate XML Using ExecuteXMLReader
  - Generate XML Using DBMS_XMLGEN
  - Converting Rows to HTML Using XML and XSLT
- Manipulating Rows in a Table Using XML
  - Inserting Rows into Oracle Using XML
  - Updating Rows into Oracle Using XML
- Working with Native XML in Oracle Database
  - Inserting XML Data into XMLType Using Traditional INSERT
  - Updating XML Data in XMLType Using Traditional UPDATE
  - Inserting XML Data Using OracleXmlType
  - Retrieving and Updating XML Data Using OracleXmlType
  - Extracting Individual Node Information of an XMLType Value
- Summary

Chapter 8: Application Development Using ODP.NET
- Notifying Applications of Database Changes
  - Catching Notifications
    - Catching Multiple Notifications
  - Identifying Rows Modified During Notifications
- Developing Long-Running Applications
  - The Devil of Applications: "Not Responding"
  - Asynchronous Task with Multi-Threading
- Developing Web Applications Using ASP.NET and ODP.NET
  - Web Development Using Smart Data Binding
    - Populating an ASP.NET DropDownList Control
    - Linking an ASP.NET GridView Control with a DropDownList Control
    - Add, Update, or Delete a Row Using GridView and FormView
  - Working with Web Controls Manually
- Developing Web Reports Using ASP.NET
  - Creating a Strongly-Typed Dataset Using Designer
  - Designing and Binding a Report to the Dataset
  - Grouping and Displaying Sub-Totals
  - Embedding Charts (Graphs) in Reports
- Object-Oriented Development Using ASP.NET and ODP.NET
  - Developing a Simple Oracle Database Helper Class
  - Developing a Simple Business Logic Class
  - Working with ObjectDataSource in an ASP.NET 2.0 Web Form
- Developing Web Services Using ODP.NET
  - Creating the .NET XML Web Service
  - Consuming the Web Service from ASP.NET
- Developing Smart Device Applications
  - Introducing Microsoft Windows Mobile
  - Consuming a Web Service from Pocket PC
- Summary

Chapter 9: Introduction to Oracle Developer Tools for Visual Studio 2005
- Features of Oracle Developer Tools
  - Connecting to Oracle from Visual Studio Using Oracle Explorer
  - Retrieving Oracle Information from Visual Studio Using ODT
  - Working with Oracle Database Objects from Visual Studio Using ODT
    - Dealing with Tables, Views, and Sequences Using ODT
    - Creating Stored Procedures Using ODT
- Debugging PL/SQL Stored Procedures from Visual Studio
- .NET CLR Stored Procedures in Oracle
- Taking Advantage of Automatic .NET Code Generation
- Summary