.NET Connector for SugarCRM With ORM Support

dotConnect for SugarCRM is a high-performance ADO.NET data provider that enables direct access to SugarCRM data using standard ADO.NET interfaces. Being compatible with a variety of data-related technologies, dotConnect will help you easily integrate SugarCRM data into custom .NET applications.

Every dotConnect provider allows using ADO.NET classes and helps avoid the complexity of studying and applying APIs. On the contrary, it makes your data integration extremely simple.

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

Easy integration with SugarCRM

Integrate SugarCRM data into .NET applications through the standard ADO.NET interface.

No need for overcomplicated APIs

Use SQL queries for simple and quick data retrieval instead of struggling with the SugarCRM API.

User-friendly ADO.NET classes

Get started quickly with the familiar ADO.NET classes used by dotConnect for SugarCRM.

Trouble-free connection to SugarCRM

dotConnect for SugarCRM enables direct connection to SugarCRM via TCP/IP. What's more, it doesn't require any further client software, which greatly simplifies the integration of SugarCRM data into your applications.

Easy connection with no need for extra client libraries
Comprehensive support for SQL queries and API calls
High-end security with encryption and authentication
Flexible connectivity for diverse operational environments
Cost-effective deployment

Advanced ORM support

dotConnect for SugarCRM provides full ORM support when bundled with Entity Developer, a visual designer for creating and managing ORM models.

Entity Framework Core

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

Entity Framework

v4-v6

NHibernate

1.x-5.x

Dapper

1.x, 2.x

Learn more

Compatibility and integration

Platforms

.NET 5.0, 6.0, 7.0, 8.0, 9.0
.NET Framework 4.5-4.8
.NET Core 2.x, 3.0
ASP.NET Core Blazor
.NET MAUI

SugarCRM API

All versions

Visual Studio extension

Data source connection
Database object explorer
Data retrieval and display

Compatibility with NuGet

Works in any NuGet-compatible IDE like VS Code, JetBrains Rider, etc.

One connector for all your SQL queries

dotConnect for SugarCRM makes data retrieval and management easier by employing SQL queries, which can be written and executed directly against SugarCRM, as if it were a database. This approach helps you access and work with your accounts, contacts, leads, and other information with no need for mastering SugarCRM API calls.

SQL-powered data management: It's never been easier to write and run familiar SQL statements against SugarCRM to query and manage data most effectively
Full CRUD support: You can perform INSERT, SELECT, UPDATE, and DELETE operations with ease and maximum flexibility
Advanced SQL capabilities: You are free to involve complex JOINs, WHERE conditions, and other features of SQL for more precise operations with your SugarCRM data
Comprehensive object access: Manage every piece of data available in SugarCRM