Pro ODP.NET for Oracle Database 11g

ISBN-13: 9781430228202 / Angielski / Miękka / 2010 / 468 str.

Edmund Zehoo

Opis

In this chapter, you've taken a look at some of the various ways you can use to connect to an Oracle database via ODP.NET: TNS connections Connections without using TNSNames.ora Oracle's EZConnect You've also seen how you can use various connection string parameters to implement connection pooling, integrated Windows authentication, and connections with special privileges. Last, we covered the basic groundwork on TAF and its limitations and how you can ultimately enable it in your application. In the next chapter, you will take a step further and write code to transact with the Oracle database. 67 C H A P T E R 4 Retrieving and Manipulating Data with ODP.NET I was once told during a technical workshop filled with geeky programmers that "an enterprise application is only as strong as its data tier." The programmers loved catchy phrases like that. I'm not sure how true that rings, but I can definitely agree with the most of them that if you don't know your database well enough, you're going to build underperforming routines that the remaining 70 percent of your application will unfortunately be based on.

Spis treści

1. Introduction to Oracle .NET Connectivity
2. ODP.NET: A Functional Overview
3. Connecting to Oracle with ODP.NET
4. Retrieving and Manipulating Data with ODP.NET
5. Using PL/SQL and NET CLR Stored Procedures with ODP.NET
6. ODP.NET Globalization
7. Transactions with ODP.NET
8. Oracle Database Change Notifications with ODP.NET
9. Using Oracle Database Streams Advanced Queuing with ODP.NET
10. Oracle XML Support
11. ODP.NET Security Features
12. ODP.NET Performance
13. Design Patterns and Considerations in Using ODP.NET
14. ODP.NET Tool Basics
15. Building Data-Driven Applications with ODP.NET

O autorze

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.