Skip Headers
Oracle® Database Express Edition 2 Day Plus .NET Developer Guide
10
g
Release 2 (10.2)
Part Number B25312-01
Home
Book List
Index
Master Index
Contact Us
Next
View PDF
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