| |||||
dotConnect for SQL Server is a great component which helps developers with their SQL Server connections and databases. 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.
Here are some key features of "dotConnect for SQL Server":
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 SQ L 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 2005/2008 and Delp hi.
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.
Direct access to SQL Server within 100% managed code:
· High performance
· Oper ates 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
Requirements:
· Visual Studio
· .NET Framework
Limitations:
· 30 days trial
What's Ne w in This Release: [ read full changelog ]
· The bug, that occurred when editing an existing Dataset in DataSet Wizard and which was associated with incorrect processing of 'Select command text' for Data tables having DataSource set to TableAdapter, is fixed

Via: dotConnect for SQL Server 2.60.639