Skip to main content

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

public string GetSql(
    DBSchema schema
)

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.

See Also