Book description
This book is a comprehensive and easy-to-understand guide for using the Oracle Data Provider (ODP) version 11g on the .NET Framework.
Table of contents
- Copyright
- About the Author
- About the Technical Reviewer
- Acknowledgments
- 1. Introduction to Oracle .NET Connectivity
-
2. ODP.NET: A Functional Overview
- 2.1. Exploring Oracle Features Accessible in ODP.NET Version 9
-
2.2. Accessing Oracle Features from ODP.NET Version 10
- 2.2.1. Supporting Oracle Grids
- 2.2.2. Supporting Multiple Oracle Homes
- 2.2.3. Using Floating Point Data Types
- 2.2.4. Using Statement Caching
- 2.2.5. Supporting Command Cancellation and Timeout
- 2.2.6. Retrieving Parameters Programmatically
- 2.2.7. Supporting .NET Stored Procedures
- 2.2.8. Using Client Identifiers
- 2.2.9. Using Database Change Notifications
- 2.2.10. Managing Connection Pools
- 2.2.11. Optimizing Connection Pools for RAC
- 2.2.12. Using a REF Cursor as an IN/OUT Parameter
- 2.2.13. Using 64-bit ODP.NET
- 2.2.14. Controlling the FetchSize Property
- 2.2.15. Configuring ODP.NET
-
2.3. Accessing Oracle Features from ODP.NET Version 11
- 2.3.1. Enhancing Performance
- 2.3.2. Deploying ODP.NET Using xcopy
- 2.3.3. Supporting Oracle User Defined Types (UDTs)
- 2.3.4. Performing Bulk Copy Operations
- 2.3.5. Using Windows Authenticated User Connections Pooling
- 2.3.6. Publishing Connection Pool Performance Counters
- 2.3.7. Supporting Self-Tuning for Applications
- 2.3.8. Using Oracle Streaming AQ
- 2.3.9. Supporting Promotable Local Transactions
- 2.3.10. Using ODP.NET Security Enhancements
- 2.3.11. Running Callbacks for HA Event Notifications
- 2.3.12. Starting Up and Shutting Down Databases
- 2.4. Getting Started
- 2.5. Summary
-
3. Connecting to Oracle with ODP.NET
- 3.1. Connecting via TNS
- 3.2. Understanding the TNSNames.ora file
- 3.3. Connecting in Other Ways
- 3.4. Learning the ODP.NET Connection Parameters
- 3.5. Checking Whether ODP.NET Is Installed
- 3.6. Dynamically Building an ODP.NET Connection String
- 3.7. Understanding Transparent Application Failover
- 3.8. Summary
-
4. Retrieving and Manipulating Data with ODP.NET
- 4.1. Understanding ODP.NET Data Types
- 4.2. Creating a Sample Table
- 4.3. Retrieving Multiple Rows of Data
- 4.4. Retrieving a Single Value
- 4.5. Handling NULL Values in ODP.NET
- 4.6. Retrieving Data into a Dataset
- 4.7. Using Parameterized Queries
- 4.8. Updating Data
- 4.9. Handling Master-Detail Relationships
- 4.10. Manipulating LOBs and BFILEs
- 4.11. Manipulating RAW Data Types
- 4.12. Creating Automatically Incrementing Columns
- 4.13. Executing DDL from ODP.NET
- 4.14. Discovering Schema in ODP.NET
- 4.15. Handling ODP.NET Exceptions
- 4.16. Summary
-
5. Using PL/SQL and .NET CLR Stored Procedures with ODP.NET
- 5.1. Understanding the Basics of PL/SQL
- 5.2. Working with Anonymous PL/SQL Blocks
- 5.3. Working with PL/SQL Stored Procedures
- 5.4. Executing a PL/SQL Function
- 5.5. Handling Special IN and OUT Data Types
- 5.6. Handling Custom-Defined PL/SQL Errors
- 5.7. Creating Your First .NET CLR Stored Procedure
- 5.8. Summary
-
6. ODP.NET Globalization
- 6.1. Storing and Retrieving Double-Byte Data
- 6.2. Using the OracleGlobalization class
- 6.3. Changing the Session Language
- 6.4. Formatting Calendar Dates
- 6.5. Representing Currencies
- 6.6. Formatting Numbers
- 6.7. Dealing with Time Zones
- 6.8. Sorting and Comparing Strings
- 6.9. Applying Country-Based Formatting
- 6.10. Safely Mapping to .NET Data Types
- 6.11. Summary
- 7. Transactions with ODP.NET
-
8. Oracle Database Change Notifications with ODP.NET
- 8.1. Understanding Database Change Notification
- 8.2. Registering for Query-Based Change Notifications
- 8.3. Registering for Object-Based Change Notifications
- 8.4. Grouping Multiple Notification Requests
- 8.5. Removing a Registration
- 8.6. Retrieving Change Notification Information
- 8.7. Choosing to Poll
- 8.8. Considering Typical Usage Scenarios
- 8.9. Thinking About Performance
- 8.10. Summary
- 9. Using Oracle Database Streams Advanced Queuing with ODP.NET
-
10. Oracle XML Support
- 10.1. Accessing Native XML Data (XMLTYPE)
- 10.2. Passing XML Data to and from PL/SQL Stored Procedures
- 10.3. Validating Against XML Schema
- 10.4. Using XSLT to Transform XML Data
- 10.5. Retrieving Relational Data as XML
- 10.6. Manipulating Relational Data as XML
- 10.7. Using XQuery to Query Data
- 10.8. Summary
-
11. ODP.NET Security Features
- 11.1. Securing Your .NET Applications
- 11.2. Authenticating Data
- 11.3. Understanding Code Access Security
- 11.4. Configuring CAS Policies
- 11.5. Requesting Permissions
- 11.6. Ensuring That an Assembly Can Never Access Oracle
- 11.7. Using CAS with ASP.NET Applications
- 11.8. Implementing Best Practices
- 11.9. Summary
-
12. ODP.NET Performance
- 12.1. Measuring Performance
- 12.2. Speeding Up Connections with Connection Pooling
- 12.3. Performing Faster Floating Point Arithmetic
- 12.4. Executing Statements Faster
- 12.5. Passing Parameters More Efficiently
- 12.6. Managing LOBs More Efficiently
- 12.7. Retrieving Data More Efficiently
- 12.8. Importing Data More Efficiently
- 12.9. Applying Optimization Best Practices
- 12.10. Summary
- 13. Design Patterns and Considerations in Using ODP.NET
- 14. ODT.NET Tool Basics
- 15. Building Data-Driven Applications with ODT.NET
Product information
- Title: Pro ODP .NET for Oracle Database 11g
- Author(s):
- Release date: April 2010
- Publisher(s): Apress
- ISBN: 9781430228202
You might also like
book
Oracle Database 11g Performance Tuning Recipes: A Problem-Solution Approach
Performance problems are rarely "problems" per se. They are more often "crises" during which you're pressured …
book
ASP.NET 3.5 Unleashed
is the most comprehensive book available on the Microsoft ASP.NET 3.5 Framework, covering all aspects of …
book
Microsoft® .NET Compact Framework (Core Reference)
The Microsoft® Windows® .NET Compact Framework brings the power of the .NET Framework to handheld devices …
book
Data-Driven Services with Silverlight 2
This comprehensive book teaches you how to build data-rich business applications with Silverlight 2 that draw …