Description

dotConnect for SQL Server, formerly known as SQLDirect .NET, is an enhanced data provider for SQL Server that builds on ADO.NET technology and SqlClient to present a complete solution for developing SQL Server-based database applications. As part of the Devart database application development framework, dotConnect for SQL Server offers both high-performance native connectivity to SQL Server and a number of innovative database development tools and technologies.

Direct access to SQL Server with no need for additional client libraries
Full compliance with ADO.NET
Broad compatibility with .NET platforms
Connection through SSL, SSH, proxy servers, and HTTP tunnels
Advanced encryption and data integrity
Integration with Visual Studio and design-time support

Direct connection to SQL Server
dotConnect for SQL Server allows connecting to SQL Server databases via TCP/IP without any need for native clients, which greatly simplifies application development and deployment.

Easy connection without SQL Server Client
Full support for SQL Server-specific data types
Robust security with advanced encryption and authentication
Flexible connectivity options for diverse operational environments
Cost-effective deployment

Full compliance with ADO.NET
dotConnect for SQL Server has a provider model that revolves around base classes, provider factories, connection string builder, metadata schemas, asynchronous commands, pooling enhancements, batch update support, provider-specific types, server enumeration, database change notification support, and so on. dotConnect for SQL Server will continue supporting the newest standards and innovations of .NET.

High performance
The goal of dotConnect for SQL Server is to help developers write efficient and flexible database applications. The dotConnect for SQL Server assemblies are implemented using optimized code and advanced data access algorithms. Components undergo comprehensive performance tests and are designed to help you write thin and efficient product data access layers.

5.2.190 27-Dec-24

.NET 9 compatibility
Supported Visual Studio 2022 version 17.13 Preview
Fixed an issue with applying the license key on Red Hat-based Linux systems (Red Hat 9, AlmaLinux 9, Rocky Linux 9) when the system-wide cryptographic policy was set to DEFAULT
Fixed an issue with the missing Name and Owner properties in the DbCommandBase class within .NET Standard 2.0 compliant assemblies

Additional Information