dotConnect for SQL Server History

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

New features in dotConnect for SQL Server 3.0

The current build is 3.0.142 from 31-Oct-2019

  • Visual Studio 2019 is supported
  • Deprecated design-time Synchronous API calls are no longer used with Visual Studio 2019 and Visual Studio 2017
  • The "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported by Devart DataSet Manager
  • The integration with Visual Studio 2019 is improved: now the installation detects both 2019 Release and 2019 Preview versions

New features in dotConnect for SQL Server 2.90

  • Visual Studio 2019 Release Candidate 4 is supported
  • Visual Studio 2017 is supported
  • The CancelEditRowIfUpdateFailed property, determining whether to call CancelEdit for the row after update of the row is failed when data binding is used, is added to SqlDataTable
  • The type of the Offset and Length properties of the ScriptProgressEventArgs class is changed from Int32 to Int64

New features in dotConnect for SQL Server 2.80

  • Visual Studio 2017 Release Candidate 4 is supported
  • Visual Studio 2015 is supported
  • The ColumnEncryptionKeyCacheTtl property that gets or sets the life time for column encryption key entries in the column encryption key cache for the Always Encrypted feature is added to the SqlConnection class
  • The ColumnEncryptionQueryMetadataCacheEnabled property that enables or disables query metadata caching for parameterized queries for the Always Encrypted feature is added to the SqlConnection class
  • The 'Do not install assemblies in the GAC' check box that allows disabling placing the provider assemblies to the GAC is added to the Install Wizard
  • The behaviour is changed: now the "Default Command Timeout" connection string parameter also affects SqlLoader behavior

New features in dotConnect for SQL Server 2.70

  • Visual Studio 2015 Release Candidate is supported
  • Visual Studio 2013 is supported
  • SqlUtils class is added
  • The SqlScript.Cancel() method is added to stop query execution
  • The SqlStatementExecute event is added to the SqlScript class
  • The enableExpiredSessionAutoDeletion and expiredSessionAutoDeletionInterval options for deleting expired sessions are added to the session-state store provider definition in the web.config file
  • 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: the SqlMonitor now hides information about the password connection string parameter

06-September-12 New features in dotConnect for SQL Server 2.60

  • Visual Studio 2013 Release Candidate is supported
  • Visual Studio 2012 is supported
  • Performance with the 'Connection Reset' connection string parameter is improved
  • The MultiSubnetFailover and ApplicationIntent connection string parameters are supported
  • The behaviour is changed: license verification is removed for the Standard edition

15-Mar-12 New features in dotConnect for SQL Server 2.50

  • Visual Studio 2012 Release Candidate is supported
  • The Initialization Command connection string parameter is implemented
  • The handling of empty options in the connection string is improved
  • The behaviour is changed: the 'sender' parameter in MonitorEventHandler is a connection and the MonitorEventArgs.ExtraInfo property is filled with the connection string
  • The behaviour is changed: the access modifier of the connectionString field of web provider classes is changed from private to protected

21-May-10 New features in dotConnect for SQL Server 2.40

  • Supported Visual Studio 2010 Service Pack 1
  • Implemented integration with Visual Web Developer 2008 and 2010 Express editions
  • DbTransactionBase class is added
  • TransactionStateChanging and TransactionStateChanged events are added to the DbConnectionBase class
  • Improved interface in DbLoader class - added string and integer indexers
  • Added overloads for methods of DbDataReaderBase class with column name parameter
  • Added the 'Validate Connection' connection string parameter to validate connection on its retrieving from pool
  • Implemented Default Command Timeout connection string parameter and SqlConnectionStringBuilder.DefaultCommandTimeout property
  • Implemented capability of extending base functionality of ASP.NET providers
  • Implemented host option for current process in dbMonitor
  • Added possibility for tracing the distributed transactions in DBMonitor
  • Changed the primary key of the aspnet_sessions table for ASP.NET Web providers (the ApplicationName column added)
  • Supported password salt in ASP.NET membership provider
  • Added BeginTransaction value to the MonitorEventType enum
  • Implemented the DbMonitor.EventQueueLimit property which allows to set the maximal allowed number of messages waiting for being processed by the dbMonitor application
  • The support of events which occur when connections are taken and returned to pool for processing SqlMonitor.TraceEvent is added
  • Changed behaviour: setting the DbDataTable.Connection property sets the InsertCommand.Connection, UpdateCommand.Connection, and DeleteCommand.Connection properties
  • Changed behaviour: when clearing the pool, the number of connections specified in 'Min Pool Size' is never removed
  • Improved Upgrade wizard
  • The "Use schema name" and "Use catalog name" check boxes are added to DataSet Wizard

15-Apr-10 New features in dotConnect for SQL Server 2.30

  • Supported Visual Studio 2010
  • Install Wizard improved (ability to automatically uninstall previous version added)
  • Added possibility to avoid connecting to dbMonitor.exe when using DbMonitor ancestors

20-Nov-09 New features in dotConnect for SQL Server 2.15

  • Integration with improved dbMonitor added
  • Added some DataSet Wizard design-time improvements

14-Jul-09 New features in dotConnect for SQL Server 2.05

  • Visual Studio 2010 Beta supported

13-Nov-08 New features in dotConnect for SQL Server 2.00

  • SQLDirect .NET renamed to dotConnect for SQL Server
  • SQL Server 2008 supported
  • Support for .NET Framework 1.x is discontinued
  • Renamed assemblies, namespaces, and classes (for information on upgrading your projects please refer to FAQ, section Subscriptions and Upgrades)

26-Dec-07 New features in SQLDirect .NET 1.50

  • Added DB server-based data paging for web applications
  • SqlDbDataSource design time improvements
  • ASP.NET demo pack added
  • SqlSelectStatement.TryParse method added
  • DataLink.DataSource property can refer to another DataLink component

20-Dec-07 New features in SQLDirect .NET 1.25

  • Visual Studio 2008 supported
  • Added Licensing Information dialog

27-Sep-07 New features in SQLDirect .NET 1.20

  • Added support for x64 architecture
  • Enhanced command builder with generation of row refresh statements
  • Added DbCommand.GetRecordCount() method to determine rows count of a request
  • Added INullable interface for provider specific types
  • Supported data binding for provider-specific types
  • Added capability to store connection string in a config file
  • Extended drag'n'drop capabilities in DataSet Manager
  • Add-in menu moved to Visual Studio package
  • Demo projects reorganized
  • Added CRM (Customer Relationship Management) demo project

04-Jun-07 First Release of SQLDirect .NET 1.00