Contents

List of Examples

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

1 Introduction

• What is Microsoft .NET Framework
• Introduction to Oracle Data Provider for .NET
• Introduction to Oracle Developer Tools for Visual Studio .NET
• Introduction to .NET Stored Procedures

2 Installing Oracle Developer Tools

• What You Need
• Installing Oracle Developer Tools
• Unlocking the User Account
• Uninstalling Oracle Developer Tools

3 Connecting to the Database

• Starting a New Project
• Adding a Reference
• Adding Initial Programmatic Statements
• Adding Connection Elements
• Using the Connection Object
• Running the Application
• Error Handling
• Closing the Database Connection

4 Building an Oracle Data Provider for .NET Application

• Copying a Project
• Using the Command Object
• Retrieving Data: a Simple Query
• Retrieving Data: Bind Variables
• Retrieving Data: Multiple Values
• Using the DataSet Class with Oracle Data Provider for .NET
• Inserting, Deleting and Updating Data

5 Using Oracle Developer Tools for Visual Studio .NET

• Connecting to the Oracle Database
• Creating a Table and Its Columns
• Creating a Table Index
• Adding Table Constraints
• Adding Data to a Table
• Generating Code Automatically
• Enabling Database Updates

6 Using PL/SQL Stored Procedures and REF Cursors

• Introduction to PL/SQL Packages and Package Bodies
• Introduction to PL/SQL Stored Procedures
• Introduction to Ref Cursors
• Creating a PL/SQL Stored Procedure that Uses Ref Cursors
• Running a PL/SQL Stored Procedure Using Oracle Data Provider for .NET

7 Deploying .NET Stored Procedures

• Starting the Common Language Runtime Service
• Creating an Oracle Project
• Creating a New Connection
• Creating .NET Stored Functions and Procedures
• Deploying .NET Stored Functions and Procedures
• Running .NET Stored Functions and Procedures

8 Including Globalization Support

• Introduction to Global Applications
• Developing Global Applications with the .NET Framework
• Presenting Data in the Correct User Local Convention
• • Oracle Date Formats
  • Oracle Number Formats
  • Oracle Linguistic Sorts
  • Oracle Error Messages
• Synchronizing the .NET and Oracle Database Locale Environments
• Client Globalization Support in Oracle Data Provider for .NET
• • Client Globalization Settings
  • Session Globalization Settings
  • Thread-Based Globalization Settings

Index