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

A practical book and eBook 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

Progressing
Jagadish Chatarji Pulakhandam, Sunitha Paruchuri

A practical book and eBook for developers working with the Oracle Data Provider for .NET and the Oracle Developer Tools for Visual Studio 2005
$13.50
$49.99
RRP $29.99
RRP $49.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

+ Collection
Free Sample

Book Details

ISBN 139781847191960
Paperback328 pages

About This Book

  • 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

 

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

 

Table of Contents

Chapter 1: Introduction to ODP.NET
Introduction to ODP.NET
Why Use ODP.NET?
Introduction to Oracle Database Extensions for .NET
Introduction to Oracle Developer Tools for Visual Studio
Summary
Chapter 2: Connecting to Oracle
Provider-Independent Model in ADO.NET 2.0
Connecting to Oracle Databases from .NET
Summary
Chapter 3: Retrieving Data from Oracle Using ODP.NET
Fundamental ODP.NET Classes to Retrieve Data
Retrieving Data Using OracleDataReader
Working with Data Tables and Data Sets
More About the OracleCommand Object
Techniques to Improve Performance while Retrieving Data
Summary
Chapter 4: Manipulating Data in Oracle Using ODP.NET
Executing DML or DDL Statements Using OracleCommand
Updating Offline Data to the Database Using OracleDataAdapter
Working with OracleCommandBuilder and OracleDataAdapter
Working with Transactions Using ODP.NET
Handling Oracle Errors and Exceptions
Summary
Chapter 5: Programming ODP.NET with PL/SQL
Working with Anonymous PL/SQL Blocks
Working with PL/SQL Stored Procedures and Functions
PL/SQL Packages, Tables, and REF CURSOR
Summary
Chapter 6: Dealing with Large Objects (LOBs)
Working with BFILEs
Working with BLOBs
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
Manipulating Rows in a Table Using XML
Working with Native XML in Oracle Database
Summary
Chapter 8: Application Development Using ODP.NET
Notifying Applications of Database Changes
Developing Long-Running Applications
Developing Web Applications Using ASP.NET and ODP.NET
Developing Web Reports Using ASP.NET
Object-Oriented Development Using ASP.NET and ODP.NET
Developing Web Services Using ODP.NET
Developing Smart Device Applications
Summary
Chapter 9: Introduction to Oracle Developer Tools for Visual Studio 2005
Features of Oracle Developer Tools
Debugging PL/SQL Stored Procedures from Visual Studio
.NET CLR Stored Procedures in Oracle
Taking Advantage of Automatic .NET Code Generation
Summary

What You Will Learn

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

Authors

Table of Contents

Chapter 1: Introduction to ODP.NET
Introduction to ODP.NET
Why Use ODP.NET?
Introduction to Oracle Database Extensions for .NET
Introduction to Oracle Developer Tools for Visual Studio
Summary
Chapter 2: Connecting to Oracle
Provider-Independent Model in ADO.NET 2.0
Connecting to Oracle Databases from .NET
Summary
Chapter 3: Retrieving Data from Oracle Using ODP.NET
Fundamental ODP.NET Classes to Retrieve Data
Retrieving Data Using OracleDataReader
Working with Data Tables and Data Sets
More About the OracleCommand Object
Techniques to Improve Performance while Retrieving Data
Summary
Chapter 4: Manipulating Data in Oracle Using ODP.NET
Executing DML or DDL Statements Using OracleCommand
Updating Offline Data to the Database Using OracleDataAdapter
Working with OracleCommandBuilder and OracleDataAdapter
Working with Transactions Using ODP.NET
Handling Oracle Errors and Exceptions
Summary
Chapter 5: Programming ODP.NET with PL/SQL
Working with Anonymous PL/SQL Blocks
Working with PL/SQL Stored Procedures and Functions
PL/SQL Packages, Tables, and REF CURSOR
Summary
Chapter 6: Dealing with Large Objects (LOBs)
Working with BFILEs
Working with BLOBs
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
Manipulating Rows in a Table Using XML
Working with Native XML in Oracle Database
Summary
Chapter 8: Application Development Using ODP.NET
Notifying Applications of Database Changes
Developing Long-Running Applications
Developing Web Applications Using ASP.NET and ODP.NET
Developing Web Reports Using ASP.NET
Object-Oriented Development Using ASP.NET and ODP.NET
Developing Web Services Using ODP.NET
Developing Smart Device Applications
Summary
Chapter 9: Introduction to Oracle Developer Tools for Visual Studio 2005
Features of Oracle Developer Tools
Debugging PL/SQL Stored Procedures from Visual Studio
.NET CLR Stored Procedures in Oracle
Taking Advantage of Automatic .NET Code Generation
Summary

Book Details

ISBN 139781847191960
Paperback328 pages
Read More