.NET Connector for Adobe Commerce with ORM Support

dotConnect for Adobe Commerce is a high-performance ADO.NET data provider that enables direct access to Adobe Commerce and Magento data using standard ADO.NET interfaces. It enables quick and flawless data management and integrating of Adobe Commerce data into .NET applications, ensuring compatibility with popular data-oriented technologies.

This efficient provider includes familiar ADO.NET classes, allowing a quick start without requiring extensive knowledge of Adobe Commerce.

  • Broad compatibility with .NET platforms, including WPF, Blazor, MAUI, Windows Forms, etc.
  • ORM support: EF Core, Dapper, NHibernate, etc.
  • Full compliance with ADO.NET
  • Integration with Visual Studio and design-time support
  • Regular updates and detailed documentation
Easy integration with Adobe Commerce

Easy integration with Adobe Commerce

Integrate Adobe Commerce into .NET applications through the standard ADO.NET interface.

No for overcomplicated APIs

No for overcomplicated APIs

Use SQL queries for data retrieval instead of struggling with the Adobe Commerce API.

Standard ADO.NET classes

Standard ADO.NET classes

Get started quickly with familiar ADO.NET classes used by dotConnect for Adobe Commerce.

Connect to Adobe Commerce worry-free

dotConnect for Adobe Commerce provides direct TCP/IP connection to Adobe Commerce, eliminating the need for extra client software and simplifying its integration with your applications.

  • Easy connection without any client libraries
  • Comprehensive support for SQL queries and API calls
  • Advanced security with encryption and authentication
  • Flexible connectivity options for diverse operational environments
  • Cost-effective deployment

Advanced ORM support

dotConnect for Adobe Commerce offers enhanced ORM support with a bundled Entity Developer – visual designer for ORM models.

Entity Framework Core

1.x, 2.x, 3.x, 5.0, 6.0, 7.0, 8.0, and 9.0

Entity Framework

V1-v6

NHibernate

1.x-5.x

Dapper

1.x, 2.x

Broad Compatibility

dotConnect for Adobe Commerce is the only data provider of its kind that supports both modern platforms and technologies (such as Blazor, MAUI, and Entity Framework Core) as well as deprecated technologies, which is an excellent way to reduce integration costs for existing applications.

Platforms
  • .NET 5, 6, 7, 8
  • .NET Framework 4.5-4.8
  • .NET Core 2.x, and 3.0
  • ASP.NET Core Blazor
  • .NET MAUI
Adobe Commerce/Magento API

All versions

Microsoft Visual Studio

Visual Studio 2012-2022

One connector for all your SQL queries

dotConnect for Adobe Commerce simplifies the data management tasks by allowing you to run SQL queries directly against your Adobe Commerce and Magento data as you can do with a database. Now you can handle accounts, contacts, leads, and further information with ease, using familiar SQL statements instead of the complex API calls.

  • SQL-based data management: Use SQL statements to interact with Adobe Commerce data
  • Full CRUD support: Perform CREATE, READ, UPDATE, and DELETE operations using standard SQL
  • Advanced SQL capabilities: Execute complex JOINs, WHERE conditions, and other features for more precise and flexible data operation
  • Comprehensive object access: Work with every piece of data available in Adobe Commerce

How dotConnect for Adobe Commerce works

Simple queries are directly compiled into Adobe Commerce calls and executed on the Adobe Commerce side.

Complex queries are divided into parts, with portions executed on Adobe Commerce, while the local SQL engine processes the results.

The processed data is returned to the application.

More articles