Pro ODP.NET for Oracle Database 11g

Pro ODP.NET for Oracle Database 11g, 9781430228202 (1430228202), Apress, 2010

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 both VB.NET and 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 upcoming 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.

What you’ll learn

How to use the full set of features available in ODP.NET 11g (with code samples and diagrams illustrating each feature/concept). New features such as using Oracle Streams AQ, promotable transactions, Oracle database event notifications, and Oracle database control are also covered.
The core performance and feature differences between ODP.NET, Microsoft.NET Provider for Oracle, OLEDB.NET, and ODBC.NET, together with the strengths and weaknesses of each method. This section also provides comprehensive coverage on the differences between ODP.NET 9i, 10g, and 11g.
How to take advantage of connection pooling, fetch size controls, ref cursors, bind variables, client result cache and statement caching via ODP.NET to squeeze every ounce of performance from your .NET application.
How to secure your ODP.NET applications via authentication and ODP.NET 11g’s new classes to enforce imperative and declarative Oracle security.
The common programming pitfalls and design patterns to use/avoid in different ODP.NET usage scenarios
How to use a significant set of features of Oracle Developer Tools for Visual Studio (11.1.0.7.10), including new features such as the AQ designers, user/role management, and performance-tuning tools.

Who this book is for

This book is aimed at .NET developers looking for a comprehensive guide to ODP.NET and its latest features. The book will also appeal to those looking to optimize their OPD.NET applications by applying the best design patterns and other practices.

Comments

Amazing Books

Thrombolytic Therapy for Stroke

Humana Press, 2001

The world's leading experts detail the basic rationale, scientific evidence, and treatment protocol for thrombolytic therapy in acute stroke patients. These experienced clinicians show how promptly delivered thrombolysis can restore cerebral blood flow in time to salvage brain and neurologic functions, first by reviewing the preclinical...

Gene Therapy for Cancer (Cancer Drug Discovery and Development)

Humana Press, 2007

The three sections of this volume present currently available cancer gene therapy techniques. Part I describes the various aspects of gene delivery. In Part II, the contributors discuss strategies and targets for the treatment of cancer. Finally, in Part III, experts discuss the difficulties inherent in bringing gene therapy treatment for...

SQL Anywhere Studio 9 Developer's Guide (With CD-ROM)

Wordware Publishing, 2004

There’s a good reason that SQL Anywhere has over 70% of the mobile database
market. In fact, there are several good reasons: It’s easy to use, easy to administer,
and it doesn’t take up much space. Those are all good things if you’re trying
to deploy hundreds or thousands of databases. And they’re good...

Creating Your First Web Site with Frontpage 2000 (Cliffs Notes)

IDG Books, 2000

We live in exciting times. The Internet has revolutionized communication, and the World Wide Web reaches into millions of homes and businesses 24 hours a day, 7 days a week. Creating a Web site gives you unparalleled power to express your ideas. Think about that for a minute. Everyone connected to the Internet with access to a Web browser —...

Mathematics of Uncertainty: Ideas, Methods, Application Problems

Springer, 2005

"Mathematics of Uncertainty" provides the basic ideas and foundations of uncertainty, covering the fields of mathematics in which uncertainty, variability, imprecision and fuzziness of data are of importance. This introductory book describes the basic ideas of the mathematical fields of uncertainty from simple interpolation to...

Sams Teach Yourself OpenOffice.org All In One

Sams Publishing, 2003

An alternative for Microsoft Office and StarOffice users has arrived in the form of OpenOffice.org. If you are part of the growing number of people who are making the switch from Microsoft Office or StarOffice to the free OpenOffice.org 1.1 suite, Sams Teach Yourself OpenOffice.org All In One is a must-have tool....