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.

Definition

Namespace:Telerik.Reporting.Data.Schema

Assembly:Telerik.Reporting.Data.Schema.dll

Syntax:

cs-api-definition
public class GenerateSqlInfo

Inheritance: objectGenerateSqlInfo

Constructors

GenerateSqlInfo()

Declaration

cs-api-definition
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

cs-api-definition
public string ConnectionString { get; set; }

Property Value

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

cs-api-definition
public string ProviderName { get; set; }

Property Value

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

cs-api-definition
public string QueryDesignerState { get; set; }

Property Value

string

Remarks

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