Friday, March 29, 2024

Oracle

Oracle 12c Support and More New Features in New Versions of Devart Products

Devart releases new versions of its products: LinqConnect ORM solution, dotConnect ADO.NET data providers, and ORM designer - Entity Developer. The main new feature...

Enhanced Entity Framework Spatials support for Oracle, MySQL and PostgreSQL

Entity Framework v5 and v6 support spatial data types. They are represented as two DbGeometry and DbGeography data types from System.Data.Entity.dll in .NET Framework...

Using Entity Framework Spatials with Oracle Spatial and SharpMap

Note The information in this article is partially outdated. For the newer information see the Enhanced Entity Framework Spatials support for Oracle, MySQL and PostgreSQL...

Using Oracle Full-Text Search in Entity Framework

Introduction Oracle database supports an advanced functionality of full-text search (FTS) called Oracle Text, which is described comprehensively in the documentation: Oracle® Text Application Developer's...

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...

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....

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...

Set Identity and Computed Properties in Entity Framework Without Triggers

This article deals with the following: StoreGeneratedPattern Identity Computed DefaultValue InsertNullBehaviour Example Conclusion StoreGeneratedPattern Entity Framework contains an excellent functionality of server-generated columns of the entity...

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...

Comparing Diffs Between Two Oracle Database Schemas

The article defines main requirements for a tool for Oracle schema comparison (Database Diff tool), provides brief report on different tools offering such functionality, and analyses their shortcomings and advantages.

How To Configure Oracle Instant Client

This article is a step-by-step instruction for configuring Oracle Instant Client so that our tools for Oracle could work with it. 1. Download Oracle Instant...

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...

Entity Framework: SQL Generation Enhancements for IN Clause

Introduction Collection with unique elements Two and more collections with the repeated elements Optimization of the query without obvious collection Oracle-specific SQL The...

Loading Oracle LOB Data – Code Samples

Recently we were working over the release of the version 2.0 of  dbForge Data Compare for Oracle. One of the main features added to...

Oracle DBMS_COMPARISON package overview

This article describes how to set up table data comparison by help of Oracle package and synchronize data in case of differences.

10 Ways to Synchronize Oracle Table Data

The article describes such ways of data synchronization of Oracle databases as Advanced Replication, Oracle Streams, GoldenGate. Also it gives a brief comparison of shortcomings and benefits of each way for data comparison and synchronization tasks when developing and testing databases.

How To: Disable All Foreign Keys in Oracle Scheme

When you perform data maintenance operations, sometimes, it's necessary to disable or enable all foreign keys in the user schema. Here is the script that...

Devart Unveils Free Data Compare Tool for Oracle to Bring High Speed and Adjustable Comparison

Devart today unveiled a new data comparison tool, dbForge Data Compare for Oracle. It delivers automatic data comparison in Oracle databases, provides a convenient...

How To: Kill User Sessions in Oracle

This article explains how to kill users' sessions before recreating Oracle schemas.

dbForge Data Compare for Oracle: new life to the product line

Recently our development efforts were focused on dbForge for SQL Server product line. We've made five major releases of SQL Server database tools in last 18 months. Besides, we've made two major releases of MySQL database tools in this period. Our Oracle database tools product line, once actively developed, was frozen for almost three years. Sure we made maintenance releases, but no new features and tools. Our Oracle tools even were not re-branded to dbForge for Oracle. But now we decided to breeze the new life into Oracle tools development.

Dynamic Database Creation in Entity Framework

Entity Framework 4 RC allows you to create and drop databases in run-time using SSDL for DDL generation. Now ObjectContext has CreateDatabase(), DropDatabase(), and...

Entity Framework 4 Release Candidate supported!

We have supported new functionality of Entity Framework 4 including Entity Framework v4 Release Candidate for dotConnect for Oracle, dotConnect for MySQL, dotConnect for...

Entity Framework and IdeaBlade

Our active user, Simon Kingaby, in his own blog has described experience of the web-based enterprise applications development by help of the following technologies:...

NHibernate and Oracle Database via dotConnect

NHibernate is an ORM solution moved from Java to Microsoft .NET. It allows mapping application objects to relational database. NHibernate automatically generates SQL code...

Data Comparison Methods and Techniques

Data comparison is a difficult and resource-intensive process. In the article, we are going to explore algorithms, advantages, and disadvantages of specific data comparison,...

Entity Framework Canonical Functions

Article was updated on 3/4/2010 This article can be useful for programmers who want to develop cross-database applications and use the canonical functions. Entity Framework Canonical...

Working with Oracle cursors and stored procedures in Entity Framework

Users often ask us how to use Oracle stored routines, returning REF CURSORs, in Entity Framework models with dotConnect for Oracle. So, we decided...

Social

Products