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);
}