SelectQuery.GetSql(DBSchema) Method

Returns the SQL string corresponding to the current SelectQuery.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v18.2.dll

Declaration

C#

public string GetSql(
    DBSchema schema
)

VB.NET

Public Function GetSql(
    schema As DBSchema
) As String

Parameters

Name	Type	Description
schema	DBSchema	A DBSchema object.

Returns

Type	Description
String	A String value, specifying the query string.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the GetSql(DBSchema) method.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

Reporting_how-to-obtain-the-sql-string-that-has-been-automatically-constructed-for-a-table-t188966/CS/TableQueryGetSql/XtraReport1.cs#L33

// Obtain the database schema of the connected data source.
var sql = query.GetSql(sqlDataSource.Connection.GetDBSchema());

VB.NET

Reporting_how-to-obtain-the-sql-string-that-has-been-automatically-constructed-for-a-table-t188966/VB/TableQueryGetSql/XtraReport1.vb#L30

' Obtain the database schema of the connected data source.
Dim sql = query.GetSql(sqlDataSource.Connection.GetDBSchema())