E-book details

ODP.NET Developer's Guide: Oracle Database 10g Development with Visual Studio 2005 and the Oracle Data Provider for .NET. A practical guide for developers working with the Oracle Data Provider for .NET and the Oracle Developer Tools for Visual Studio 2005

ODP.NET Developer's Guide: Oracle Database 10g Development with Visual Studio 2005 and the Oracle Data Provider for .NET. A practical guide for developers working with the Oracle Data Provider for .NET and the Oracle Developer Tools for Visual Studio 2005

Sunitha Paruchuri, Jagadish Chatarji Pulakhandam, Jagadish Pulakhandam

Ebook
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.

http://www.packtpub.com/article/ODP-dot-net-oracle-data-provider-table-of-conten - 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.
  • ODP.NET Developers Guide
    • Table of Contents
    • ODP.NET Developer's Guide
    • Credits
    • About the Authors
    • About the Reviewer
    • Preface
      • What This Book Covers
      • Conventions
      • Reader Feedback
      • Customer Support
        • Downloading the Example Code for the Book
        • Errata
        • Questions
    • 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
    • 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
    • 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
            • Retrieving Typed Data Using Ordinals
            • Retrieving Typed Data Using Column Names
      • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • 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
    • Index
  • Title: ODP.NET Developer's Guide: Oracle Database 10g Development with Visual Studio 2005 and the Oracle Data Provider for .NET. A practical guide for developers working with the Oracle Data Provider for .NET and the Oracle Developer Tools for Visual Studio 2005
  • Author: Sunitha Paruchuri, Jagadish Chatarji Pulakhandam, Jagadish Pulakhandam
  • Original title: ODP.NET Developer's Guide: Oracle Database 10g Development with Visual Studio 2005 and the Oracle Data Provider for .NET. A practical guide for developers working with the Oracle Data Provider for .NET and the Oracle Developer Tools for Visual Studio 2005
  • ISBN: 9781847191977, 9781847191977
  • Date of issue: 2007-06-25
  • Format: Ebook
  • Item ID: e_3cbx
  • Publisher: Packt Publishing