Using Oracle Full-Text Search in Entity Framework


Oracle database supports an advanced functionality of full-text search (FTS) called Oracle Text, which is described comprehensively in the documentation:

We decided to meet the needs of our users willing to take advantage of the full-text search in Entity Framework and implemented the basic Oracle Text functionality in our Devart dotConnect for Oracle ADO.NET Entity Framework provider.
For working with Oracle Text specific functions in LINQ to Entities queries, the new OracleTextFunctions class is used, which is located in the Devart.Data.Oracle.Entity.dll assembly. It enables working with such Oracle Text functions as:


To call Oracle Text specific stored procedures of the CTX_DDL package, the OracleCtxDdlPackage class is used, which is located in the Devart.Data.Oracle.Entity.dll assembly.
To customize Code-First Migrations with the purpose of creating and deleting Oracle Text specific indexes, the CreateIndexConfiguration and DropIndexConfiguration classes are used, which are located in the Devart.Data.Oracle.Entity.Migrations.dll assembly.
This article deals with the following:


Entity Framework Code-First Migrations support for Oracle, MySQL, PostgreSQL and SQLite

ADO.NET EF providers Devart dotConnect for Oracle, dotConnect for MySQL, dotConnect for PostgreSQL, and dotConnect for SQLite implement support for Entity Framework 4.3 Beta 1 (Entity Framework Code-First Migrations). To use it in your applications, you need to download and install the corresponding Entity Framework NuGet package first. You can read about Entity Framework Code-First Migrations functionality in the corresponding MSDN articles. (more…)

Using Oracle Optimizer Hints in Entity Framework

With each new version of our Devart dotConnect for Oracle ADO.NET Entity Framework provider we pay special attention to improving its performance and configurability. It is pertinent to note some recent improvements: batch updates and flexible customization of Oracle Entity Framework provider behaviour. And now we are glad to present Oracle optimizer hints support in Entity Framework – a new feature for flexible tuning of SQL queries, generated by a user application.

Oracle Optimizer Hints

Oracle supports more than 60 different Oracle optimizer hints. You can see the complete list of Oracle optimizer hints and recommendations on their use in the Oracle Database documentation.

It is better to perform query optimization in external application, such as Devart dbForge Studio for Oracle, or any other tool for Oracle that you prefer. Queries, generated by Entity Framework, can be traced with dbMonitor and then copied and pasted to your SQL development application, where you can evaluate query performance, study execution plan, and choose optimizer hints to use. (more…)

Devart is glad to release the new improved version of dbForge Studio for Oracle, v 3.1

We’ve analyzed user feedbacks received after the release of the completely redesigned dbForge Studio and defined prior points for further development of the product.

As a result, we’ve devoted the new release of dbForge Studio for Oracle to improve the possibilities for users who work with PL/SQL code and data. And in addition, we’ve improved the application performance and added support for the Win-x64 platform. (more…)

Workflow Foundation Support in dotConnect for Oracle

We continue to extend the capabilities of dotConnect for Oracle with new features. Recently we have started to implement Workflow Foundation support features in dotConnect for Oracle. First we have implemented Oracle Workflow Instant Store support. This feature allows workflows to persist their state information in the Oracle database. dotConnect for Oracle provides the scripts for creating schema to store workflow instance state information in and the OracleWorkflowInstanceStore class that is used to persist workflow instance state information.

Currently only Enabling Persistence for Self-Hosted Workflows that use WorkflowApplication is supported. To use Oracle Workflow Instance Store you need Oracle server 9 or higher. To know how to enable Persistence for Self-Hosted Workflows read our documentation.

Recently we have added the OracleTrackingParticipant class to support Workflow Tracking. OracleTrackingParticipant class. This class allows you to subscribe to tracking records, reflecting key events during the workflow execution, and store these records to an Oracle database. dotConnect for Oracle provides the scripts for creating schema to store TrackingRecord object information. To know how to use the OracleTrackingParticipant read our documentation.

Set Identity and Computed Properties in Entity Framework Without Triggers


This article deals with the following:


Entity Framework Code-First support for Oracle, MySQL, PostgreSQL and SQLite

April 2011 saw the release of a new version of Entity Framework 4.1; this blog article and samples of code contained in it have been correspondingly updated to match the new features that are now available.

The latest versions of Devart dotConnect for Oracle, dotConnect for MySQL, dotConnect for PostgreSQL, and dotConnect for SQLite contain the most recent version of Code-First (Code Only) support that was added in Entity Framework 4.1. One of the primary advantages of the Code-First approach is a higher level of abstraction from the database and the capability to develop applications using the domain-driven design (DDD) approach. (more…)

Comparing Diffs Between Two Oracle Database Schemas

When developing databases, we frequently need to check what changes were made to its schema, if any mistakes were made, and, if there are any, we should roll back to the working version saved in the source control system. To do this, it’s enough to compare schemas of version 1.1 and 1.2, and generate an UPDATE SCRIPT using any Database Diff tool, including our dbForge Schema Compare for Oracle.

So what functionality should be available in such tool?

Firstly, the tool should be easy-to-use and user-friendly. A user should not be obliged to learn a pile of topics in the tool documentation before using it. It should be enough to perform the following set of steps:
1) Select Source and Target
2) Select a schema or several schemas (if the tool provides such possibility) for comparison
3) Tune comparison process by checking the needed options (an optional step)
4) View comparison results
5) Tune script generation options (an optional step)
6) Generate an update script and/or execute it directly to the target database
Secondly, the tool should support comparison of all object types you might have in your schemas – otherwise, how the tool is supposed to look for differences in them? And, at last, the tool should be fast. This point is especially important for searching data differences when a comparison of several schemas is performed, or the size of the project itself is large.

Now let’s look at Oracle SQL Developer and its alternative — dbForge Schema Compare for Oracle. Both are offering schema comparison functionality.

Using Oracle and MS SQL Server in Entity Framework applications simultaneously

Some of our users that are working with Entity Framework need to combine Oracle and Microsoft SQL Server in one application. Entity Framework is a powerful ORM with cross-database possibilities, so there is nothing extraordinary in this task.

However, there is a set of pitfalls and difficulties that are not obvious at first glance.

One of our users, Paul Reynolds, has made a series of posts based on his experience for multiple database support in EF:

Preparing for Multiple Databases
Database Caveats
SSDL Adjustments
Database Agnostic LINQ to Entities

Schema Compare for Oracle is here – Early Access Preview of the new product

Having successfully released our data comparison tool for Oracle we went further by starting the new one. dbForge Schema Compare for Oracle is targeted to help database developers perform sustainable change management process. The tool is designed to:

  • compare Oracle schemes
  • analyze changes between databases
  • generate schema comparison reports
  • synchronize databases immediately or save sync scripts for later use

In order to allow our users to make changes and improve product even before the first release, we decided to publish early access preview of the dbForge Schema Compare for Oracle.

Visit product page download product and leave us a feedback.