This section of the documentation contains topics that help you design powerful, flexible applications with use of dotConnect for SQL Server advanced features. The section describes how to employ best the components and technologies that constitute dotConnect for SQL Server.

• General Concepts in Database Application Development
  

  There are many database application development approaches, each with its own advantages and drawbacks. This topic describes some of 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.

• SqlDataTable Advanced Features
  

  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 single component with really comprehensive capabilities. In addition, it can accomplish data access tasks in both connected and disconnected models. This topic describes how you can use some of the SqlDataTable features.

• InterForm Technology
  

  Devart data providers intend to leverage design time aspects of development as much as possible. In this direction dotConnect for SQL Server introduces new technology that allows referencing components that reside on different forms of a WinForms application. This article describes the InterForm technology.

• DataLink Component Architecture
  

  This article provides information on how to implement advanced data binding with the DataLink component. The article describes advanced features of the component and shows how to use it together with the InterForm technology.

• Using DataSet Wizard
  

  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 you project. This topic provides information on every screen of DataSet Wizard.

• Using DataSet Manager
  

  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.

• Using DataSet Editor
  

  The DataSet Editor is designed to tweak DataSets, set all the necessary parameters for them, create and edit their DataTables, etc. This topic provides information on on how to Edit DataSets with DataSet Editor.

You can also find useful information in the Using dotConnect for SQL Server section of the documentation.