dotConnect for SugarCRM is a enhanced database connectivity solution built over ADO.NET architecture and a development framework with a number of innovative technologies.
Install
| Product | Versions |
|---|---|
| .NET |
README
dotConnect for SugarCRM
dotConnect for SugarCRM is an ADO.NET provider for working with SugarCRM data through the standard ADO.NET or Entity Framework interfaces. It allows you to easily integrate SugarCRM data into your .NET applications, and integrate SugarCRM services with widely used data-oriented technologies.
The provider works with .NET Frameworks 4.5+, .NET Core 2.0+, .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: SugarConnection, SugarCommand, SugarDataAdapter, SugarDataReader, SugarParameter, etc. This allows you quickly get started with it and eliminates the need to study any SugarCRM data access specificities.
More information at dotConnect for SugarCRM.
Compatibility
The following table show which version of this package to use with which version of frameworks.
| Frameworks | Version support |
|---|---|
| Entity Framework Core | 8 |
| .NET | 9, 8 |
More information here
Installation
For projects, using Entity Framework Core 8 with SugarCRM, install this package. Execute the following command in the Package Manager Console:
Install-Package Devart.Data.Sugar.EFCore
License
See pricing options for ordering.
To activate your license, please download dotConnect for SugarCRM 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 SugarConnection class for an Entity Framework Core DbContext using a connection string.
public class MyDbContext : DbContext {
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {
optionsBuilder.UseSugar(@"Server=https://your_company.sugaropencloud.eu;UserId=admin;Password=mypassword;");
}
}
Configuration Using SugarConnection Instance
using Devart.Data.Sugar;
...
public class MyDbContext : DbContext {
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {
var connection = new SugarConnection();
connection.Server = "https://your_company.sugaropencloud.eu";
connection.UserId = "admin";
connection.Password = "mypassword";
optionsBuilder.UseSugar(connection);
}
}
ASP.NET Core and Blazor
Configuration File (appsettings.json):
{
"ConnectionStrings": {
"DefaultConnection": "Server=https://your_company.sugaropencloud.eu;UserId=admin;Password=mypassword;"
}
}
DbContext Configuration:
public class MyDbContext : DbContext {
protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder) {
IConfigurationBuilder builder = new ConfigurationBuilder().AddJsonFile("appsettings.json");
IConfiguration configuration = builder.Build();
optionsBuilder.UseSugar(configuration.GetConnectionString("DefaultConnection"));
}
}
Key Features
- Easy Connection: Allows your .NET application to work with SugarCRM data.
- SQL Engine: No need to study and use complex SugarCRM API, just use familiar SQL statements. You may use complex JOINs, WHERE conditions, etc. - all the SQL benefits, not available with SugarCRM 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
Support Area
More Resources
Changes from Previous Version
Adoption Assessment
A verified publisher signal is available. Assess fit from the package's supported frameworks, license and dependency graph rather than popularity alone.
Related Guides & Workflows
Learn how to evaluate, integrate, or audit this package in your .NET project.