Connecting to Oracle with ODP.NET

  • Edmund Zehoo


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


Pool Size Connection Request Port Number Special Privilege Oracle Database 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Edmund Zehoo 2010

Authors and Affiliations

  • Edmund Zehoo

There are no affiliations available

Personalised recommendations