HAPPY HOLIDAYS: Get a special discount on Apress Access! Subscribe today >>

Pro ODP.NET for Oracle Database 11g

Authors: Zehoo, Edmund, Hong, Yap Wai

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

Buy this book

eBook $49.99
price for USA
  • ISBN 978-1-4302-2821-9
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $64.99
price for USA
  • ISBN 978-1-4302-2820-2
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.
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 authors

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.

Table of contents (15 chapters)

  • Introduction to Oracle .NET Connectivity

    Zehoo, Edmund

    Pages 1-17

  • ODP.NET: A Functional Overview

    Zehoo, Edmund

    Pages 19-48

  • Connecting to Oracle with ODP.NET

    Zehoo, Edmund

    Pages 49-67

  • Retrieving and Manipulating Data with ODP.NET

    Zehoo, Edmund

    Pages 69-115

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

    Zehoo, Edmund

    Pages 117-159

Buy this book

eBook $49.99
price for USA
  • ISBN 978-1-4302-2821-9
  • Digitally watermarked, DRM-free
  • Included format: PDF
  • ebooks can be used on all reading devices
  • Download immediately after purchase
Softcover $64.99
price for USA
  • ISBN 978-1-4302-2820-2
  • Free shipping for individuals worldwide
  • Usually dispatched within 3 to 5 business days.

Services for this book

Loading...

Bibliographic Information

Bibliographic Information
Book Title
Pro ODP.NET for Oracle Database 11g
Authors
Copyright
2010
Publisher
Apress
Copyright Holder
Edmund Zehoo and Yap Wai Hong
eBook ISBN
978-1-4302-2821-9
DOI
10.1007/978-1-4302-2821-9
Softcover ISBN
978-1-4302-2820-2
Edition Number
1
Number of Pages
XX, 468
Topics