Business Directory, Press Releases, Jobs, Products, Services, Articles
Businesses Articles Press Releases Follow @PRcom
Press Release Pricing | News by Category | News by Country | News by US Region | Recent News | News on Your Site

Press Releases



Press Release

Receive press releases from Devart: By Email RSS Feeds:
Meet dotConnect for Oracle 8.2 with Lots of Improvements

Devart team is proud to present the new release of dotConnect for Oracle 8.2 - ADO.NET data provider for Oracle, with lots of improvements, including starting and stopping an Oracle database instance, better XMLTYPE support, DBMS_APPLICATION_INFO package support, etc.

Prague, Czech Republic, January 23, 2014 --( Devart Team is glad to announce the new release of dotConnect for Oracle 8.2 - ADO.NET data provider for Oracle with support for Entity Framework, LinqConnect (LINQ to Oracle) and Nhibernate.

The new release includes:

- LINQ to Entities Improvements:

Now, when called from LINQ to Entities, the following methods of the SqlFunctions class are converted to Oracle-specific SQL statements in runtime: Acos, Asin, Ascii, Atan, Atan2, Char, Cos, CurrentUser, DataLength, Exp, Rand, Sign, Sin, SoundCode, SquareRoot, StringConvert, Tan.

The usage of these SqlFunctions class methods provides better capabilities for creating cross-database LINQ to Entities queries, for example, queries for SQL Server and Oracle.

- Starting and Stopping Oracle Database Instance

The functionality of starting and stopping an Oracle database instance is implemented in the OracleDatabase class.

- OCI Statement Caching Support Improvements

Now OCI Statement Caching is supported when Unicode=true or "OCI Connection Pool"=True.

The new "Statement Cache Purge" connection string parameter allows to clean OCI Statement Cache when returning a connection to a pool. OCI Statement Cache can be also cleaned at any time by calling the new PurgeStatementCache() method of the OracleConnection class.


Everyone can take advantages of DBMS_APPLICATION_INFO package in order to ease the process of tracking the performance of various modules and debugging. Now, the names of executing modules or transactions in the database can be recorded with the help of this package.

With the following properties of the OracleConnection class it has become possible to record the tracking information:

Also, the SetDbmsApplicationInfo method can record several of these parameters to the database at once.

- Proxy Connection Improvements

It is now possible to specify proxy connection using the new connection string parameters "Proxy User Id" and "Proxy Password" in the OCI mode.

For the full list of the new features and improvements see the dotConnect for Oracle history page.


Devart offers a free Express edition of dotConnect for Oracle. It is available for immediate download.

The Single license starts from as little as $149.95. The full pricing policy can be found at the purchase page.

About Devart

Devart is a recognized vendor of database connectivity solutions for Microsoft .NET and Embarcadero Delphi development platforms as well as database development and management software.

Company's solutions support such databases as Microsoft SQL Server, Oracle, MySQL, PostgreSQL, InterBase, Firebird, and SQLite.

Along with database oriented software Devart offers productivity tools for Visual Studio which help developers to be empowered, stay focused, and deliver their best all the time.

For additional information about Devart, visit
Contact Information
Anastasiya Diadenko

Click here to view the list of recent Press Releases from Devart
Promote Your Business