Class RVSqlServerDataSourceItem

Microsoft SQL Server data source item

Inheritance

System.Object

RVSqlServerDataSourceItem

RVAzureSqlDataSourceItem

RVAzureSynapseDataSourceItem

Namespace: Reveal.Sdk.Data.Microsoft.SqlServer

Assembly: Infragistics.Reveal.Connectors.MsSql.dll

Syntax

public class RVSqlServerDataSourceItem : RVSqlPDSDataSourceItem

Constructors

RVSqlServerDataSourceItem(RVSqlServerDataSource)

Declaration

public RVSqlServerDataSourceItem(RVSqlServerDataSource dataSource)

Parameters

Type	Name	Description
RVSqlServerDataSource	dataSource

RVSqlServerDataSourceItem(RVSqlServerDataSource, BaseDataSourceItem)

Declaration

public RVSqlServerDataSourceItem(RVSqlServerDataSource dataSource, BaseDataSourceItem modelDataSourceItem)

Parameters

Type	Name	Description
RVSqlServerDataSource	dataSource
Infragistics.ReportPlus.DashboardModel.BaseDataSourceItem	modelDataSourceItem

Properties

Procedure

(Optional) name of the stored procedure to get data from, the procedure is expected to return a result set and might have multiple parameters.

Declaration

public string Procedure { get; set; }

Property Value

Type	Description
System.String

ProcedureParameters

Parameters to be passed to the stored procedure, if there is such specified in Procedure.

Declaration

public Dictionary<string, object> ProcedureParameters { get; set; }

Property Value

Type	Description
System.Collections.Generic.Dictionary<System.String, System.Object>

Schema

Name of the schema the referenced table belongs to

Declaration

public string Schema { get; set; }

Property Value

Type	Description
System.String

Methods

CreateModelDataSourceItem()

Declaration

public override BaseDataSourceItem CreateModelDataSourceItem()

Returns

Type	Description
Infragistics.ReportPlus.DashboardModel.BaseDataSourceItem