entity framework

The Ultimate Comparison of ADO.NET and Entity Framework

When developers start working on any applications (for both web or desktop versions), they spend a long time worrying about the backend database, its tables, and their relationships, stored procedures, views, etc. Along with this, they also need to consider the data schema which will return from the backend part for the application. For this type of operation, we can use many available frameworks such as DAO, RDO, ADO, ADO.NET, Entity Framework, etc. Out of these different frameworks, the most commonly used frameworks are ADO.NET and Entity Framework. So, after reading this article,  you will get a clear understanding of the following topics supported with clear examples:


Support for Load Balancing and Other Improvements in dotConnect for PostgreSQL 7.24

The new version of dotConnect for PostgreSQL offers support for load balancing. It allows specifying multiple hosts with their ports in the Host parameter of the connection string. The servers should be separated by commas.


Support for More Providers for EF Core in Entity Developer 6.9

Devart is glad to announce the release of Entity Developer 6.9 – a visual ORM designer for a wide variety of ORMs. The new version supports two more third-party providers for Entity Framework Core.


Entity Framework Core Spatials Support in dotConnect ADO.NET Providers

The new releases of dotConnect ADO.NET providers for Oracle, MySQL, PostgreSQL, and SQLite support Spatial data in Entity Framework Core 3.


Entity Framework Core 3.1 Support in dotConnect Providers

Devart is glad to announce the release of the new versions of dotConnect ADO.NET data providers. New versions of Devart products offer you support for Entity Framework Core 3.1.


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. Since then .NET Core has been drastically improved. .NET Core 2.0 has a significant part of Full .NET Framework features and includes new functionality and significant performance optimizations.

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.

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