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: Oracle Database 10g Development with Visual Studio 2005 and the Oracle Data Provider for .NET
eBook: $29.99
Formats: PDF, PacktLib, ePub and Mobi formats
$13.50
save 55%!
Print + free eBook + free PacktLib access to the book: $79.98    Print cover: $49.99
$63.49
save 21%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  • Application development with ODP.NET
  • Dealing with XML DB using ODP.NET
  • Oracle Developer Tools for Visual Studio .NET
  • Read: Chapter 3 [PDF 1 MB] | Table of Contents
  • Available to download immediately as an eBook

 

Book Details

Language : English
Paperback : 328 pages [ 235mm x 191mm ]
Release Date : June 2007
ISBN : 1847191967
ISBN 13 : 9781847191960
Author(s) : Jagadish Chatarji Pulakhandam, Sunitha Paruchuri
Topics and Technologies : All Books, Enterprise Products and Platforms, Microsoft Development , Oracle Database, Enterprise, Microsoft, .NET, Oracle


Table of Contents

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
  • 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

Jagadish Chatarji Pulakhandam

Jagadish Chatarji Pulakhandam currently works as a .NET Architect and is responsible for analyzing/designing enterprise-level .NET applications. He has worked with Oracle since database version 7.1 and has been in the IT field for about 12 years. Apart from Oracle and .NET, he has a good knowledge of developing corporate software and web applications, designing and implementing databases, designing and implementing data warehouses, and working with enterprise reporting software. During his free time, he contributes technical articles to OTN (Oracle Technology Network) and to the world of developer communities.


Contact Jagadish Chatarji Pulakhandam


Sunitha Paruchuri

Sunitha Paruchuri has been programming with Microsoft tools and Oracle since 1997. She has developed numerous desktop, web, mobile and distributed applications using Microsoft.NET and has good experience with other Microsoft products like Microsoft SQL Server, Microsoft Sharepoint Portal Server, etc.


Contact Sunitha Paruchuri

Sorry, we don't have any reviews for this title yet.

Code Downloads

Download the code and support files for this book.


Submit Errata

Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.


Errata

- 2 submitted: last submission 23 Nov 2012

Errata type: Typo | Page number: 11 |

Last sentence, first paragraph reads: Once the control comes back to PL/SQL engine, it proceeds with the normal and traditional the PL/SQL process flow of execution. it should be, Once the control comes back to PL/SQL engine, it proceeds with the normal and the traditional PL/SQL process flow of execution.

 

Errata type: Typo | Page number: 167 |

On penultimate paragraph, last phrase, a reference "In this ARTICLE we mainly focus on XSLT..." is made. Change it to "In this book we mainly.....".

 

Sample chapters

You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

Frequently bought together

ODP.NET Developer’s Guide: Oracle Database 10g Development with Visual Studio 2005 and the Oracle Data Provider for .NET +    Liferay Portal 6 Enterprise Intranets =
50% Off
the second eBook
Price for both: $36.90

Buy both these recommended eBooks together and get 50% off the cheapest eBook.

What you will learn from this book

  •     Different ways of Connecting to Oracle databases using ODP.NET (including Single Sign-on)
  •     Executing SQL queries and commands using ODP.NET
  •     Working with PL/SQL blocks, stored procedures, stored functions, packages, and REF CURSORs
  •     Working with Large Objects like BFILE, BLOB, and CLOB using ODP.NET
  •     Working with XML and XMLDB
  •     Application development using ODP.NET
  •     Database change notifications and Asynchronous programming
  •     Developing Web Applications using ASP.NET and ODP.NET
  •     Reporting (including charts) using ASP.NET and ODP.NET
  •     Developing XML Web Services using ODP.NET
  •     Developing applications for Smart Client devices (like Pocket PC)
  •     Using Oracle Developer Tools for Visual Studio 2005
  •     Creating and debugging PL/SQL stored procedures from Visual Studio 2005
  •     Creating and Deploying .NET CLR stored procedures in Oracle database using Visual Studio 2005

Chapter 1 introduces the concept of Oracle Database Extensions for .NET and provides information about Oracle Developer tools for Visual Studio.

Chapter 2 introduces the Provider Independent Model in ADO.NET 2.0, and shows how to connect to Oracle databases from .NET, working with .NET data providers, connection pooling, system privileged connection, and single sign-on etc.

Chapter 3 shows you several methods to retrieve data from an Oracle database. You will work with the core ODP.NET classes like OracleCommand, OracleDataReader, OracleDataAdapter, OracleParameter and ADO.NET classes like Dataset, DataTable, and DataRow etc.

Chapter 4 is about inserting, updating, and deleting data in the database. You will also learn about statement caching, array binding, working with offline data, implementing transactions, and handling errors and exceptions encountered during database work.

Chapter 5 deals with working with PL/SQL blocks, PL/SQL stored procedures, and functions. It also teaches you how to execute routines in PL/SQL packages, how to pass and receive arrays from the Oracle database, and working with REF CURSOR using ODP.NET.

Chapter 6 is completely dedicated to dealing with Large objects in Oracle. This chapter illustrates concepts, configurations, and programming for BFILE, BLOB, and CLOB (or NCLOB) in conjunction with ODP.NET.

Chapter 7 gives details about Oracle XML DB, an add-on feature of Oracle database. It provides information about generating XML from existing rows in tables, manipulating rows in a table using XML, and working with native XML in the Oracle database.

Chapter 8 deals with real-time application development scenarios like Oracle database change notifications, Asynchronous Application development, Web Application development using ASP.NET 2.0, Web Reporting (including grouping, sub-totals, charts etc.), Object-Oriented Development with ODP.NET and ASP.NET, XML Web Services development using ODP.NET and Smart Device Application development (for clients like the Pocket PC etc.).

Chapter 9 introduces you to Oracle Developer Tools for Visual Studio 2005. It teaches you to connect to Oracle from the Visual Studio 2005 environment, retrieve Oracle information from Visual Studio, and work with database objects from Visual Studio. It also provides information about how to create and debug PL/SQL stored procedures and .NET CLR Stored Procedures in Oracle.

In Detail

The Oracle Data Provider for .NET (ODP.NET) features optimized data access to the Oracle database from a .NET environment and allows developers to take advantage of advanced Oracle database functionality, including Real Application Clusters, XML DB, and advanced security. It can be used from any .NET language, including C# and VB.NET.

This book is a practical guide that will give you the in-depth information you need to work with the Oracle 10g v10.2 database from Visual Studio .NET 2005, using the Oracle Developer Tools and ODP.NET.

After introducing ODP.NET, we move on to dealing with SQL, PL/SQL, and XML DB using ODP.NET. Next we look at application development with ODP.NET: Web Applications, Web Services, and Mobile Applications. The last chapter covers Oracle Developer Tools for Visual Studio .NET. All the code examples are in Visual Basic.NET 2005.

Read the full Table of Contents for ODP.NET Developer’s Guide

Chapter-by-Chapter

Chapter 1 introduces the concept of Oracle Database Extensions for .NET and provides information about Oracle Developer tools for Visual Studio.

Chapter 2 introduces the Provider Independent Model in ADO.NET 2.0, and shows how to connect to Oracle databases from .NET, working with .NET data providers, connection pooling, system privileged connection, and single sign-on etc.

Chapter 3 shows you several methods to retrieve data from an Oracle database. You will work with the core ODP.NET classes like OracleCommand, OracleDataReader, OracleDataAdapter, OracleParameter and ADO.NET classes like Dataset, DataTable, and DataRow etc.

Chapter 4 is about inserting, updating, and deleting data in the database. You will also learn about statement caching, array binding, working with offline data, implementing transactions, and handling errors and exceptions encountered during database work.

Chapter 5 deals with working with PL/SQL blocks, PL/SQL stored procedures, and functions. It also teaches you how to execute routines in PL/SQL packages, how to pass and receive arrays from the Oracle database, and working with REF CURSOR using ODP.NET.

Chapter 6 is completely dedicated to dealing with Large objects in Oracle. This chapter illustrates concepts, configurations, and programming for BFILE, BLOB, and CLOB (or NCLOB) in conjunction with ODP.NET.

Chapter 7 gives details about Oracle XML DB, an add-on feature of Oracle database. It provides information about generating XML from existing rows in tables, manipulating rows in a table using XML, and working with native XML in the Oracle database.

Chapter 8 deals with real-time application development scenarios like Oracle database change notifications, Asynchronous Application development, Web Application development using ASP.NET 2.0, Web Reporting (including grouping, sub-totals, charts etc.), Object-Oriented Development with ODP.NET and ASP.NET, XML Web Services development using ODP.NET and Smart Device Application development (for clients like the Pocket PC etc.).

Chapter 9 introduces you to Oracle Developer Tools for Visual Studio 2005. It teaches you to connect to Oracle from the Visual Studio 2005 environment, retrieve Oracle information from Visual Studio, and work with database objects from Visual Studio. It also provides information about how to create and debug PL/SQL stored procedures and .NET CLR Stored Procedures in Oracle.

This is a practical guide for developers working with the Oracle Data Provider for .NET (ODP.NET) using VB.NET. From introducing ODP.NET and programming with ODP.NET to application development using ODP.NET and on to discussing Oracle Developer Tools for Visual Studio 2005, this book covers the most important aspects of ODP.NET.

Read: Chapter 3: Retrieving Data From Oracle Using ODP Dot NET [889 KB] | Table of Contents

Approach

This book uses many hands-on examples to show you how to use ODP.NET and Oracle Developer Tools from within Visual Studio 2005 to access Oracle Database 10g.

Who this book is for

The book is written for professional .NET developers who need to work with and take full advantage of Oracle Database 10g using Visual Studio 2005. Developers are expected to be familiar with Visual Basic.NET 2005 and have minimum knowledge of Oracle SQL and PL/SQL.

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

 

Code Download and Errata
Packt Anytime, Anywhere
Register Books
Print Upgrades
eBook Downloads
Video Support
Contact Us
Awards Voting Nominations Previous Winners
Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
Resources
Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software