Gets or sets WHERE clause of the statement.
public virtual string Where {get; set;}
'Declaration
Public Overridable Property Where As String
Property Value
The WHERE clause of the statement.
The following example demonstrates how to use the
Where property.
PgSqlSelectStatement stmt = new PgSqlSelectStatement();
stmt.Columns.Add(new SelectColumn("ENAME"));
stmt.Tables.Add(new SelectTable("emp"));
stmt.Where = "1000 < SAL AND SAL < 1500 OR JOB = 'SALESMAN'";
PgSqlCommand command = new PgSqlCommand(stmt.ToString());
Dim stmt As New PgSqlSelectStatement
stmt.Columns.Add(New SelectColumn("ENAME"))
stmt.Tables.Add(New SelectTable("emp"))
stmt.Where = "1000 < SAL AND SAL < 1500 OR JOB = 'SALESMAN'"
Dim command As New PgSqlCommand(stmt.ToString)