.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.

Easy access to SQL Server
Full compliance with ADO.NET
Broad compatibility with .NET platforms
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, which greatly simplifies application development and deployment.

Easy connection to SQL Server
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

Compatibility and Integration

Platforms

.NET 5.0, 6.0, 7.0, 8.0, 9.0
.NET Framework 2.0-4.8
.NET Core 2.x, 3.0
Mono 2.0 and higher

SQL Server Database

All versions

Visual Studio Extension

Data source connection
Database object explorer
Data retrieval and display

Compatibility with NuGet

Works in any NuGet-compatible IDE like VS Code, JetBrains Rider, etc

Compatibility details

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.

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.

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 dotConnect

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