Oracle DataAccess is a Windows dynamically linked library that is intended for exchanging information with remote and local Oracle databases. The utility provides a high performance native data access layer for software developers. Please note that NET Framework is required for the correct functioning of all features.

Main purpose

Users can implement various common ADO.NET interfaces with the help of the embedded data provider. Moreover, it is possible to work with such classes as IDbConnection, IDbCommand, IDataReader and DataSet. There are tools for enabling .NET apps to execute SQL statements, stored procedures and PL blocks against Oracle databases. An option to manually retrieve source information is available as well.

Visual Studio extension

This module is intended for integrating OODP.NET with the popular development environment from Microsoft. There is a server explorer for browsing and managing Oracle objects like tables, views, procedures, functions, packages, triggers and types. Developers can use SQL scripts to manipulate the data.

The Entity Framework window lets you create EDMs based on source database schemas. Instruments for performing object relational mapping between classes and tables are provided.

Features

free to download and use;
offers you tools for developing .NET applications;
makes it possible to connect to remote and local Oracle databases;
compatible with all modern versions of Windows;
users can manage tables, procedures, packages, triggers and other database elements.