postgresql

dbForge Team is excited to inform our PostgreSQL users that the wait is finally over –  a steaming hot dbForge Studio for PostgreSQL, v2.0 has been just rolled out. The release features a brand new Standard edition with new exclusive features and a bunch of essential updates and improvements. (more…)

We are glad to inform our PostgreSQL users that we have just released a new version of our PostgreSQL data diffs management tool, dbForge Data Compare for PostgreSQL, v3.1. (more…)

Devart always pursues better ways to meet the needs of our customers. We have already developed such excellent tools as dbForge Studio for SQL Server and dbForge Studio for MySQL. Our IDEs are famous for their unified and intuitive user interface that resembles (more…)

Very often, there is a need to compare or synchronize data between two databases on the same server. To detect differences, you can simply use dbForge Data Compare for PostgreSQL, which allows you to perform this process with a few clicks. (more…)

Recent versions of MySQL and PostgreSQL databases provide JSON functionality support. They introduced special data types, storing JSON data – json data type in MySQL (since MySQL 5.7.8), and json and jsonb data types in PostgreSQL (json introduced in PostgreSQL 9.2, and jsonb introduced in PostgreSQL 9.4). (more…)

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 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…)

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:

• Full-Text Search in LINQ to Entities
• Full-Text Indexes in Code-First Migrations
• Tutorial Overview
• Prerequisites
• Using Full-Text Index on Single Column
• Using Full-Text Index on Multiple Columns
• Conclusion

(more…)

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…)

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…)