ToString Method (SelectStatement)

In This Topic

Returns SQL statement in the text form.

Syntax

Visual Basic
C#


'Declaration Public Overrides Function ToString() As String


public override string ToString()

Return Value

The text of SQL statement that is equivalent to current state of the SelectStatement object.

Example

The following example demonstrates how to use the ToString method.

csharp


PgSqlSelectStatement stmt = new PgSqlSelectStatement(); stmt.Columns.Add(new SelectColumn("JOB")); stmt.Tables.Add(new SelectTable("emp")); stmt.Distinct = true; //select distinct JOB from emp string queryText = stmt.ToString();

PgSqlSelectStatement stmt = new PgSqlSelectStatement();
stmt.Columns.Add(new SelectColumn("JOB"));
stmt.Tables.Add(new SelectTable("emp"));

stmt.Distinct = true;

//select distinct JOB from emp
string queryText = stmt.ToString();

Visual Basic


Dim stmt As New PgSqlSelectStatement stmt.Columns.Add(New SelectColumn("JOB")) stmt.Tables.Add(New SelectTable("emp")) stmt.Distinct = True 'select distinct JOB from emp Dim queryText As String = stmt.ToString

Dim stmt As New PgSqlSelectStatement
stmt.Columns.Add(New SelectColumn("JOB"))
stmt.Tables.Add(New SelectTable("emp"))
stmt.Distinct = True

'select distinct JOB from emp
Dim queryText As String = stmt.ToString

Reference

SelectStatement Class
SelectStatement Members

Send Feedback