
Product Description 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. ADO.NET support 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 statements; wide Visual Studio integration - data binding, Server Explorer, Query Builder, Data Source Configuration Wizard, etc.; easy access to metadata with either the GetSchema method or through a SQL-92 compatible information schema. ADO.NET Entity Framework Support 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 v4, v5, v6 and Entity Framework Core (former Entity Framework 7) support for Salesforce data with a bundled visual designer for ORM models - Entity Developer. Standard Visual Studio Entity Data Model designer is also supported. SSIS Salesforce DataFlow Source and Destination Components dotConnect for Salesforce provides advanced Devart Salesforce Source and Devart Salesforce Destination components along with Salesforce Connection Manager for Data Flows in SQL Server Integration Services (SSIS) projects, including SQL Server 2016 Business Intelligence. Why Not Web Services API? Working with Salesforce data 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. Development Environments Visual Studio 2017 Visual Studio 2015 Visual Studio 2013 Visual Studio 2012 Visual Studio 2010 Visual Studio 2008	Additional Information Product Overview Order Now Download Free Trial Product Screenshots
Devart is a software development company specializing in native connectivity solutions and development tools for the most popular databases, including Oracle, SQL Server, MySQL, PostgreSQL, InterBase, Firebird, and SQLite.
Official Devart Site \| Devart Forums \| Contact Us