dotConnect for Salesforce is an ADO.NET provider for accessing data of the Salesforce.com
cloud CRM and Database.com cloud database through the standard ADO.NET or
Entity Framework interfaces. It allows you to easily integrate Salesforce data into
your .NET applications, and integrate Salesforce services with widely used data-oriented
technologies. dotConnect for Salesforce offers local SQL engine to query Salesforce
data, advanced data caching, query optimization and other enterprise level features.
dotConnect for Salesforce eliminates the need to learn complex Web Services API
- it allows you to use your knowledge of ADO.NET and Entity Framework.
dotConnect for Salesforce offers the easiest way for integration of Salesforce services
into .NET applications and the highest performance. It uses advanced data caching,
connection pooling, and query optimization to increase the performance of connecting
to Salesforce CRM and fetching data.
Its local SQL engine allows you to use SQL-92 compatible SELECT statements to work
with Salesforce Leads, Contacts, Opportunities, Accounts and other objects in the
same way as with SQL tables. You may use complex JOINs, WHERE conditions, etc. -
all the SQL benefits, not available with Salesforce SOQL.
Use your knowledge of SQL-92, ADO.NET, and Entity Framework with Salesforce data!
Integrate Salesforce data with Microsoft data access technologies!
Use our enterprise level features, such as data caching for offline work, connection
pooling, and connection failover!
ADO.NET is a widely-used and well known way to access data that can easily be integrated
with a number of data processing technologies, thus allowing you to easily create
Our ADO.NET provider offers you:
Entity Framework offers a number of advantages over using Salesforce developer API
dotConnect for Salesforce provides enhanced Entity Framework support for Salesforce
data with a bundled visual designer for ORM models with Visual Studio integration
- Entity Developer. Standard Visual
Studio Entity Data Model designer is also supported.
dotConnect for Salesforce provides advanced Data Flow components: Devart Salesforce
Source and Devart Salesforce Destination along with Salesforce Connection Manager
for creating Salesforce data integration solutions for data export and import. These
components come with powerful visual editors and offer advanced features:
Read more about SSIS support in dotConnect for Salesforce...
Salesforce integration through the free Web Services API has considerable disadvantages.
Before starting you need to learn complex Web Services API, Salesforce data types,
to get acquainted with Salesforce object model. You also need to learn how to choose
protocol, how to establish a connection, and how to retrieve data using query and
To retrieve data, you have to use SOQL, which is known to be rather limited. Additionally,
the data are returned in an object form that is hard to use in controls, reports,
Creating a new object is a complex task with the Web Services API, and this webservice
does not allow deleting or updating several objects with a single call - you have
to use cycles for these tasks. All this requires much time and efforts to learn.
With our provider there is no need to learn all of this. You can use your existing
ADO.NET or Entity Framework knowledge to accomplish all the tasks involving Salesforce
data without using their Web Services API.
New Versions of dotConnect ADO.NET Providers with Entity Developer 5.5!
New Versions of dotConnect ADO.NET Providers with Entity Framework 6 Alpha 2 Support!
New Versions of dotConnect ADO.NET Providers with Entity Developer 5.0!
You might be also interested in:
ADO.NET providers for other databases: