O'Reilly logo

Pro ODP .NET for Oracle Database 11g by Edmund Zehoo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 3. Connecting to Oracle with ODP.NET

You now have all the basic software set up to write your first ODP.NET application. In this chapter, you will explore the different ways to connect to an Oracle database using ODP.NET and the various connection parameters you can use to control ODP.NET behavior. Specifically, we will explore the following:

  • How Transparent Network Substrate (TNS) works

  • How you can build connection strings dynamically instead of hard-wiring them into your code

  • How to utilize Oracle's transparent application failover feature to build robust applications that continue to work even when database connections drop midway in your code

Connecting via TNS

Let's start this chapter by putting you right where the action is. In this section, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required