Devart Blog

PostgreSQL

Enhanced Entity Framework Spatials support for Oracle, MySQL and PostgreSQL

Posted by on July 18th, 2013

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 4.5 (Entity Framework 5) or from EntityFramework.dll (Entity Framework 6). We have already supported Entity Framework Spatials for Oracle database (see Using Entity Framework Spatials with Oracle Spatial and SharpMap). In the new versions of our providers we have improved Entity Framework Spatials support for Oracle and added spatials support for MySQL and PostgreSQL.
(more…)

Devart to Start New Product Line for PostgreSQL

Posted by on December 25th, 2012

Devart is glad to announce the release of dbForge Data Compare for PostgreSQL — a powerful and easy-to-use tool for table data comparison and synchronization. This tool allows you to review all the differences in compared tables and execute an automatically generated script to remove these differences. Customizable comparison and synchronization process allows you to select tables and fields for comparison and adjust many comparison options. User friendly wizard, guides you through the data comparison and synchronization process step by step. A possibility of using Windows Task Scheduler enables you to automate database synchronization process. (more…)

Using PostgreSQL Full-Text Search in Entity Framework

Posted by on August 17th, 2012

Introduction

PostgreSQL database supports an advanced functionality of full-text search (FTS) and full-text indexing described comprehensively in the documentation:

Full-Text Search

We decided to meet the needs of our users willing to take advantage of the full-text search in Entity Framework and implemented the full-text search functionality in our Devart dotConnect for PostgreSQL ADO.NET Entity Framework provider.
This article deals with the following:

(more…)

Dynamic Database Creation in Entity Framework

Posted by on March 31st, 2010

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 CreateDatabaseScript() methods. They appeared in Entity Framework v4 CTP for Code Only and only for SQLClient initially but later they became available for other EF-providers.

In this article we describe implementation of these methods in Devart data providers. We are using dotConnect for Oracle as a data provider in the following examples. Northwind is used as a sample database.

(more…)

Entity Framework 4 Release Candidate supported!

Posted by on March 31st, 2010

We have supported new functionality of Entity Framework 4 including Entity Framework v4 Release Candidate for dotConnect for Oracle, dotConnect for MySQL, dotConnect for PostgreSQL, and dotConnect for SQLite. In this article we consider basic new supported possibilities in comparison with Entity Framework v1. Take into account that the new features of Entity Framework v4 like Persistence Ignorance (POCO), Self-tracking entities, Code Only etc. which don’t require support of the provider writers aren’t described here.

(more…)

Entity Framework Canonical Functions

Posted by on February 10th, 2010
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 Functions are a set of functions, which are supported by all Entity Framework providers. These canonical functions are translated to the corresponding data source functionality for the provider.

The tables below contain information about these functions supported by the Devart products.
Functions supported by the following DBMS: MySQL, PostgreSQL, Oracle, SQLite, SQL Server 2005, and SQL
Server 2008 are marked in green.

(more…)

PostGIS and Entity Framework

Posted by on February 9th, 2010

Introduction

In this article we consider how to build Entity Framework models using PostGIS objects in Entity Developer. PostGIS is a popular spatial extension for PostgreSQL that gives one an opportunity to work with geographic objects. To create and use such models we will:

(more…)