Getting Started with Oracle and ODP.NET

ODP.NET Developer’s Guide by Jagadish Chatarji Pulakhandam, Sunitha Paruchuri

A practical guide for developers working with the Oracle Data Provider for .NET and the Oracle Developer Tools for Visual Studio 2005

Application development with ODP.NET
Dealing with XML DB using ODP.NET
Oracle Developer Tools for Visual Studio .NET

Read Sample Chapter 3 Retrieving Data from Oracle Using ODP.NET from ODP.NET Developer’s Guide - 16 part series

Retrieving Data from Oracle Using ODP.NET

We have several methodologies to retrieve information from Oracle using ODP.NET. Sometimes, we may have to use few of the ODP.NET classes together with few of the ADO.NET classes to develop .NET applications efficiently.

In this chapter, we will concentrate on the following:

• Executing queries with OracleCommand
• Retrieving data using OracleDataReader
• Retrieving data using OracleDataAdapter
• Working with DataTable and Dataset when offline (disconnected mode)
• Using DataTableReader with DataTable
• Bind variables using OracleParameter
• Performance techniques

If you would like to work with stored procedures to retrieve data, you should skip to Chapter 5 (provided you are familiar with all the concepts discussed here).

START HERE

• ODP.NET - Fundamental ODP.NET Classes to Retrieve Data
• ODP.NET - Retrieving Data Using OracleDataReader
         Using "Using" for Simplicity
• ODP.NET - Retrieving Multiple Rows on to the Grid
         Pulling Information Using Table Name
• ODP.NET - Retrieving Typed Data
         Retrieving Multiple Rows
• ODP.NET - Filling a DataTable Using OracleDataReader
• ODP.NET - Retrieving a Single Row of Information Using OracleDataAdapter
• ODP.NET - Working with DataTableReader
• ODP.NET - Populating a Dataset with a Single Data Table
• ODP.NET - Populating a Dataset with Multiple Data Tables
• ODP.NET - Presenting Master-Detail Information Using a Dataset
• ODP.NET - OracleCommand Object
• ODP.NET - Handling Nulls when Executing with ExecuteScalar
• ODP.NET - Handling Nulls when Working with OracleDataReader
• ODP.NET - Working with Bind Variables together with OracleParameter
• ODP.NET - Working with OracleDataAdapter together with OracleCommand
• ODP.NET - Techniques to Improve Performance while Retrieving Data
        Summary
 

This book is available for purchase at Packtpub.com ODP.NET Developer’s Guide: Oracle Database 10g Development with Visual Studio 2005 and the Oracle Data Provider for .NET