Key Features of dotConnect for SQL Server

Compatibility

  • SQL Server 2022, 2019, 2017, 2016, 2014, 2012, 2008, 2005 (including Express editions), 2000, MSDE
  • x64 and x86 architecture
  • Windows, Linux, macOS

Platforms

  • .NET 5.0-9.0
  • .NET Core 2.x-3.0
  • .NET Frameworks 2.0–4.8
  • ASP.NET Core
  • Blazor
  • .NET MAUI (previously Xamarin)
  • Mono Framework 2.0+

.NET languages

  • C#
  • VB.NET
  • F#

ADO.NET architecture

  • Batch update support
  • Extended metadata information retrieval
  • Enhanced pooling control through the connection string
  • Connection string builder
  • Provider factory for generating key data access classes
  • Asynchronous command execution
  • Provider-specific types support

Performance

  • High overall performance
  • Intelligent fetch block size control
  • Advanced connection pooling
  • High performance batch processing
  • Native library pre-loading

IDE integration

Visual Studio

Microsoft Visual Studio 2008-2022

  • DataSet Wizard to create and edit typed SQL Server-oriented datasets
  • DataSet Manager to list and bind datasets in the project
  • DataSet Editor to edit dataset contents
  • Advanced design-time component and property editors
  • IntelliSense descriptions for dotConnect for SQL Server classes
  • Easy migration from ODBC and OLE DB .NET Data Providers with Migration Wizard
  • Syntax highlighting and SQL code completion in design-time editors
  • TableMappings editor
  • Convenient instant data preview and management at design time

Without design-time integration

  • Visual Studio Code
  • JetBrains ReSharper and Rider
  • CodeGear Delphi 2007
  • Embarcadero Delphi Prism
  • Support for the Enterprise Library Data Access Application Block (DAAB)

NuGet availability

Devart.Data.SqlServer 
dotnet add package Devart.Data.SqlServer

Script execution

  • Advanced script execution features with the SqlScript component
  • Support for executing individual statements in scripts
  • Support for executing huge scripts stored in files with dynamic loading

SQL execution monitoring

  • Extended SQL tracing capabilities with SqlMonitor component
  • Support for the dbMonitor utility for advanced tracing analysis and control
  • Per-component SQL tracing
  • Optional log output to the IDE

SQL Server technology support

  • All SQL Server data types support
  • User-defined functions support
  • SqlDump component to store a database or its parts as a script and then restore it
  • Ability to enable extensions with the EnableLoadExtension connection string parameters
  • SQL Server Online Backup API support

WinForms-specific features

  • Flexible data binding with the DataLink component
  • InterForm technology for cross-form components cooperation
  • Global position synchronization within a data source

Extended DataTable and DataSet functionality

  • Powerful SqlDataTable component for manipulating individual tables or query results
  • NonBlocking mode allows fetching data asynchronously in the background
  • On-demand data fetch for data-bound controls
  • Paginal access to query results
  • Server side master-detail relation based on queries
  • Support for Enterprise Library Data Access Application Block (DAAB)
  • Object-oriented building of SELECT statements
  • Extended warning and error information retrieval
  • Extended interface for processing execution exceptions
  • SqlDataAdapter.Fill method with sequential fetch support
  • Ability to defer fetching of some columns in a result set
  • Named parameters support