FlatDataSourceAdapterBase Class

Encapsulates a database connection and a select command, which are used to initialize a FlatDataSource instance with data obtained directly from a database.

Syntax

Visual Basic

'Declaration
 
Public MustInherit Class FlatDataSourceAdapterBase 

C#

public abstract class FlatDataSourceAdapterBase 

Remarks

A flat data source adapter serves as a bridge between a FlatDataSource instance and a database.

The adapter greatly simplifies the process of obtaining data from a non-OLAP database, and preparing it for display within an OLAP data consumer such as the WinPivotGrid.

A class which derives from FlatDataSourceAdapterBase handles connectivity and data retrieval for a specific database technology; for example, the OleDbAdapter class uses an OleDbConnection and an OleDbCommand to connect the FlatDataSource to a database using OleDb technology.

Similarly, the SqlAdapter class uses Sql-based technology to provide support for connecting to and retrieving data from a SQLServer database.

Requirements

Target Platforms: Windows 10, Windows 8.1, Windows 8, Windows 7, Windows Server 2012, Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2