.NET Connector for SQL Server With ORM Support

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

Connection details

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.

Performance details

The Most Extensive Compatibility for the Widest Variety of Projects

dotConnect for SQL Server is the only SQL Server/MariaDB provider that supports all modern platforms and technologies as well as multiple deprecated technologies, which will reduce the cost of supporting existing applications.

Platforms

.NET 5, 6, 7, 8
.NET Framework 2.0-4.8
.NET Core 1.x, 2.x, and 3.0
.NET Compact Framework 2.0 and higher
Mono 2.0 and higher

SQL Server Database

All versions

Microsoft Visual Studio

Visual Studio 2008-2022

Features

Database-Specific Features

dotConnect for SQL Server stands out as the set of components with the widest support for SQL Server functionality. Check the Features page to get the full list of supported capabilities.

Advanced Durability

dotConnect for SQL Server delivers data fetching control (background, on-demand, pagination) and server-side data relationships. Additionally, selective column loading and refresh operations help maintain performance at an all-time high.

Microsoft Technology Support

Our connector is seamlessly compatible with Microsoft's data-related technologies, such as Microsoft Enterprise Library, a variety of ASP.NET providers, ExtendedMembership providers, and Microsoft Sync Framework.

Secure Connection

Without a doubt, the safety of connections is a top priority. That's why dotConnect for SQL Server provides support for encryption protocols, including SSL and SSH, and allows using HTTPS tunneling.

Fast Data Loading

The SqlLoader component helps load large datasets into SQL Server databases with speed and precision. This leads to faster initialization and data population, as well as helps achieve remarkable performance during data-intensive operations.

Integration With Visual Studio

dotConnect for SQL Server can be perfectly integrated with Microsoft Visual Studio, enhancing the design-time experience with Server Explorer connections and convenient dataset management tools.

Leading companies choose Devart's products

Other .NET Connectors for Databases

Ready to get started?

Get started with dotConnect for MySQL at no cost

Get started with dotConnect for SQL Server at no cost

Download a FREE, fully-functional trial version and elevate your database development and administration today!

Download for free

Try dotConnect Universal

Universal access to data of different databases for the Microsoft .NET Framework. It supports most of major database servers, including Microsoft SQL Server, Microsoft Access, Oracle, DB2, MySQL, PostgreSQL, SQLite, InterBase, and Firebird

Get now

Need a hand?

If you need any help or have questions about our tools or purchasing options, just get in touch with our team.

Contact support