Skip to main content

SqlDataSource Class

An SQL data source that provides data for the dashboard.

#Declaration

TypeScript
export class SqlDataSource extends DataSource

#constructor

Initializes a new instance of the SqlDataSource class.

#Declaration

TypeScript
constructor(
    dataSourceJSON?: any,
    serializer?: DevExpress.Analytics.Utils.ModelSerializer
)

#Parameters

Name Type Description
dataSourceJSON any

A JSON object used for dashboard deserialization. Do not pass this parameter directly.

serializer ModelSerializer

An object used for dashboard deserialization. Do not pass this parameter directly.

#Properties

#connection Property

#Declaration

TypeScript
connection: DevExpress.Dashboard.Model.SqlConnection

#Property Value

Type
SqlConnection

#queries Property

#Declaration

TypeScript
queries: ko.ObservableArray<DevExpress.QueryBuilder.Utils.ISqlQueryViewModel>

#Property Value

Type
ObservableArray<ISqlQueryViewModel>

#Methods

#getDisplayNamePrefix Method

#Declaration

TypeScript
getDisplayNamePrefix(): string

#Returns

Type
string

#getInfo Method

For internal use.

#Declaration

TypeScript
getInfo(): DevExpress.Analytics.Utils.ISerializationInfoArray

#Returns

Type Description
ISerializationInfoArray

An array of objects that provide serialization info.