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)