Wednesday, June 12, 2024

entity framework

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.

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...

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...

Social

Products