This section of the documentation contains articles that help you design powerful, flexible applications with the use of dotConnect for SQL Server advanced features. It outlines how to best use the components and technologies that constitute dotConnect for SQL Server.
There are many database application development approaches, each with its own advantages and drawbacks. This article describes some of the database application design patterns applicable with dotConnect for SQL Server and lists their tradeoffs to help you decide which one best suits your development needs.
The SqlDataTable component is one of the most effective tools in the dotConnect for SQL Server arsenal. It combines connection to server, command object and data storage in a single component with really comprehensive capabilities. In addition, it can accomplish data access tasks in both connected and disconnected models. This article explains how you can use some of the SqlDataTable features.
Devart data providers are designed to make the most of design-time development features. In this dotConnect for SQL Server introduces new technology that allows referencing components that reside on different forms of a WinForms application. This article covers the InterForm technology.
This article provides information on how to implement advanced data binding with the DataLink component. It highlights advanced features of the component and shows how to use it together with the InterForm technology.
The DataSet Wizard is designed to create and manage typed provider-specific datasets. The wizard takes you step by step through the process of creating the typed SqlDataSet object and integrates it with your project. This article provides information on every screen of DataSet Wizard.
The DataSet Manager window displays the data sources in your project represented by SqlDataSet and SqlDataTable classes. You can use DataSet Manager to create a user interface with data-bound controls by dragging items from the window onto forms in the project. This article describes how to use DataSet Manager.
The DataSet Editor is designed to adjust DataSets, set all the necessary parameters for them, create and edit their DataTables, etc. This article explores how to Edit DataSets with DataSet Editor.
This section explains how to use the array binding feature in dotConnect for SQL Server, specifically batch operations with SqlCommand, to efficiently handle large volumes of data.
You can also find useful information in the Using dotConnect for SQL Server section of the documentation.