dotConnect for Salesforce History

This page lists the functionality added in each version of dotConnect for Salesforce. To view the full changelog including bug fixes, consult the dotConnect for Salesforce revision history.


New features in dotConnect for Salesforce 3.1

The current build is 3.1.111 from 22-Sep-2016

  • Microsoft SQL Server 2016 is supported in SSIS DataFlow components
  • Salesforce Web Services API version 37 is supported

Entity Developer

  • Entity Framework Core 1.0 RTM is supported
  • The possibility to set values of stored procedure parameters for getting metadata to generate automatically the corresponding complex type is implemented
  • The behaviour is changed: the ObservableCollection navigation properties are initialized now in a default class constructor

Entity Framework

  • Entity Framework Core 1.0.1 is supported
  • The SalesforceConventionSetBuilder class is implemented in the Entity Framework Core support
  • The DatabaseFacade.GetSalesforceConnection() extension method, which returns SalesforceConnection, is implemented in EF Core
  • The new optional parameter Action<SalesforceDbContextOptionsBuilder> is added to UseSalesforce() extension method of DbContextOptionsBuilder in EF Core

New features in dotConnect for Salesforce 3.0

The current build is 3.1.111 from 22-Sep-2016

  • The Run Once Command connection string parameter, which specifies a command to execute when the connection is opened the first time and not executed when the connection is taken from the pool, is added
  • The new LoadTable overloads for loading data from a IDataReader, array of rows, or only rows with a specific RowState from a DataTable are added to the SalesforceLoader class

Entity Developer

  • Entity Framework Core support is added
  • The DbProviderFactory provider registration in application's *.config is supported by the Entity Developer version integrated into Visual Studio

Entity Framework

  • Entity Framework Core RC2 is supported
  • Entity Framework-related assemblies are renamed
  • Upgrade Wizard is improved for upgrading projects with the Entity Framework functionality

New features in dotConnect for Salesforce 2.5

  • Visual Studio 2015 is supported
  • The performance of Devart components validation in SSIS package is improved
  • The behaviour is changed: now refreshing on "Input and Output Properties" tab of the Devart Salesforce Destination component editor sets Input Columns mapping according to External Columns

Entity Developer

  • The Use ObservableCollection property of the DbContext template is implemented

New features in dotConnect for Salesforce 2.4

  • Visual Studio 2015 Release Candidate is supported
  • Visual Studio 2013 is supported
  • The support of OAuth 2.0 is implemented to allow authentication with the Refresh Token, Client ID, and Client Secret parameters
  • The SalesforceConnection.GetPicklistColumns(string table_name) method is implemented for getting valid values for the "picklist" field types within specified table
  • The SessionId authentication type is implemented to allow authorization with the Session Id (Access Token), Organization Id, and Host connection string parameters
  • The possibility to talk to the SYS_PICKLIST_COLUMNS table in the SQL query is implemented
  • Salesforce Web Services API version 32 is supported
  • Microsoft SQL Server Data Tools Business Intelligence (SSDT-BI) project templates for Analysis Services and Integration Services in Visual Studio 2013 are supported
  • SSIS DataFlow Source and Destination components are supported in SSDT-BI for Visual Studio 2013
  • The usage of DateTime SOQL functions (except FISCAL_MONTH, FISCAL_QUARTER, FISCAL_YEAR) in SQL-92 statements is supported
  • The behaviour is changed: installation with the /VERYSILENT install parameter will uninstall the other version of the provider without any dialog box if it is installed
  • The behaviour is changed: IndexOutOfRangeException is generated now instead of InvalidOperationException when SalesforceDataReader.GetOrdinal(String name) finds nothing in the result set
  • The behaviour is changed: now two consequent single quotes in command text are treated as one single quote character (not as a beginning or an end of a string value)
  • The behaviour is changed: the TLS encryption is set to default instead of SSLv3
  • The behaviour is changed: the SalesforceMonitor now hides information about the password connection string parameter

Entity Developer

  • Entity Framework 6 is supported
  • The new "Provider Manifest Token" model property is implemented to identify the target server
  • The "WCF DataMember Attribute on Navigation Properties" property is added to the Data Transfer Object template for pointing the end (-s) where the attribute should be generated
  • More information messages, when validating EF6 models basing on the EntityFramework.dll functionality, are added
  • The information message about availability of NuGet Package Manager on the workstation is added in the Entity Developer version integrated into Visual Studio
  • The override modifier for DbSet class properties generated by DbContext templates is added
  • The View Generation option of the model with Entity Framework version = Entity Framework 6 is supported for the DbContext (only with XML mapping), EntityObject, POCO, and Self-Tracking Entities templates
  • The possibility to use relative paths to assemblies in code generation templates is implemented
  • The Implement Equals property is added to the DbContext, ObjectContext, and POCO Entity templates
  • The Remove Invalid Characters option (by default, True) is added to the Model Naming rules; if it is set to False, all invalid characters will be replaced with underscores
  • The Enable WinForms Data Binding property of the DbContext template is implemented (Entity Framework models)
  • The Property Change Partial Methods property of the DbContext template is implemented for generating partial methods On%PropertyName%Changing and On%PropertyName%Changed for each primitive property of entity classes (Entity Framework models)
  • The behaviour is changed: now partial configuration classes are generated when DbContext template is used with Fluent Mapping=True and Mapping Generation Strategy=UseConfigurationClasses options (Entity Framework models)
  • The behaviour is changed: the validation of EF6 models depends on the EntityFramework.dll functionality only (.NET Framework 4.5 is not required any more)
  • The behaviour is changed: now paths to assemblies with attributes (Model Settings -> Model -> Attributes) are saved and used as relative paths
  • The behaviour is changed: now a property in the generated code is initialized basing on the default value in CSDL only (instead of default values in any of SSDL and CSDL)
  • The behaviour is changed: now the default value for the 'File Per Class' option of the DbContext template is True
  • The behaviour is changed: Generate Database Script From Model saves the output in ASCII format if there are no unicode symbols in the script; UTF-8 is used otherwise
  • The behaviour is changed: now the default values are not set for string properties, that correspond to fields with the default values like expressions

Entity Framework

  • The 6.0.0 and 6.0.1 versions of Entity Framework are supported
  • Entity Framework 6.1.0 RTM is supported
  • Entity Framework 6.1.0 Tools for Visual Studio 2012 & 2013 are supported
  • The releasing of memory, which was allocated for commands and readers of ObjectContext / DbContext, is improved
  • The compatibility of Entity Framework provider for EF v1, v4, v5 with medium trust level environment is improved
  • Determining correct datatypes of data retrieved by EntitySQL queries with UNION ALL and similar constructions is improved
  • The compatibility with Hibernating Rhinos EntityFramework Profiler is improved

04-April-13 New features in dotConnect for Salesforce 2.3

  • Visual Studio 2013 Release Candidate is supported
  • Salesforce Web Services API version 28 is supported
  • The BETWEEN construction of SQL-92 is supported
  • The IN construction in the WHERE part of SQL-92 statement is supported
  • The "Use Assignment Rules" connection string parameter is added
  • The possibility of setting proxy connection string parameters via interface of Demo Center application is implemented
  • The behaviour is changed: provider's build action is installed on the target workstation, on which .NET Framework is available, without Visual Studio integration
  • The behaviour is changed: the keywords of SQL-92 are quoted by Devart Salesforce Source component in SSIS projects

Entity Developer

  • A new MVC Controller template, generating a ASP.NET MVC controller with data access code, is added
  • A new MVC View Advanced template, generating an ASP.NET MVC view based in Twitter Bootstrap, is added
  • A new Data Transfer Object template for DTO classes generation is implemented
  • A new Data Annotation Metadata template, generating Data Annotation metadata classes and decorating classes and properties with data annotation attributes for validation, presentation and defining metadata, is added
  • A new WCF RIA Domain Service template, generating a WCF RIA Services domain service class for a Devart Entity Framework model is added
  • The design time support for model-defined functions is added
  • Add Template dialog box is improved
  • The Namespace property of class, complex type, enum is implemented
  • The Entity Container Namespace properties of the model is implemented
  • The support for enums declared in external assemblies is implemented
  • The capability for setting special rules for generating default names of database objects when using the Model First approach is implemented (a new Advanced page is added to the Synchronization->Database Naming section of the Model Settings dialog box)
  • The capability to customize properties that are automatically added when creating a new entity, and options that are automatically set when creating a new property is added (a new Initialization page is added to the Model->General section of the Model Settings dialog box)
  • The Refresh option in the Attributes tab of the Model Settings window is implemented; it updates the list of available attributes types in the referenced assemblies
  • The capability to modify custom attributes for several selected entities or properties at the same time is implemented
  • Automatic adding of references to Entity Framework specific assemblies when adding a new Devart Entity model to a project is implemented
  • The capability to cancel metadata reading in wizards and Database Explorer is added
  • New setting "Detect Table Per Type inheritances", which enables automatic detection of TPT inheritances, is added for Create Model Wizard and model
  • A new shortcut menu command "Include Related", which allows making a copy of the related objects in the specified diagram, is added
  • A new shortcut menu command "Add To Model with Related", which allows adding tables, related to the selected one, to the model, is added to the shortcut menu of tables in Database Explorer
  • A new shortcut menu command "Add On Diagram With Related", which allows creating an object and all the objects related to it on a diagram, is added to the shortcut menu of classes, complex types, and enums in Model Explorer
  • New "Simple" diagram skin is added for displaying a diagram in metro style
  • The "Default Width" diagram property for specifying the default width for newly created diagram shapes (entities, complex types and enums) is added
  • The Save and Refresh buttons for persisting and reloading changes to / from a database is added to the Retrieve Data grid
  • The "WCF DataMember Attribute on Navigation Properties" property is added to the DbContext and POCO templates for pointing the end (-s) where the attribute should be generated
  • The "Regenerate Storage and Mapping" option for regenerating model parts, specific to the database server, is added to the diagram shortcut menu
  • The "Model Name As Files Prefix" property is implemented for the templates which generate classes for model entities
  • The possibility of adding custom attributes to enum members is implemented
  • DbContext template is improved: a "WCF Data Contract Attributes" setting for generation of DataContract, KnownType, and DataMember attributes for classes and properties is added
  • DbContext template is improved: "Implement INotifyPropertyChanging" and "Implement INotifyPropertyChanged" template settings are added
  • DbContext template is improved: a new "Mapping Generation Strategy" property that determines the method of mapping generation is implemented
  • POCO template is improved: a new "WCF Data Contract Attributes" setting for generating DataContract, KnownType, and DataMember attributes for classes and properties is added
  • POCO template is improved: "Proxy Creation Enabled" setting is implemented
  • POCO template is improved: new template settings, "Implement INotifyPropertyChanging" and "Implement INotifyPropertyChanged", are added
  • The "Rewrite connection string during regeneration" option (default value is True) of model settings is added to provide the possibility to turn off modifying connection string in *.config after model is saved first time
  • Create Model Wizard is improved: it is now able to download and install the required 'EnityFramework' Nuget package for Entity Framework 6 models, and for models for Entity Framework 4 and 5 in case they use the DbContext template
  • The Storage Column Editor dialog box is improved: the possibility to specify different settings that were previously available only in the Properties docking window are implemented
  • Class Editor is improved: the capability to edit extended property settings, such as validation, presentation, and facets, is added
  • Type Editor is improved: the capability to edit extended property settings, such as validation, presentation, and facets, is added
  • Storage Entity Editor is improved: the capability to edit extended columns settings, such as facets, is added
  • The "Close the window when the generation completes successfully" option in the Generation Process window is implemented in the standalone Entity Developer
  • The behaviour is changed: now, when creating a new TPH discriminator column in Inheritance Editor, it has the string type by default
  • The behaviour is changed: the error is generated if the Abstract inheritance modifier is set for the class which is involved in the Table Per Type inheritance
  • The behaviour is changed: empty value is used in property editors instead of -1 for marking facets of class property without assigned value
  • The behaviour is changed: a string default value for the property can be set without quotes in the Properties window
  • The behaviour is changed: the validation error is not generated when an abstract class is used in Table Per Type inheritance
  • The behaviour is changed: auto-implemented properties are generated when DbContext template is used with ImplementINotifyPropertyChanged=False and ImplementINotifyPropertyChanging=False
  • The behaviour is changed: DatabaseGeneratedOption is always generated for EntityKey properties when using fluent mapping
  • The behaviour is changed: a default value for the "Detect Table Per Type inheritances" option in Model settings is set to False
  • The behaviour is changed: the possibility to exclude the generation of keys (primary, foreign) in "Update Database From Model" and "Generate Database Script From Model " wizards is added
  • The behaviour is changed: now by default MVC Controller template generates files in the model folder, MVC View Advanced template creates files in the Views model subfolder
  • The behaviour is changed: now connection string is configured with the name of the assembly, where the model is located, in case when the context class is located in another assembly

Entity Framework

  • Entity Framework 6 Release Candidate 1 is supported

17-January-13 New features in dotConnect for Salesforce 2.2

  • The GetUpdatedIds and GetDeletedIds methods (Data Replicaton API) of the SalesforceConnection class are implemented
  • The GetUserInfo method of the SalesforceConnection class is implemented

Entity Developer

  • The possibility of setting enum values via predefined dropdown list in the Retrieve Data window is implemented
  • The behaviour is changed: warnings about tables/views without primary keys are written to Error List window when generating a model
  • The behaviour is changed: the EntityKey attribute is not assigned to each property of the class if there is no primary key in the corresponding table/view
  • The behaviour is changed: empty value is used in property editors instead of -1 for marking facets of Storage Column without assigned value

Entity Framework

  • Entity Framework 6 Alpha 3 is supported
  • Devart.Data.Salesforce.Entity.dll assembly compiled with EntityFramework.dll 6.0 and NET Framework 4.0 is added

20-December-12 New features in dotConnect for Salesforce 2.1

Entity Developer

  • Model Refactoring feature is implemented; it speeds up creating complex types and Table Per Type and Table Per Concrete Type inheritances from several model entities
  • Create Storage and Mapping command, that allows automatically creating of the corresponding storage part object and defining mapping, is added to the shortcut menu of classes, properties, and associations
  • Select Storage Object command, that allows quick navigation to the corresponding storage part object, is added to the shortcut menu of classes, properties, associations, and methods
  • The possibility to delete the corresponding storage part objects automatically when deleting conceptual model objects is added
  • The functionality of ignoring columns in the database in the "Update From Database" wizard if they were omitted once before is implemented
  • The Property Editor dialog is improved: fast access to the editor of the corresponding storage object and the possibility to specify different settings that were previously available only in the Properties docking window are implemented
  • The Inheritance Editor dialog is improved: specifying Discriminator column for Table Per Hierarchy inheritance in the editor is implemented
  • The Class Editor dialog is improved: fast access to the editor of the corresponding storage object is implemented
  • The Method Editor dialog is improved: fast access to the editor of the corresponding storage object is implemented
  • Warnings about objects that are not mapped are added
  • A SHIFT+DELETE keyboard shortcut for deleting entity, complex type, or enum from diagram only is added
  • An INSERT keyboard shortcut for creating a new entity, adding property to the selected entity/complex type or new member to enum is added
  • The possibility to view notes, added through the "Documentation" property, for all the diagram objects via hints is implemented
  • Hints for diagram objects are improved
  • The behaviour is changed: Configure Behaviour dialog is renamed to Stored Procedure Mapping; options for hiding inappropriate and mapped stored procedures are added
  • The behaviour is changed: Table Editor dialog is renamed to Storage Entity Editor
  • The behaviour is changed: Stored Procedure Editor dialog is renamed to Storage Procedure Editor

01-November-12 New features in dotConnect for Salesforce 2.0

  • SSIS DataFlow Source and Destination components for Salesforce are implemented

Entity Developer

  • The possibility to set different namespaces for the context and its entities when using the DbContext template is implemented (Entity Framework models)

06-September-12 New features in dotConnect for Salesforce 1.3

  • Visual Studio 2012 is supported
  • The Cache All connection string parameter and the SalesforceConnection.Cache.CreateForAll() method for caching data from all tables is added
  • The Default Refresh Interval connection string parameter for setting interval of refreshing data in cache is added

Entity Developer

  • Support for ADO.NET Entity Framework 5 is added
  • Predefined template for generating Repositories and Unit of Work classes is added
  • Integration with Visual Studio refactoring for renaming model objects is implemented
  • The "Use Database Comments" option of Model Settings is implemented to determine whether comments for database objects, if supported by DBMS, will be used for model objects Documentation initialization and taken into account when executing model or database update operations
  • The "Implement IClonable" option for the generated classes based on the model entities is added to all templates

Entity Framework

  • ADO.NET Entity Framework 5 is supported

22-May-12 New features in dotConnect for Salesforce 1.2

  • Visual Studio 2012 Release Candidate is supported
  • The Initialization Command connection string parameter is implemented
  • SOAP Header Options are supported
  • Salesforce Bulk API is supported
  • The Upgrade Cache connection string parameter for upgrading cache data in user's AppData\Roaming folder is implemented
  • The SalesforceCommand.QueryAll property for retrieving deleted records as well is implemented
  • The standard interface (without the 'SYS_' prefix and with specifying the INFORMATION_SCHEMA schema) when working with metadata tables is implemented
  • The behaviour is changed: the 'sender' parameter in MonitorEventHandler is a connection and the MonitorEventArgs.ExtraInfo property is filled with the connection string

Entity Developer

  • The possibility to unload assemblies from the main application domain by using separate application domain is implemented
  • The possibility to disable such Database First Settings as type mapping rules is implemented
  • The design time copy/cut/paste functionality for enum members is added
  • The sticker notes for adding comments to diagrams are implemented
  • The possibility to add a stamp, specifying diagram author, company, version, copyrights, project name, and date, to a diagram is implemented
  • New Collapse All and Expand All menu commands for collapsing and expanding diagram shapes are added
  • The "Pluralize collection navigation properties" option for the possibility to turn off the pluralization of the many-end names of associations is implemented
  • The behaviour is changed: context menu commands for working with diagram are grouped to the Diagram submenu of the context menu
  • The behaviour is changed: the possibility to change diagram shape color via the corresponding Shape -> Color context menu command is added
  • The behaviour is changed: when pasting a copied entity to a new diagram, a new entity is not created, the existing entity is added to this diagram
  • The behaviour is changed: when cutting an entity from the diagram, the entity is not cut from the model, only from the diagram
  • The behaviour is changed: "Update Model From Database" wizard places newly added properties to the base abstract class now instead of putting them into child classes (where the mapping is)

Entity Framework

  • The config.DmlOptions.InsertNullBehaviour feature with the InsertNull (default) and Omit options is implemented

15-Mar-12 New features in dotConnect for Salesforce 1.1

  • Visual Studio 11 Beta is supported
  • Salesforce Web Services API version 24 are supported
  • The INSERT statement with RETURNING clause support is added
  • The handling of empty options in the connection string is improved

Entity Developer

  • The copy/cut/paste functionality is added for objects of the conceptual part of a model
  • The possibility to drag&drop properties between classes in Model Explorer is implemented
  • The "HeaderTimestampVersionControlTag" generation template option is added for improving integration with version-control systems
  • The multiline popup editor for the Documentation.Summary property is implemented
  • The behaviour is changed: the Migrate option is added to the context menu of property in Model Explorer
  • The behaviour is changed: entities and enums on the designer surface are more resizable now

19-Jan-12 First Release of dotConnect for Salesforce 1.0