entity framework
Dapper vs. Entity Framework Core: Which One Is Right for Your .NET Project?
Compare Dapper and Entity Framework Core to choose the best ORM for your .NET project. Learn about performance, query execution, and best use cases.
NHibernate vs Entity Framework Core: Which ORM Is Right for You?
Optimize your .NET app with the right ORM. NHibernate offers deep SQL control and advanced caching for enterprise applications, while EF Core delivers speed, simplicity, and seamless .NET integration. NHibernate excels in complex queries, while EF Core is lightweight and cloud-ready. Picking the right one ensures smooth performance and scalability.
Relationships in Entity Framework Core: Complete Guide for .NET Developers
Learn how to configure EF Core relationships, including One-to-One, One-to-Many, and Many-to-Many, with foreign keys and Fluent API.
What is the Difference Between ADO.NET and Entity Framework Core: Comparison Guide
When developers start working on any applications (for both web or desktop versions), they spend a long time worrying about the backend database, its...
How to Connect to PostgreSQL in .NET 8 using EF Core and ASP.NET Core
The integration of PostgreSQL with a .NET 6 Web API provides a powerful and flexible solution for building data-driven .NET applications.
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...
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...
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...
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...
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....
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...
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...
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,...
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...
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...
Model-Defined Functions in Entity Developer
This article explains how the support of Entity Framework Model-Defined Functions is implemented in Entity Developer ORM Designer and illustrates creating such methods on...
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...
Entity Framework 6 Support for Oracle, MySQL, PostgreSQL, SQLite, DB2 and Salesforce
Article was updated on December 5th, 2013
Entity Framework 6 Alpha 2 support is implemented in Devart ADO.NET providers: dotConnect for Oracle, dotConnect for MySQL,...
New Features in Entity Developer 5.0
Entity Developer 5.0 introduces a range of new features we hope you will find useful in your work. Starting with this version, Entity Developer...
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 PostgreSQL Full-Text Search in Entity Framework
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...
Using SQLite Full-Text Search in Entity Framework
Introduction
SQLite database supports an advanced functionality of full-text search (FTS) and full-text indexing described comprehensively in the SQLite documentation: SQLite FTS3 and FTS4 Extensions.
We...
Using MySQL Full-Text Search in Entity Framework
Introduction
MySQL database supports an advanced functionality of full-text search (FTS) and full-text indexing described comprehensively in the documentation:
Full-Text Search Functions (MySQL 5.5 stable...
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....
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...
Explanation of Microsoft POCO and Self-Tracking Templates
If a developer needs to introduce certain changes or adjust the behavior of Microsoft's POCO or Self-Tracking templates of the EntityFramework model or to...
Using Entity Framework Power Tools CTP1 with Oracle, MySQL, PostgreSQL, and SQLite
Released soon after Entity Framework 4.1, EF Power Tools CTP1 is intended to provide design-time support for the development that involves the use of...
New Features of Entity Framework Support in dotConnect Providers
DML Options
Batch Updates
Batch Updates Limitations
Batch Updates Settings
Other DML Options
SQL Formatting Settings
Workarounds
Database Script Generation Settings
DeleteDatabaseBehaviour
DBMS-Specific...
Entity Developer – EF Code First DbContext Template
Note: To use the template "DbContext", Entity Framework 4.1 and Entity Framework 4.0 must be installed on your computer.
April 2011 saw the release of...
Provide your feedback on Entity Framework support in dotConnect data providers at UserVoice!
Go to devart.uservoice.com and share your ideas about Entity Framework support in dotConnect data providers. There you may vote for features that are already...
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...
Entity Framework: Tips and Tricks, part 4
We continue post series about Entity Framework usage. We consider the following questions in this article:
MS SQL Server and Oracle - how to...
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...
Entity Framework: Tips and Tricks, part 3
This article continues series of publications about non-trivial Entity Framework situations encountered by our users.
We consider the following questions in this article:
Why Oracle...
Entity Framework Tips and Tricks, Part 2
In this article we continue series of publications about non-trivial situations encountered by our users. Some of these situations are the restrictions of the...
Entity Framework Tips and Tricks, Part 1
This article will open a series of publications about non-trivial situations encountered by our users. Some of these situations are the restrictions of the...
Enumeration Support
Introducing
Enumeration support in databases
Enumerations support in LINQ to SQL
Case management
Entity Developer
User interface for enumerations
Creating enumerations
Naming rules
...
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:...
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...
PostGIS and Entity Framework
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...
Working with transactions in Entity Framework and LINQ to SQL
Entity Framework
In this article we consider a short description of the Entity Framework and LINQ to SQL transactional models. There are also some simple...
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...
