dotConnect for SugarCRM

dotConnect for SugarCRM is a versatile enterprise-grade connector that enables access to SugarCRM data in .NET applications of all levels. It delivers advanced ORM support, broad compatibility with .NET platforms, and easy integration with multiple IDEs, including Microsoft Visual Studio.

Moreover, this connector regularly undergoes security and performance tests to make sure it stays ahead of the competition at all times. Extra benefits include premium support, frequent updates, and detailed documentation to help you with a quick and easy start.

• Access to data with no need for any client libraries
• Advanced ORM support: EF Core, Dapper, NHibernate, and more
• Full compliance with ADO.NET standards
• Support for all versions of SugarCRM API
• Support for SugarCRM-specific features
• Powerful local SQL engine with support for SQL-92
• Integration with Visual Studio

Installation

1. Install the NuGet Package

Or download the Windows installer (.exe) from the official website.

2. Activate license

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

Usage

This snippet directly configures a SugarCRM connection using a connection string.

```csharp=

using Devart.Data.Sugar;

namespace SugarConsoleApp

{

class Program

{

static void Main(string[] args)

{

string host = "https://test.sugaropencloud.com";

string userId = "test";

string password = "test";

string licenseKey = "**********";

string connectionString = $"Host={host};User Id={userId};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 (SugarConnection sugarConnection = new SugarConnection(myConnString))

{

try

{

sugarConnection.Open();

Console.WriteLine("Connection successful.");

}

catch (Exception ex)

{

Console.WriteLine("Connection failed: " + ex.Message);

}

}

```

Read the full documentation for connection here.

Compatibility

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

Entity Framework Core | 10, 9, 8, 7, 6, 5, 3, 2, 1

.NET | 10, 9, 8, 7, 6, 5

.NET Core | 3.1, 2

.NET Framework | 4.8, 4.7, 4.6, 4.5

More information here

Enhanced ORM Support

dotConnect for SugarCRM offers enhanced ORM support with a bundled visual designer for ORM models - Entity Developer. Our SugarCRM ADO.NET Provider supports the following ORMs:

• Entity Framework v4 - v6
• Entity Framework Core 1.x, 2.x, 3.x, 5.0, 6.0, 7.0, 8.0, 9.0, 10.0
• NHibernate 1.x-5.x
• Dapper 1.x, 2.x