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 connect your .NET applications to Salesforce data, 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 Salesforce Web Services API - it allows you to use your knowledge of ADO.NET and Entity Framework.
dotConnect for Salesforce offers the easiest way to integrate 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 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 SOQL.
Benefits
- Use your knowledge of SQL-92, ADO.NET, and Entity Framework with Salesforce data!
- Integrate your 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
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 data-oriented applications.
Our ADO.NET provider offers you:
- Powerful local SQL engine with support for SQL-92 compliant SELECT statement
- Visual Studio integration - data binding, Server Explorer, Query Builder, Data Source Configuration Wizard, etc.
- Easy access to metadata with either GetSchema method or through SQL-92 compatible information schema
Easy way to start
Entity Framework
Entity Framework offers a number of advantages over using Salesforce Web Services API directly:
- LINQ to Entities (no need for SOQL)
- Entity relations with lazy/eager loading
- No need to post each edited/created object separately - a single SaveChanges() call to persist all the changed objects
dotConnect for Salesforce provides enhanced Entity Framework support for Salesforce data with a bundled visual designer for ORM models - Entity Developer. Standard Visual Studio Entity Data Model designer is also supported.
Easy way to start
Why Not Web Services API?
Salesforce integration through the free Web Services API has considerable disadvantages. Before starting you need to learn complex Salesforce 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 querymore calls.
To retrieve data, you have to use SOQL, which is known to be rather limited. Additionally, Salesforce returns object data that are hard to use in controls, reports, etc.
Creating a new object is a complex task in Salesforce, 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 dotConnect for Salesforce 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.