Skip to main content
SpringerLink
Log in
Apress
Book cover

Pro ODP.NET for Oracle Database 11g

  • Book
  • © 2010

Overview

Authors:
  1. Edmund Zehoo
    View author publications

    You can also search for this author in PubMed   Google Scholar

  • This book is a comprehensive and easy-to-understand guide for using the Oracle Data Provider (ODP) version 11g on the .NET Framework.

This is a preview of subscription content, log in via an institution to check access.

Access this book

Log in via an institution
eBook USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Other ways to access

Licence this eBook for your library

Institutional subscriptions

Table of contents (15 chapters)

  1. Front Matter

    Pages i-xix
    Download chapter PDF

  2. Introduction to Oracle .NET Connectivity

    • Edmund Zehoo
    Pages 1-17

  3. ODP.NET: A Functional Overview

    • Edmund Zehoo
    Pages 19-48

  4. Connecting to Oracle with ODP.NET

    • Edmund Zehoo
    Pages 49-67

  5. Retrieving and Manipulating Data with ODP.NET

    • Edmund Zehoo
    Pages 69-115

  6. Using PL/SQL and .NET CLR Stored Procedures with ODP.NET

    • Edmund Zehoo
    Pages 117-159

  7. ODP.NET Globalization

    • Edmund Zehoo
    Pages 161-186

  8. Transactions with ODP.NET

    • Edmund Zehoo
    Pages 187-203

  9. Oracle Database Change Notifications with ODP.NET

    • Edmund Zehoo
    Pages 205-222

  10. Using Oracle Database Streams Advanced Queuing with ODP.NET

    • Edmund Zehoo
    Pages 223-251

  11. Oracle XML Support

    • Edmund Zehoo
    Pages 253-285

  12. ODP.NET Security Features

    • Edmund Zehoo
    Pages 287-315

  13. ODP.NET Performance

    • Edmund Zehoo
    Pages 317-349

  14. Design Patterns and Considerations in Using ODP.NET

    • Edmund Zehoo
    Pages 351-371

  15. ODT.NET Tool Basics

    • Edmund Zehoo
    Pages 373-399

  16. Building Data-Driven Applications with ODT.NET

    • Edmund Zehoo
    Pages 401-427

  17. Back Matter

    Pages 429-445
    Download chapter PDF
Back to top

Keywords

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 (11.1.0.7.10). 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.

About the author

Edmund T. Zehoo is the chief technology officer and co-founder of Arigoo Pte Ltd., an e-forms and workflows solution vendor based in Singapore. He was the lead architect in the four-year design of Arigoo's flagship product from scratch, which is now a mature product in Singapore with a list of multinational corporate customers to its name. He also holds more than eight years of experience in building performance critical .NET e-forms and workflows solutions hosted on top of Oracle databases for large companies and governmental institutions located in Singapore.

Bibliographic Information

Publish with us

Policies and ethics

Back to top

Search

Navigation