dotConnect for Salesforce is a solution for integrating data of the Salesforce.com cloud CRM and Database.com cloud database with widely used Microsoft data development technologies. dotConnect for Salesforce offers local SQL engine to query Salesforce data, advanced data caching, query optimization and other enterprise level features.
- Powerful SQL Engine
With dotConnect for Salesforce you don’t need to learn complex Salesforce Web Services API – use your existing SQL knowledge. dotConnect for Salesforce has its own local SQL engine that 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.
- Entity Framework Support
dotConnect for Salesforce supports Entity Framework v1 – v6, which allows you to benefit from using LINQ to Entities, entity relations with lazy/eager loading. With Entity Framework you do not need to post each edited/created object separately – a single SaveChanges() call to persist all the changed objects. dotConnect for Salesforce goes with its own advanced visual Entity Framework model designer – Entity Developer.
- Rich Design-Time
dotConnect for Salesforce has rich set of design time tools that leverage the development process greatly. Particularly, there are convenient design time component editors, wizards toolset for live data binding and much more. dotConnect for Salesforce integrates tightly with Visual Studio 2008 – 2019.
* These are the features of the Professional edition. If you are interested in another product edition, please check the ‘Editions’ page of the corresponding product.