logo for smart-soft-nz.com
[?] Subscribe To This Site

XML RSS
Add to Google
Add to My Yahoo!
Add to My MSN
Subscribe with Bloglines


Home
Smartsoft Blog
Oracle Training
Oracle 9i
Oracle 10g
Oracle 11g
Oracle App Server
Oracle Utilities
Backup and Recovery
Oracle Certification
Oracle Tutorials
PL/SQL
Free SQL Tutorial
SQL
News
Oracle Resources
Oracle Secrets Signup
Oracle and .Net
Contact Us
leftimage for smart-soft-nz.com

Building .NET Applications On Oracle

Microsoft's .NET Framework is becoming increasingly popular and the various Windows platforms collectively form a market that Oracle would ignore at its peril so it's no real surprise that Oracle databases can be easily integrated with .NET enterprise applications.
Oracle provides support for .NET in the following 4 areas
  1. Oracle Database Extensions for .NET
  2. Oracle providers for ASP.NET
  3. Oracle data provider for .NET
  4. Oracle Developer Tools for Visual Studio (ODT)
Let's look at each of these in turn in a little more detail.

Oracle Developer Tools for Visual Studio (ODT)

This set of plug-ins for Visual Studio was first released by Oracle in 2005. Architecturally, ODT comprises multiple tools, each of which addresses a specific developer need.

The Oracle 11g release of the tools include a tree-like interface to Oracle databases to display schema objects and provide context-sensitive menus that launch other tools to enable the creation/modifcation of the select database object type. Other facilities provided include
  • a data window for accessing/modifying table data
  • auto code generation when database objects are added to Visual Studio forms
  • full PL/SQL editing and debugging
  • source control integration
  • an Oracle SQL script editor with an in-built SQL execution engine 
  • integrated help system
  • an SQL Query Window for running ad hoc SQL scripts
The 11g version of ODT can also be used against previous releases of Oracle running on any supported platform.

Oracle Tips & Tricks to 
SKYROCKET Your Career!

If you're not already a subscriber to Oracle Secrets Revealed, you're  missing out on a myriad of tips and techniques to help you work better, faster and smarter.  Subscribe now and ignite your career.

Oracle Data Provider for .NET (ODP.NET)

ODP.NET is the layer of code between the .NET application and the Oracle client connectivity software and provides standard ADO.NET data access as well as enabling the use of Oracle database-specific features including Active Data Guard,  VPD, RAC, XML DB, data access performance optimizations, and Real Application Clusters connection pooling.

The 11g release provides features including
  • load balancing with RAC so that any new connection is directed to the least loaded node
  • connection pooling
  • fast connection failover with RAC when a node or instance fails
  • support for SecureFiles (Oracle's file system within the database for non-data files)
  • caching of statements, results and meta data
  • PL/SQL support including stored procedures and all data types which can be mapped to .NET custom data types
  • Support for virtual private databases (VPD) and Label Security
Follow the link for a tutorial on using Oracle Data Provider for .NET with a WinForms.NET application.

Oracle Providers for ASP.NET

Oracle provides a set of providers for ASP.NET to enable the storage of the application state in the database. These providers comply with the ASP.NET 2.0 provider model. The new providers added for Oracle 11g include
  • a web event provider to manage ASP.NET health monitoring data
  • a web personalisation provider
  • a user-profile provider
  • a session state provider
  • a membership provider 
  • a site map provider
  • a role provider to mange user role information
  • cache dependency provider
Follow the link for a tutorial on using Oracle Data Provider for .NET with an ASP.NET application.

Oracle Database Extensions for .NET

The extensions by Oracle provided for .NET enable .NET procedures to be stored in the Oracle database in the same way that Java and PL/SQL procedures are stored. This means that the stored (server-side) code is no different to client-side code and can be moved from the client to the server and back again without requiring any change to the source code. Once stored in the Oracle database .NET procedures can be invoked from another .NET/PLSQL/JAVA stored procedure, from .NET application code,  from a trigger or from anywhere a call to a stored procedure or function can be made.

Slash Costs, Sky-Rocket Productivity and Reduce System Downtime with Expert Oracle Consulting and Training from Smartsoft

Take advantage of our consultants' skills honed to a fine edge over many years with myriad clients in a variety of industries and use their in-depth knowledge and wide experience to maximise the benefits and minimise the costs of your Oracle systems.

Ask us how we can help you reduce costs, boost productivity and eliminate downtime


footer for Oracle page