Oracle
New Versions of ODBC Drivers: Oracle, PostgreSQL, QuickBooks, xBase
New versions of ODBC drivers for Oracle, PostgreSQL, QuickBooks were released with improved compatibility with Power Pivot, Visual Basic, and RStudio.
The compatibility with...
Migrating Data From Oracle to PostgreSQL
In the article, you will learn how to migrate table data from Oracle to PostgreSQL using the dbForge tools.
New Features in dotConnect for Oracle 9.11
Devart is glad to announce the new version of our ADO.NET provider for Oracle with advanced ORM support - dotConnect for Oracle 9.11....
Entity Framework 6.3 and .NET Core 3 Support
.NET Core 3
.NET Core was presented by Microsoft in 2016, but its 1.x versions had limited set of features comparing to Full .NET Framework....
Generating subscription statistics data in Oracle Data Generator
When you need to fill your databases with data for testing purposes, it’s usually quite handy to also have this data follow dynamic patterns...
Achieve Enterprise-level Productivity with dbForge Studio for Oracle!
We are thrilled to inform our Oracle users that dbForge Studio for Oracle got a really massive update that took database development and presentation...
New Look and Feel of Compare Bundle for Oracle
We are glad to announce the release of the updated dbForge Compare Bundle for Oracle. The tools of the Bundle, dbForge Schema Compare for...
Create Unique Generators with dbForge Data Generator 2.0!
We are glad to notify our users that a new version of the Devart Oracle data generation tool has been released - dbForge Data...
Keep Calm and Document Oracle Databases
We are thrilled to inform that our dbForge for Oracle product line has been expanded with a brand new tool for smart and easy...
JSON Support in Entity Framework v4 – v6 in dotConnect for Oracle, MySQL, and PostgreSQL
Recent versions of MySQL and PostgreSQL databases provide JSON functionality support. They introduced special data types, storing JSON data - json data type in...
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...
