Oracle Upgrades, Expands .NET Offerings

Oracle is giving its .NET tools an upgrade and adding a new one to the portfolio.

The database giant today is releasing beta versions of the free tools intended to provide Visual Studio developers improved access to the Oracle 10g database with some capabilities that take advantage of its forthcoming Oracle 11g database due out by year's end.

The tools the company is upgrading include Oracle Data Provider for .NET, known as ODP.NET, and Oracle Developer Tools for Visual Studio.NET. The new tool added to the suite is a data provider for ASP.NET development. Oracle is releasing the betas at Microsoft's TechEd conference in Orlando, where it is also demonstrating the new tools.

While the company is not saying when it will make the new tools generally available, officials describe the betas as ready for use in development environments. "It's a very high quality beta, so people can start using the Visual Studio tools immediately," says Christian Shay, an Oracle product manager for .NET and Windows technology.

ODP.NET provides rich access to the Oracle database from the .NET environment, notably Visual Studio 2005. The data provider lets developers access key functions of Oracle's database such as Real Application Clusters, XML DB and security feature in any .NET language including C# and Visual Basic .NET.

The key new feature in ODP.NET is user-defined types, which allow developers to construct abstract data types so they can treat them as a single entity. For example if a developer is creating a person as a data type, instead of having to pass around that person's name, address, telephone number as data types, the developer can pass it around as a whole entity, says Alex Keh, another Oracle product manager.

"That way it becomes much more manageable, much easier for developers to work with data when they can treat it as a collective entity as opposed to individual constituent parts," he says.

Among other new features Oracle is adding to ODP.NET include improved client access, support for pooling of Windows-authenticated user connections and the inclusion of connection pool status monitors.

Keh said the new release will support in excess of a 5x query performance improvement against Oracle's forthcoming Oracle 11g database. Key said Oracle will achieve that by taking advantage of new caching technology in the database, in beta since last October.

Oracle is also updating its Oracle Developer Tools for Visual Studio .NET adding full support for Visual Studio 2005. That will let developers take advantage of drag and drop code generation from the data sources window in Visual Studio 2005, as well as the data set designer, and the table adaptor configuration wizard 2005.

That will let developers automatically generate .NET code, minimizing the amount of coding, they have to do allowing them to more rapidly generate applications, Shay said, adding that Oracle is also targeting ASP.NET developers with this release.

"Our goal with this release is to make it easy for ASP.NET developers to rapidly generate Web applications without having to write very much SQL or .NET code," Shay said.

To increase usability, Oracle has added the ability to explain execution plans on SQL statements, so that people can tune their SQL statements without having to leave visual studio. The tools also integrate with Microsoft Query Designer.

The new tool in the suite, the data providers for ASP.NET, allows developers to build code that can store session state easily within the Oracle database, according to Keh. The new tool provides support for eight providers including membership roles, Web events, and personalization information.

Developers can download the betas from the Oracle Technology Network at

About the Author

Jeffrey Schwartz is editor of Redmond magazine and also covers cloud computing for Virtualization Review's Cloud Report. In addition, he writes the Channeling the Cloud column for Redmond Channel Partner. Follow him on Twitter @JeffreySchwartz.


  • Microsoft Hires Movial To Build Android OS for Microsoft Devices

    Microsoft has hired the Romanian operations of software engineering and design services company Movial to develop an Android-based operating system solution for the Microsoft Devices business segment.

  • Microsoft Ending Workflows for SharePoint 2010 Online Next Month

    Microsoft on Monday gave notice that it will be ending support this year for the "workflows" component of SharePoint 2010 Online, as well as deprecating that component for SharePoint 2013 Online.

  • Why Windows Phone Is Dead, But Not Completely Gone

    Don't call it a comeback (because that's not likely). But as Brien explains, there are three ways that today's smartphone market leaves the door open for Microsoft to bring Windows back to smartphones.

  • Feature Update Deferral Mix-Up in Windows 10 Version 2004 Further Explained

    Microsoft last week described the confusion it is attempting to avoid by removing the client graphical user interface (GUI)-based controls to defer Windows 10 feature updates, starting with version 2004.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.