alt
Online Training
Career Series
Exforsys
Exforsys arrow Tutorials arrow ODP.NET arrow Getting Started with Oracle and ODP.NET
Site Search


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


Trackback(0)
Comments (0)add comment

Write comment

busy
 
Next >
Sponsored Links
© 2008 Exforsys.com
Joomla! is Free Software released under the GNU/GPL License.
Page copy protected against web site content infringement by Copyscape