In-Depth

Oracle Expands .NET Offerings

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

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 Tech●Ed 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. Keh 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 and 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 developers 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 http://www.oracle.com/technology/tech/dotnet/tools/index.html.

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.

comments powered by Disqus

Featured

  • VS Code Now Has Apple Silicon Builds for Native Mac Development

    Goodbye Rosetta, hello M1. Visual Studio Code has been updated with new builds that let it run natively on machines with Apple Silicon (M1), the company's own ARM64 chips.

  • Visual Studio 2019 for Mac v8.9 Ships with .NET 6 Preview 1 Support

    During its Ignite 2021 online event for IT pros and developers this week, Microsoft shipped Visual Studio 2019 for Mac v8.9, arriving with out-of-the-box support for .NET 6 Preview 1, which the company also released recently.

  • Analyst: TypeScript Now Firmly in Top 10 Echelon (Ruby, Not So Much)

    RedMonk analyst Stephen O'Grady believes TypeScript has achieved the rare feat of firmly ensconcing itself into the top 10 echelon of his ranking, now questioning how high it might go.

  • Black White Wave IMage

    Neural Regression Using PyTorch: Training

    The goal of a regression problem is to predict a single numeric value, for example, predicting the annual revenue of a new restaurant based on variables such as menu prices, number of tables, location and so on.

Upcoming Events