Skip Headers
Oracle® Database Express Edition 2 Day Plus .NET Developer Guide
10g Release 2 (10.2)

Part Number B25312-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
View PDF

1 Introduction

This chapter provides a brief description of Oracle technologies for the Microsoft .NET Framework.

This chapter contains the following sections:

This book is conceived as a quick start guide, to describe the key features of Oracle Data Provider for .NET and Oracle Developer Tools for Visual Studio .NET. It leads you through installation and configuration, shows how to build basic applications using Oracle Data Provider for .NET and Oracle Developer Tools for Visual Studio .NET, and how to create and use both PL/SQL and .NET stored procedures.

After working through this book, you will be ready to continue with more extensive information available in the Oracle Database documentation library.

See Also:

What is Microsoft .NET Framework

The Microsoft .NET Framework, .NET, is a multi-language environment for building, deploying, and running XML Web services and applications. Its main components are:

Common Language Runtime

Common Language Runtime, or CLR, is a language-neutral development and run-time environment that provides services that help manage running applications

Framework Class Libraries

The Framework Class Libraries, or FCL, provide a consistent, object-oriented library of prepackaged functionality.

Introduction to Oracle Data Provider for .NET

Oracle Data Provider for .NET (ODP.NET) provides data access from .NET client applications to Oracle databases. ODP.NET data access is fast, efficient, and includes access to other Oracle Database features.

Introduction to Oracle Developer Tools for Visual Studio .NET

Oracle Developer Tools for Visual Studio .NET is a set of application tools that are integrated with the Visual Studio .NET environment. These tools provide graphical user interface access to Oracle functionality, enable the user to perform a wide range of application development tasks, and improve development productivity and ease of use. Oracle Developer Tools support the programming and implementation of .NET stored procedures using Visual Basic, C#, and other .NET languages.

Oracle Developer Tools include the Oracle Explorer for browsing the Oracle schema, designers and wizards to create and alter schema objects, and the ability to drag and drop schema objects onto a .NET form to automatically generate code. Additional features include a PL/SQL editor with integrated context-sensitive dynamic help, and an Oracle Data Window for performing routine database tasks like inserting and updating data or testing stored procedures in the Visual Studio environment. For maximum flexibility, there is also an Oracle Query Window for executing SQL statements or PL/SQL scripts.

Introduction to .NET Stored Procedures

Oracle Database Extensions for .NET has the following features:

Common Language Runtime Host for Oracle Database

The Oracle Database on Windows hosts the Microsoft Common Language Runtime (CLR). The integration of Oracle Database with CLR enables applications to run .NET stored procedures or functions on Oracle Database with Microsoft Windows Server 2003, Windows 2000, and Windows XP.

Data Access for .NET Classes through Oracle Data Provider for .NET

Using Microsoft Visual Studio .NET, you can build .NET procedures or functions into a .NET assembly. All .NET stored procedures and functions use ODP.NET to access data.

Oracle Deployment Wizard for Visual Studio .NET

After building .NET procedures and functions into a .NET assembly, deploy them in Oracle Database using the Oracle Deployment Wizard for .NET, a component of the Oracle Developer Tools for Visual Studio .NET.