dotConnect for SQL Server

An enhanced data provider for SQL Server that builds on ADO.NET technology and SqlClient for developing SQL Server-based database applications.

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 development tools and technologies.

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

Key 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

dotConnect for SQL Server - Features

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 development tools and technologies.

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

Key Features

The following list describes the main features of dotConnect for SQL Server.

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

Back to top

Features

• Direct access to SQL Server within 100% managed code
• High performance
• Operates in both connected and disconnected models
• Powerful SqlDataTable component to retrieve and manipulate data
• SqlScript component to execute scripts with streaming support
• SqlLoader component for fast loading data
• DataLink component for flexible data binding
• Ability of monitoring query execution
• Cross-form components cooperation
• Advanced connection pooling feature
• Base-Class-Based provider model
• Paginal access to query result
• Asynchronous execution support
• SqlSelectStatement class for building SELECT statements
• Ability to retrieve metadata information
• Advanced design-time editors
• DataSet Manager and DataSet Editor
• DataSet Wizard to leverage design-time setup
• Generate DataSet Wizard
• ASP.NET data providers: Membership provider, Role provider, Session State provider, Profile provider
• TableMappings editor
• Data preview
• Advanced integration with Visual Studio 2005, including Server Explorer, Data Source wizard, TableAdapter configuration, Query Builder and configuring web component SqlDataSource
• Easy migration from ODBC and OLE DB .NET Data Providers with Migration Wizard
• Easy to deploy
• Supports the latest versions of SQL Server
• All SQL Server data types support
• Help integrated into Visual Studio .NET and Borland Delphi
• Included annual SQLDirect .NET Subscription with Priority Support
• Licensed per developer, per team, or per site with no royalty fee

New Features in Version 2.05

• Visual Studio 2010 Beta supported

Features in SQLDirect .NET Version 2.0

• SQLDirect .NET renamed to dotConnect for SQL Server
• SQL Server 2008 supported
• Support for .NET Framework 1.x is discontinued
• Renamed assemblies, namespaces, and classes

Back to top

dotConnect for SQL Server - System Requirements

dotConnect for SQL Server supports SQL Server 2005 (including Express editions), SQL Server 2000 and MSDE. The provider works with .NET Framework 2.0, 3.0, and 3.5, and can be used with the following development environments:

• Microsoft Visual Studio 2008
• Microsoft Visual Studio 2005
• Delphi Prism
• Delphi 2007