Improvements for EF Core Support and Monitoring in dotConnect Providers

Devart news about betas, releases, awards, and other information
Site Admin
Posts: 3815
Joined: Tue 26 Oct 2004 13:51

Improvements for EF Core Support and Monitoring in dotConnect Providers

Post by Devart » Fri 18 Sep 2020 15:06

Dear users,

Devart is glad to announce the release of the new versions of dotConnect ADO.NET data providers. New versions of Devart products offer significant improvements for Entity Framework Core and make debugging process easier by adding more configuration options to DbMonitor class.

Spatial Data Support for EF Core

dotConnect providers for MySQL, Oracle, PostgreSQL, and SQLite can now work with Spatial data in Entity Framework Core. This functionality is implemented in the new Devart.Data.<provider>.Entity.EFCore.NetTopologySuite.dll assembly, available for Full .NET Framework via the product installer, and for .NET Standard project — as a separate NuGet package. For SQLite this support is provided via the SpatiaLite SQLite extension.

Entity Developer also supports mapping spatial properties to database columns of corresponding types. When generating a model from a database, having spatial columns, it automatically downloads all the necessary NuGet packages to your projects.

Read more about our spatial data support in the Entity Framework Core Spatials Support in dotConnect ADO.NET Providers blog article.

Full Text Search and Database-specific Functions Support for EF Core

Classes for using database-specific functions in LINQ to Entities that were previously supported for Entity Framework v4 – v6, are now supported for Entity Framework Core. These are the following classes:
  • MySqlFunctions
  • OracleFunctions
  • PgSqlFunctions
  • SQLiteFunctions
Additionally, dotConnect providers now support full-text search for Entity Framework Core via the following classes:

  • MySqlTextFunctions
  • OracleTextFunctions
  • PgSqlTextFunctions
  • SQLiteTextFunctions
Monitoring Improvements

All dotConnect providers allow monitoring their work via the free dbMonitor application and their descendants of DbMonitor class. It allows per-component tracing of database events such as commit, rollback, SQL statement execute, creating and destroying components, connection pooling events, etc.

The new version allows tweaking monitoring in more details and significantly decrease performance loss from monitoring. Now you can turn off costly call stack sending for all database events via the SendCallStack property of the DbMonitor class. Additionally, you can specify events that you want to monitor in the Filter property, and other events won’t be monitored.

And a bonus feature – now the DbMonitor class sends timestamps for database events with milliseconds included.

List of Providers with Entity Framework Core Support Improvements

dotConnect for Oracle 9.13 [ Download ] [ New Features ]
dotConnect for MySQL 8.18 [ Download ] [ New Features ]
dotConnect for PostgreSQL 7.18 [ Download ] [ New Features ]
dotConnect for SQLite 5.16 [ Download ] [ New Features ]

Devart development team