|
|
Oracle's ODP.NET
|
|
Book Excerpt: 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.
|
|
This excerpt from
ODP.NET Developer's Guide: Oracle Database 10g Development with Visual Studio
2005 and the Oracle Data Provider for .NET by Jagadish Chatarji
Pulakhandam, Sunitha Paruchuri, is printed with permission from
Packt Publishing, Copyright 2007.
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
Chapter Contents
|
|
Page 1
| Page 2
|
page 3 |
page 4 |
page 5 |
page 6 |
page 7 |
page 8
|
|
|
|
|