Devart.Data.Magento 3.2.237

Advanced C# Connection Provider for Adobe Commerce

dotConnect for Adobe Commerce is a high-performance ORM enabled data provider for Adobe Commerce (formerly Magento) that builds on ADO.NET technology. It enables access to Adobe Commerce store data in .NET applications through standard SQL queries—no Adobe Commerce API expertise required.

The provider works with .NET Frameworks, .NET Core, .NET.

It supports a wide range of Adobe Commerce-specific features, including a powerful local SQL engine with SQL-92 support, full CRUD operations, complex JOIN queries, and others. Package provides advanced Visual Studio integration and convenient visual component editors to simplify component tweaking.

More information at dotConnect for Adobe Commerce.

Installation

1. Install the NuGet Package

Install-Package Devart.Data.Magento

2. Activate license

• Free Trial License: Evaluate the full capabilities of dotConnect for Adobe Commerce in a non-commercial environment—ideal for development and testing. Start your free trial
• Commercial License: Deploy dotConnect for Adobe Commerce in commercial applications and access full technical support with a valid license. Purchase a license

Work with EF Core

For projects, using Entity Framework Core with Adobe Commerce, install the Devart.Data.Magento.EFCore package.

Compatibility

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

More information here

Key Features

• SQL Access Without API Complexity: Query and manipulate Adobe Commerce data using standard SQL statements—no need to learn the REST API. Use complex JOINs, WHERE conditions, aggregate functions, and more.
• Full CRUD Operations: Perform INSERT, SELECT, UPDATE, and DELETE operations on Adobe Commerce objects such as products, orders, customers, and categories through familiar SQL syntax.
• Full ADO.NET Compatibility: 100% compliant with ADO.NET standards, supporting key interfaces such as DbConnection, DbCommand, DataSet, and DataTable for seamless integration into .NET applications.
• Powerful Local SQL Engine: Built-in SQL-92 compliant engine enables advanced query capabilities beyond what the native Adobe Commerce API exposes.
• ORM Support: Works with Entity Framework Core, NHibernate, and Dapper, enabling code-first and model-first workflows with Adobe Commerce data.
• API Key Authentication: Secure connectivity to Adobe Commerce stores using Host, User Id, and API Key credentials.
• Broad Platform Compatibility: Fully compatible with .NET Framework, .NET Core, and .NET, including ASP.NET Core, Blazor, and .NET MAUI.
• Visual Studio Integration: Accelerate development with data source connection wizards, database object explorer, and schema management tools—all embedded in Visual Studio.
• Reliable Security: Advanced encryption and authentication ensure secure access to your Adobe Commerce store data.
• Priority Support and Continuous Improvement: Backed by dedicated technical support and regular updates that deliver security enhancements, feature improvements, and long-term stability.

Usage

To help you get started quickly, here's a simple code example demonstrating how to connect to an Adobe Commerce store.

using Devart.Data.Magento;

namespace MagentoConsoleApp
{ 
    class Program 
    { 
        static void Main(string[] args) 
        { 
            string domain = "https://testdomain.com/";
            string user = "TestUser";
            string password = "TestPassword";
            string licenseKey = "***********";

            string connectionString = $"Service Version=Ver2;Domain={domain};User={user};Password={password};License Key={licenseKey}";
 
            try 
            { 
                CheckConnectionStatus(connectionString); 
            } 
            catch (Exception ex) 
            { 
                Console.WriteLine("An error occurred: " + ex.Message); 
            } 
        } 
 
        public static void CheckConnectionStatus(string myConnString) 
        { 
            using (MagentoConnection magentoConnection = new MagentoConnection(myConnString)) 
            { 
                try 
                { 
                    magentoConnection.Open(); 
                    Console.WriteLine("Connection successful."); 
                } 
                catch (Exception ex) 
                { 
                    Console.WriteLine("Connection failed: " + ex.Message); 
                } 
            } 
        } 
    } 
}

Basic Connection Strings

For more detailed tutorials, API reference, and advanced examples, visit our Getting Started guide.

Related Packages

• Devart.Data.Magento.EFCore

Support Area

• Documentation
• Request form
• Feedback page
• Product history