public RawQuery GetRawQuery() { RawQuery rq = new RawQuery(); rq.Append("DELETE FROM ") .AppendTableName(Table.Name, Table.Schema); var whereRawQuery = _whereBuilder.GetRawQuery(); if (!whereRawQuery.IsEmpty) { rq.Append(" WHERE "); rq.Append(whereRawQuery); } rq.SkipExplicitColumnTableNames(); return(rq); }
public RawQuery GetRawQuery() { RawQuery rq = new RawQuery(); rq.Append("UPDATE ") .AppendTableName(Table.Name, Table.Schema) .Append("\n"); rq.Append("SET "); bool first = true; foreach (var(column, typedExpression) in _updateStatementsBuilder.UpdateParts) { if (!first) { rq.Append(", "); } rq.AppendColumnName(column.Name) .Append(" = ") .Append(typedExpression.RawQuery); first = false; } rq.Append("\n"); var whereRawQuery = _whereBuilder.GetRawQuery(); if (!whereRawQuery.IsEmpty) { rq.Append("WHERE ") .Append(whereRawQuery); } rq.SkipExplicitColumnTableNames(); return(rq); }