TableQuery.GetSql(DBSchema) Method

Returns the SQL query corresponding to the current TableQuery.

Namespace: DevExpress.DataAccess.Sql

Assembly: DevExpress.DataAccess.v24.1.dll

NuGet Packages: DevExpress.DataAccess, DevExpress.Win.PivotGrid, DevExpress.Win.TreeMap

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 that is the database schema.

Returns

Type	Description
String	A String value that is the SQL query corresponding to the current TableQuery.

Remarks

To obtain the SQL query corresponding to the current TableQuery for the specified SQL data source, pass the object returned by the SqlDataSource.DBSchema property as the schema parameter.