Interface ICustomQuerySupport

Adds support for providing a custom SQL query for a SQL-based data source item.

Namespace: Reveal.Sdk.Data

Assembly: Infragistics.Reveal.DataLayer.dll

Syntax

public interface ICustomQuerySupport

Remarks

Parameter placeholders in CustomQuery use the @ prefix.

The parameter identifier must start with a letter (A-Z/a-z) or underscore (_), and can then contain letters, digits (0-9) or underscores.

Examples of valid parameter names: @param, @_param, @param1.

To represent a literal @ in the SQL text, escape it as @@. For example, @@sessionvar is interpreted as the literal text @sessionvar and is not treated as a parameter placeholder.

Properties

CustomQuery

(Optional) Custom SQL query to use when getting data.

Declaration

string CustomQuery { get; set; }

Property Value

Type	Description
System.String