Class GenerateSqlInfo

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

Inheritance

System.Object

GenerateSqlInfo

Namespace: Telerik.Reporting.Data.Schema

Assembly: Telerik.Reporting.Data.Schema.dll

Syntax

public class GenerateSqlInfo

Remarks

This class serves as a data transfer object for SQL generation services in the Web Report Designer's query builder.

Constructors

GenerateSqlInfo()

Declaration

public GenerateSqlInfo()

Properties

ConnectionString

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

Declaration

public string ConnectionString { get; set; }

Property Value

System.String

Remarks

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

ProviderName

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.

Declaration

public string ProviderName { get; set; }

Property Value

System.String

Remarks

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

QueryDesignerState

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.

Declaration

public string QueryDesignerState { get; set; }

Property Value

System.String

Remarks

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