Pro ODP .NET for Oracle Database 11g

  • Authors
  • Edmund Zehoo

Table of contents

  1. Front Matter
    Pages i-xix
  2. Edmund Zehoo
    Pages 19-48
  3. Edmund Zehoo
    Pages 49-67
  4. Edmund Zehoo
    Pages 161-186
  5. Edmund Zehoo
    Pages 187-203
  6. Edmund Zehoo
    Pages 253-285
  7. Edmund Zehoo
    Pages 287-315
  8. Edmund Zehoo
    Pages 317-349
  9. Edmund Zehoo
    Pages 373-399
  10. Back Matter
    Pages 429-445

About this book


This book is a comprehensive and easy-to-understand guide for using the Oracle Data Provider (ODP) version 11g on the .NET Framework. It also outlines the core GoF (Gang of Four) design patterns and coding techniques employed to build and deploy high-impact mission-critical applications using advanced Oracle database features through the ODP.NET provider.

The book details the features of the ODP.NET provider in two main sections: “Basic,” covering the basics and mechanisms for data access via ODP.NET; and “Advanced,’ covering advanced Oracle features such as globalization, savepoints, distributed transactions and how to call them via ODP.NET, advanced queueing (AQ), and promotable transactions. It takes you from the ground up through different implementation scenarios via a rich collection of C# code samples.

It outlines database security and performance optimization tricks and techniques on ODP.NET that conform to best practices and adaptable design. Different GoF design patterns are highlighted for different types of ODP.NET usage scenarios with consideration of performance and security.

It provides a comprehensive guide to the synergistic integration of Oracle and Microsoft technologies such as the Oracle Developer Tools for Visual Studio ( It also details how programmers can make use of ODT to streamline the creation of robust ODP.NET applications from within the Visual Studio environment.


.NET 11g Oracle SQL XML database optimization performance technology

Bibliographic information