|Oracle® Database Express Edition 2 Day Plus .NET Developer Guide
10g Release 2 (10.2)
Part Number B25312-01
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.
Dynamic help available within Visual Studio .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.
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.
Oracle Database Extensions for .NET has the following features:
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.
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.
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.