Geeks With Blogs


Bill Evjen's Blog Code, Life and Community

Oracle Technology Network

Oracle just released its latest version of ODP.NET. This version, for Oracle 11g, provides enhancements and the much anticipated Instant Client and User Defined Types (UTDs). One big issue in the past when you were working with ODP.NET for your ASP.NET applications was that you had to install a tremendously large Oracle client application that took some time. Now with the instant client, you simply XCopy your client to the server you want it at. Very easy. UDTs was also another feature that allows you to pass custom types into the database and step away from the need to use numerous ref cursors.

ODP.NET includes the ASP.NET providers that you might be looking for including:

  • Membership Provider
  • Role Provider
  • Profile Provider
  • Session State Provider
  • Site Map Provider
  • Web Parts Personalization Provider
  • Web Event Provider
  • Cache Dependency Provider

This version works with the .NET Framework 2.0, 3.0, and 3.5. You will be able to use it with Visual Studio 2005 and 2008. Oracle also includes a Visual Studio kit of items that allow you to easily work with the database directly from Visual Studio.

The newest features from the Oracle site state the following:

  • Instant Client Support: Smaller ODP.NET client and xcopy installation
  • User-Defined Types: Map Oracle objects, collections, and REFs to .NET custom types
  • ADO.NET 2.0 Bulk Copy: Upload large data sets into Oracle from .NET
  • Process Database Down Events: ODP.NET automatically frees connections to a downed Data Guard instance
  • Windows-Authenticated User Connection Pooling: Windows users can now use ODP.NET connection pooling
  • Connection Pool Performance Counters: Monitor connections and connection pool status
  • End-to-End Tracing using Action and Module attributes

You can look to download this version at

Posted on Thursday, January 10, 2008 11:58 PM | Back to top

Comments on this post: New Version of ODP.NET Released

# re: New Version of ODP.NET Released
Requesting Gravatar...
buen producto
Left by carolina on Feb 27, 2008 9:50 AM

# re: New Version of ODP.NET Released
Requesting Gravatar...
It is good sound
Left by Ravi Kumar on Sep 16, 2009 12:28 PM

Your comment:
 (will show your gravatar)

Copyright © Bill Evjen | Powered by: