Key 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 - all the SQL benefits, not available with SOQL. Entity Framework Support dotConnect for Salesforce supports Entity Framework v1 - v6.4 and Entity Framework Core, which allows you to benefit from using LINQ to Entities, entity relations with lazy/eager loading. With Entity Framework you don't 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. SSIS Data Flow Components Devart Salesforce Source component allows querying data with both SOQL and SQL in Integration Services packages. The source component is able to query data with or without deleted records or system fields. Devart Salesforce Destination component uses native bulk protocol for loading data in Integration Services packages. SSIS DataFlow components are included into dotConnect for Salesforce Professional Edition and a new SSIS Edition.
What is new in this release:
Version 3.5: Visual Studio 2019 version 16.5 Preview is supported. Entity Framework 6.4 is supported. Entity Framework Core 3.1 is supported.
What is new in version 3.3:
Version 3.3: Entity Framework Core 2.1 is supported (Query type support, Lazy loading, the Constructor Parameter property) . Entity Framework Core 2.1.1 is supported.
What is new in version 3.2:
Visual Studio 2017 is supported The Readonly connection string parameter is added to allow only reading source data (only SELECT statements) The new "Text Type" property displaying the text type of a column is added to column properties in the Devart Salesforce Source editor
What is new in version 3.1.55:
Version 3.1.55: Entity Framework Core support; Microsoft SQL Server 2016 is supported in SSIS DataFlow components..
What is new in version 2.3.175:
Version 2.3.175 fixes the bug with using WHERE clause on Dates in the query with subselect.
Requirements:
Microsoft .NET Framework 3.5 and ADO.NET Entity Framework
Limitations:
30-day trial
Comments not found