Key Features And Compatibility

Compatibility

  • All versions of Microsoft Dynamics 365 API
  • x64 and x86 architecture
  • Windows, Linux, macOS

Platforms

  • .NET 5.0-9.0
  • .NET Core 3.1
  • .NET Frameworks 4.5-4.8
  • ASP.NET Core
  • Blazor
  • .NET MAUI (previously Xamarin)

.NET languages

  • C#
  • VB.NET
  • F#

ORM support

  • Entity Framework Core 1.x-9.0
  • Entity Framework v4-v6
  • Dapper 1.x, 2.x
  • NHibernate 1.x-5.x
  • LINQ to Entities

Entity Framework features

  • Change tracking and object data caching support
  • Inheritance mapping support (TPH, TPT, TPCT models)
  • Ability to build database-independent applications

With Entity Developer

  • Visual model creation and code generation
  • Model update from the database
  • Reverse engineering of database objects to an entity model
  • Storage schema editing of Entity Framework
  • Standalone usage or Visual Studio integration

Security standards

  • SSL/TLS connections
  • Connection through proxy servers
  • Connected and disconnected data access models
  • Unicode connections
  • Operation in the FIPS 140-2 mode in Windows

Certification

  • DigiCert Trusted G4 Code Signing RSA4096 SHA384
    2021 CA1

Performance

  • Intelligent fetch block size control
  • Advanced connection pooling
  • High-performance batch processing

IDE integration

Visual Studio

Microsoft Visual Studio 2015-2022

  • Advanced design-time component and property editors
  • IntelliSense descriptions for dotConnect for Dynamics 365 classes
  • Syntax highlighting and SQL code completion in design-time editors
  • Convenient instant data preview and management at design time

Without design-time integration

  • Visual Studio Code
  • JetBrains ReSharper and Rider
  • Cursor, Windsurf, etc

ADO.NET architecture

  • Extended metadata information retrieval
  • Advanced CommandBuilder component with automatic refresh SQL
  • Enhanced pooling control through the connection string
  • Connection string builder
  • Provider factory for generating key data access classes
  • Asynchronous command execution

NuGet availability

Devart.Data.Dynamics 
dotnet add package Devart.Data.Dynamics
Devart.Data.Dynamics.EFCore 
dotnet add package Devart.Data.Dynamics.EFCore

SQL support

  • Powerful local SQL engine with support for SQL-92 compliant SELECT statement
  • CREATE, READ, UPDATE, and DELETE operations with standard SQL statements
  • Сomplex JOINs, WHERE conditions, and other SQL-specific features

SQL execution monitoring

  • Extended SQL tracing capabilities with DynamicsMonitor component
  • Support for the dbMonitor utility for advanced tracing analysis and control
  • Per-component SQL tracing
  • Optional log output to the IDE

Dynamics 365 technology support

  • All Microsoft Dynamics 365 data types support
  • DynamicsLoader component for fast data loading
  • Paginal access to query results