dotConnect Team posts

Entity Framework Core 2.1.1 Support in Entity Developer and dotConnect Providers!

Devart is glad to announce the release of the new versions of dotConnect ADO.NET data providers and Entity Developer – our visual designer for ORM models. New versions of Devart products offer you support for Entity Framework Core 2.1.1. Additionally, dotConnect for PostgreSQL now supports connections via SSH protocol.
(more…)

What’s New in Devart SSIS Data Flow Components 1.7

Devart is glad to announce the new versions of our SSIS Data Flow Components with support for Marketo – a well-known cloud lead management and marketing automation solution. (more…)

What’s New in Devart Excel Add-ins 1.7

We proudly announce the release of Devart Excel Add-ins 1.7 — add-ins for Microsoft Excel that allow connecting Excel to cloud and database data, edit this data, and save it back to the data source. (more…)

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

Migrating Entity Framework 6 projects to Entity Framework Core 1 (EF7)

For the purpose of this tutorial, we will use a test project from the “Entity Framework 6 Support for Oracle, MySQL, PostgreSQL, SQLite, DB2, and Salesforce” blog article. We will update this project so that it could be used with Entity Framework Core 1 (Entity Framework 7). (more…)

Entity Framework Core 1 (Entity Framework 7) Support

Entity Framework Core 1, formerly known as Entity Framework 7 (hereafter also called EF Core or EF7), is supported in Devart ADO.NET provider product line. It is supported in providers for relational databases: Oracle, MySQL, PostgreSQL, SQLite, DB2, and provides for cloud data sources (more…)

Entity Developer 6.0 – New ORM Designer for Telerik Data Access

As Telerik announced a few months ago in their blog, they deprecated visual designer and Visual Studio tools for their Data Access ORM (formerly, OpenAccess ORM) – a very popular and powerful data access (more…)

MySQL Case Sensitive Search in Entity Framework

A high level abstraction provided by Entity Framework sometimes challenges developers in accessing a full set of features available via native SQL of a particular database server. This article will help you to cope with usage of collation in MySQL to control case sensitivity settings in generated queries. (more…)

String Enum Representation in Entity Developer

This article explains and demonstrates mapping a string representation of enum to string fields in a database in Entity Developer. The sample, demonstrated in this post, is included into our NHibernate Mapping Samples application, described in the corresponding NHibernate Mapping Samples blog article. It is named ‘Enum Type Property’; however, other samples from this application probably prove to become useful for NHibernate users both beginners and professionals, so we recommend downloading it for everyone who develop NHibernate applications.

The problem with mapping enum types in NHibernate is that NHibernate can map enum type values only to the numeric columns in database without additional manipulations. However, when enum values are stored in database as strings, NHibernate requires the user to perform some additional actions.
(more…)

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 in dotConnect for Oracle, LinqConnect, and Entity Developer is the support for the latest release of Oracle Database – Oracle 12c. Additionally, dotConnect data providers offer you Sync Framework support, improved PgSqlDump component, load balancing support in dotConnect for MySQL, and other features. This article describes the new features in details.
(more…)