Devart.Data.Dynamics.EFCore 2.3.190.9

dotConnect for Dynamics 365

dotConnect for Dynamics 365 is an ADO.NET provider for working with Dynamics 365 data through the standard ADO.NET or Entity Framework interfaces. It allows you to easily integrate Dynamics 365 data into your .NET applications, and integrate Dynamics 365 services with widely used data-oriented technologies.

The provider works with .NET Frameworks 4.5+, .NET Core 3.1, .NET 5+. The product is compatible with ADO.NET Entity Framework (EF) Core.

It has the same standard ADO.NET classes as other standard ADO.NET providers: DynamicsConnection, DynamicsCommand, DynamicsDataAdapter, DynamicsDataReader, DynamicsParameter, etc. This allows you quickly get started with it and eliminates the need to study any Dynamics 365 data access specificities.

More information at dotConnect for Dynamics 365.

Compatibility

The following table show which version of this package to use with which version of frameworks.

More information here

Installation

For projects, using Entity Framework Core 9 with Dynamics 365, install this package. Execute the following command in the Package Manager Console:

Install-Package Devart.Data.Dynamics.EFCore

License

See pricing options for ordering.

To activate your license, please download dotConnect for Dynamics 365 from our website. This installer generates the trial key files required for using this package on a trial basis.

Usage

This snippet directly configures a DynamicsConnection class for an Entity Framework Core DbContext using a connection string.

public class MyDbContext : DbContext {
 
  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

     optionsBuilder.UseDynamics(@"Server=https://your_company.crm4.dynamics.com;UserId=Test@Test.onmicrosoft.com;Password=********;");
  } 
}

Configuration Using DynamicsConnection Instance

using Devart.Data.Dynamics;
...

public class MyDbContext : DbContext {
 
  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

     var connection = new DynamicsConnection();
     connection.Server = "https://your_company.crm4.dynamics.com";
     connection.UserId = "Test@Test.onmicrosoft.com";
     connection.Password = "********";
     optionsBuilder.UseDynamics(connection);
  } 
}

ASP.NET Core and Blazor

Configuration File (appsettings.json):

{
  "ConnectionStrings": {
    "DefaultConnection": "Server=https://your_company.crm4.dynamics.com;UserId=Test@Test.onmicrosoft.com;Password=********;"
   }
}

DbContext Configuration:

public class MyDbContext : DbContext {
 
  protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {

    IConfigurationBuilder builder = new ConfigurationBuilder().AddJsonFile("appsettings.json");
    IConfiguration configuration = builder.Build();
    optionsBuilder.UseDynamics(configuration.GetConnectionString("DefaultConnection"));
  } 
}

Key Features

• Easy Connection: Allows your .NET application to work with Dynamics 365 data.
• SQL Engine: No need to study and use complex Dynamics 365 API, just use familiar SQL statements. You may use complex JOINs, WHERE conditions, etc. - all the SQL benefits, not available with Dynamics 365 API.
• Support and Updates: Enjoy dedicated support team for prompt issue resolution and regular updates to keep your software running smoothly and securely.

Related Packages

• Devart.Data.Dynamics 365

Support Area

• Support
• Documentation
• Request form
• Feedback page
• Product history

More Resources

• Blog about dotConnect
• Devart Website