Skip to Main Content
Pro ODP .NET for Oracle Database 11g
book

Pro ODP .NET for Oracle Database 11g

by Edmund Zehoo
April 2010
Intermediate to advanced content levelIntermediate to advanced
468 pages
10h 31m
English
Apress
Content preview from Pro ODP .NET for Oracle Database 11g

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, ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

ASP.NET 3.5 Unleashed

ASP.NET 3.5 Unleashed

Stephen Walther
Microsoft® .NET Compact Framework (Core Reference)

Microsoft® .NET Compact Framework (Core Reference)

Andy Wigley, Stephen Wheelwright, Robert Burbidge, Rory MacLoed, Mark Sutton
Professional C# 5.0 and .NET 4.5.1

Professional C# 5.0 and .NET 4.5.1

Christian Nagel, Jay Glynn, Morgan Skinner

Publisher Resources

ISBN: 9781430228202Purchase book