SQLiteSelectStatement stmt = new SQLiteSelectStatement(); stmt.Columns.Add(new SelectColumn("ENAME")); stmt.Tables.Add(new SelectTable("emp")); stmt.Where = "1000 < SAL AND SAL < 1500 OR JOB = 'SALESMAN'"; SQLiteCommand command = new SQLiteCommand(stmt.ToString());
Dim stmt As New SQLiteSelectStatement 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 SQLiteCommand(stmt.ToString)