dotConnect for SQL Server

.NET Connector for SQL Server with ORM Support

dotConnect for SQL Server 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.

dotConnect for SQL Server introduces new approaches for designing application architecture, boosts productivity, and leverages database application implementation.

Features

Direct access to SQL Server within 100% managed code
High performance
Operates in both connected and disconnected models
Powerful SqlDataTable component as all-in-one table data access solution
Auxiliary components for SQL scripts and bulk data transfer
ASP.NET Provider Model support
Extra data binding capabilities
Cross-form components cooperation
Ability of monitoring query execution
Easy to deploy
Supports the latest versions of SQL Server
All SQL Server data types support
Licensed royalty-free per developer, per team, or per site

Compatibility

The following table show which version of this package to use with which version of frameworks.

Frameworks	Version support
Entity Framework Core	8, 7, 6, 5, 3, 2, 1
.NET	8, 7, 6, 5
.NET Core	3, 2, 1
.NET Framework	4.8, 4.7, 4.6, 4.5

More information here

Usage

o establish a connection to a server, you have to provide some connection parameters to dotConnect for SQL Server. This information is used by the SqlConnection component to find the server and login with credentials of your account. The parameters are represented as connection string. You can compose the connection string manually or have dotConnect for SQL Server construct it for you.

This snippet directly configures a SQL Server connection using a connection string.

using Devart.Data.SqlServer;
...
SqlConnection sqlConnection = new SqlConnection();
sqlConnection.DataSource = "127.0.0.1";
sqlConnection.Database = "Test";
sqlConnection.UserId = "sa";
sqlConnection.Password = "mypassword";

Read the full documentation for connection here.

Wide Coverage of SQL Server Features

By providing access to the most advanced database functionality, dotConnect for SQL Server allows developers to harness the full capabilities of the SQL Server and optimize their database applications. dotConnect for SQL Server stands out as the set of components with the widest support of SQL Server functionality.

Optimized Code

The goal of dotConnect for SQL Server is to enable developers to 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.

Database Application Development Extensions

dotConnect for SQL Server has rich set of design time tools that leverage the development process greatly. Particularly, there are convenient design time component editors, wizards and managers for typed SQL Server-specific components, toolset for live data binding, cross-form components cooperation, and much more. dotConnect for SQL Server integrates tightly with Visual Studio 2008 - 2022 and Delphi.

Both Connected and Disconnected Models

dotConnect for SQL Server combines connected and disconnected data access models in single SqlDataTable component, which allows you to design more flexible application architecture and use full power of data binding.

Comprehensive Support for ADO.NET Technology Features

dotConnect for SQL Server supports new ADO.NET features and technologies as soon as they are released. This includes base-class-based provider model, 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 the .NET Framework.

License

See pricing options for ordering.

Trial Limitations

The dotConnect for SQL Server Evaluation License lets you try dotConnect for SQL Server Trial Edition for a period of 30 days. You may not use applications developed using Trial versions of the Software for any commercial purposes.

Devart Software