ODP.NET is just part of a family of .NET development components for Oracle database. Other major Oracle .NET products include Oracle Developer Tools for Visual Studio (ODT), Oracle Providers for ASP.NET, and Oracle Database Extensions for .NET.
ODP.NET supports the Microsoft Visual Studio 2008 and .NET Framework 3.5, compliant with ADO.NET 1.x and higher. ODP.NET will support Microsoft Visual Studio 2010 and .NET Framework 4 soon after their release. ODP.NET is fully integrated into Visual Studio so that it can auto-generate data access code for your Oracle .NET applications.
ODT is a tightly-integrated add-in for Microsoft Visual Studio which enhances .NET developer productivity. Programmers can automatically generate ODP.NET code; edit data and the Oracle schema; manage users and roles; edit and debug PL/SQL; automatically generate and edit Oracle SQL and PL/SQL scripts and check them into source control. Visual Studio 2008, 2005, and 2003 are all supported.
Oracle Providers for ASP.NET store web application state in the Oracle database to ensure high availability of application data, while making the data equally available to all web servers. For .NET developers already familiar with ASP.NET providers, the Oracle Providers for ASP.NET are easy to learn and use as they share a common schema and API with existing ASP.NET providers. They integrate seamlessly with existing ASP.NET services and controls, similar to other ASP.NET providers. Oracle offers the following providers:
Site Map Provider
Session State Provider
Web Events Provider
Web Parts Personalization Provider
Cache Dependency Provider
Oracle Database Extensions for .NET is an Oracle Database option on Windows that makes it easy to develop, deploy, and run stored procedures and functions written in a .NET managed language, such as C# or Visual Basic.