New to Telerik Reporting? Start a free 30-day trial

GenerateSqlInfo

Class

Contains the information required to generate SQL statements from the visual query designer state. Used to convert query designer configurations into executable SQL commands.

Definition

Namespace:Telerik.Reporting.Data.Schema

Assembly:Telerik.Reporting.Data.Schema.dll

Syntax:

public class GenerateSqlInfo

Inheritance: objectGenerateSqlInfo

Constructors

GenerateSqlInfo()

public GenerateSqlInfo()

Properties

ConnectionString

string

Gets or sets the connection string used to establish the database connection. Contains all necessary parameters for connecting to the target database.

public string ConnectionString { get; set; }

Remarks:

Holds the complete connection string with server information, credentials, and database parameters for schema validation and query testing.

ProviderName

string

Gets or sets the data provider name that identifies the type of database connection. Used to determine the correct SQL syntax and dialect for the target database.

public string ProviderName { get; set; }

Remarks:

Specifies the database provider type (e.g., "System.Data.SqlClient", "System.Data.OleDb") for generating provider-specific SQL syntax.

QueryDesignerState

string

Gets or sets the JSON serialized state of the visual query designer. Contains the complete configuration of tables, fields, relations, and filters from the query builder interface.

public string QueryDesignerState { get; set; }

Remarks:

Contains JSON representation of tables, field selections, relationships, and filter criteria that gets converted into SQL SELECT statements.