.NET Connector for Salesforce with ORM Support

dotConnect for Salesforce is a high-performance ADO.NET data provider that grants simple access to Salesforce when developing Salesforce-related applications.

It fully supports Entity Framework (EF Core), Dapper, and NHibernate, along with a wide range of Salesforce-specific features, such as SOQL support, a powerful local SQL engine with support for SQL-92, and others.

  • Easy access to Salesforce without requiring specific client libraries
  • Broad compatibility with .NET platforms, including WPF, Blazor, MAUI, Windows Forms, etc.
  • ORM support: EF Core, Dapper, NHibernate, LinqConnect, etc.
  • Full compliance with ADO.NET
  • SSL, SSH, proxy servers, and HTTP tunnels support
  • Regular updates and detailed documentation
  • Expert developer support
Easy Integration With Salesforce

Easy Integration With Salesforce

You don't need to know any specifics of accessing Salesforce data. Connection is made effortless.

No Salesforce API and SOQL Learning

No Salesforce API and SOQL Learning

There is no need to study and use the complex Salesforce API. You only need to use familiar SQL statements.

User Friendly ADO.NET Classes

User-Friendly ADO.NET Classes

dotConnect for Salesforce uses well-known ADO.NET classes and thus provides you with an easy start.

Easy Connection to Salesforce

dotConnect for Salesforce allows connecting to Salesforce via TCP/IP with no need for additional clients. This can greatly simplify application development and deployment.

  • Quick connection without auxiliary libraries
  • Full support for SOQL queries and Web service calls
  • Robust security features with advanced encryption and authentication
  • Flexible connectivity options for diverse operational environments
  • Cost-effective deployment

Advanced ORM Support

dotConnect for Salesforce offers enhanced ORM support when bundled with Entity Developer – a visual designer for ORM models:

Entity Framework Core

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

NHibernate

1.x-5.x

Entity Framework

V1-v6

Dapper

1.x, 2.x

Broad Compatibility

dotConnect for Salesforce is the only Salesforce data provider that supports modern platforms and technologies, as well as multiple deprecated technologies, reducing support costs for existing applications.

Platforms
  • .NET 5, 6, 7, 8
  • .NET Framework 2.0-4.8
  • .NET Core 1.x, 2.x, and 3.0
  • ASP.NET Core Blazor
  • .NET MAUI
Salesforce WEB API

All versions

Microsoft Visual Studio

Visual Studio 2008-2022

Single Connector for Any SQL Queries

dotConnect for Salesforce simplifies your data management by helping you run SQL queries directly within the Salesforce environment. This powerful tool allows you to handle accounts, contacts, leads, and other data with ease, using familiar SQL statements instead of the complex Salesforce API.

  • Data Management Via SQL Queries: Retrieve, inspect, and manage your Salesforce data by writing and executing SQL queries.
  • Full CRUD Support: Run CREATE, READ, UPDATE, and DELETE operations with standard SQL statements.
  • Advanced SQL Capabilities: Utilize complex JOINs, WHERE conditions, and other SQL-specific features.
  • Broad Object Access: Work with a wide range of Salesforce objects like accounts, contacts, leads, and opportunities.

How SQL Connector for Salesforce Works

Our Salesforce Data Flow Components handles queries by splitting complex ones into parts for execution on Salesforce, with advanced processing by a local SQL engine, while simple queries are directly compiled into Salesforce API calls for optimal performance.

More articles