Software

Build a .NET Application on the Oracle Database With Visual Studio 2005 or 2008

Download Now 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. With Oracle Developer Tools for Visual Studio, one can accomplish almost everything they need in development lifecycle without having to leave Visual Studio to use another tool. For creating a role for the application that represents the privileges requires to access the database objects the application uses. Using Oracle roles is a good way to ensure that application users have the correct privileges. For creating an Oracle Database Project, one would need to store the SQL scripts for the Oracle Database schema objects the application uses and eventually check them into source control along with the application. This will allow other developers who obtain the application code to also check out and run the SQL scripts to create the Oracle schema objects the application requires. The main performance tuning feature provided by Oracle Developer Tools for Visual Studio is Oracle Performance Analyzer. One can launch it 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.

  • Format: HTML
  • Size: 0 KB