Data Management

The Full Set

Free registration required

Executive Summary

Building a .NET application that accesses Oracle Database involves a variety of tasks besides writing .NET code: creating users and roles, creating tables and table data, generating SQL scripts and checking them into source control, and performance tuning,. This article builds a .NET application with Oracle Database and step by step sees through the development lifecycle. The set up is done with oracle applications. To connect to Oracle Database from Visual Studio, create a connection in Server Explorer. Then create a new User with User Designer. Following this some basic privileges have to be granted. The next step is Importing Tables and Table Data. The main performance tuning feature provided by Oracle Developer Tools for Visual Studio is Oracle Performance Analyzer. It can be launched by clicking a SYSDBA connection in Server Explorer and choosing Oracle Performance Analyzer from the context menu. It monitors the use of the database under load and provides performance-improving recommendations, some of which can be implemented automatically. This paper also explains Debugging the Application's PL/SQL. Debugging the PL/SQL one's application uses is a very important part of the application lifecycle. When users check out SQL scripts from source control, they will be able to run them (using a built-in SQL*Plus execution engine) by right-clicking and selecting Run from the context menu. This will ensure that the database schema matches the one required by the application.

  • Format: HTML
  • Size: 0 KB