dotConnect for SQL Server

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 4.1

The current build is 5.1.104 from 08-Nov-2024

Visual Studio 2022 version 17.5 Preview is supported

New features in dotConnect for SQL Server 4.0

Windows 11 is supported.
Visual Studio 2022 version 17.2 is supported.
Visual Studio 2022 version 17.3 Preview is supported.
Visual Studio 2022 version 17.5 Preview is supported

New features in dotConnect for SQL Server 3.0

Visual Studio 2019 is supported
Visual Studio 2019 version 16.11 Preview 2.0 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 "Optimize rendering for screens with different pixel densities" feature of Visual Studio 2019 is supported by Devart DataSet Editor
The integration with Visual Studio 2019 is improved: now the installation detects both 2019 Release and 2019 Preview versions
The SendCallStack property is added to the Devart.Common.DbMonitor class for possibility to turn off resource-demanding logging of CallStack
The Filter property is added to the Devart.Common.DbMonitor class for possibility to choose events being logged
The Devart.Common.DbMonitor class is improved: now values of the DateTime parameters sent to the dbMonitor tool are supplemented with milliseconds
The new command line option /disablegac that disables adding assemblies to GAC is added

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