PacktLib: ODP.NET Developer’s Guide: Oracle Database 10g Development with Visual Studio 2005 and the Oracle Data Provider for .NET

ODP.NET Developer's Guide

Credits

About the Authors

About the Reviewer

Preface

Introduction to ODP.NET

Introduction to ODP.NET

Why Use ODP.NET?

Introduction to Oracle Database Extensions for .NET

Introduction to Oracle Developer Tools for Visual Studio

Summary

Connecting to Oracle

Provider-Independent Model in ADO.NET 2.0

Connecting to Oracle Databases from .NET

Summary

Retrieving Data from Oracle Using ODP.NET

Fundamental ODP.NET Classes to Retrieve Data

Retrieving Data Using OracleDataReader

Working with Data Tables and Data Sets

More About the OracleCommand Object

Techniques to Improve Performance while Retrieving Data

Summary

Manipulating Data in Oracle Using ODP.NET

Executing DML or DDL Statements Using OracleCommand

Updating Offline Data to the Database Using OracleDataAdapter

Working with OracleCommandBuilder and OracleDataAdapter

Working with Transactions Using ODP.NET

Handling Oracle Errors and Exceptions

Summary

Programming ODP.NET with PL/SQL

Working with Anonymous PL/SQL Blocks

Working with PL/SQL Stored Procedures and Functions

PL/SQL Packages, Tables, and REF CURSOR

Summary

Dealing with Large Objects (LOBs)

Working with BFILEs

Working with BLOBs

Summary

XML and XML DB Development with ODP.NET

A Fast Track on XML with Oracle

Generating XML from Existing Rows in Tables

Manipulating Rows in a Table Using XML

Working with Native XML in Oracle Database

Summary

Application Development Using ODP.NET

Notifying Applications of Database Changes

Developing Long-Running Applications

Developing Web Applications Using ASP.NET and ODP.NET

Developing Web Reports Using ASP.NET

Object-Oriented Development Using ASP.NET and ODP.NET

Developing Web Services Using ODP.NET

Developing Smart Device Applications

Summary

Introduction to Oracle Developer Tools for Visual Studio 2005

Features of Oracle Developer Tools

Debugging PL/SQL Stored Procedures from Visual Studio

.NET CLR Stored Procedures in Oracle

Taking Advantage of Automatic .NET Code Generation

Summary