public override void WriteSetSqlVariable(SqlPlaceholder variable, SqlExpression expr, StringBuilder writer)
{
writer.Append("SET ");
WritePlaceholder(variable, writer);
writer.Append(" = ");
WriteExpression(expr, writer);
writer.AppendLine(";");
}
public override void WritePlaceholder(SqlPlaceholder placeholder, StringBuilder writer)
{
if (placeholder.PlaceholderType == SqlPlaceholderType.SessionVariableName)
{
writer.Append("@" + placeholder.RawSql);
}
else
{
throw new InvalidOperationException("Unsupported placeholder " + placeholder.PlaceholderType);
}
}
public override void WritePlaceholder(SqlPlaceholder placeholder, StringBuilder writer)
{
if (placeholder.PlaceholderType == SqlPlaceholderType.SessionVariableName)
{
writer.Append("(SELECT ");
WriteColumnName(placeholder.RawSql, writer);
writer.Append(" FROM \"_typedsql_variables\")");
}
else
{
throw new InvalidOperationException("Unsupported placeholder " + placeholder.PlaceholderType);
}
}
public override void WriteSetSqlVariable(SqlPlaceholder variable, SqlExpression expr, StringBuilder writer)
{
writer.Append("UPDATE \"_typedsql_variables\" SET ");
if (variable.PlaceholderType == SqlPlaceholderType.SessionVariableName)
{
WriteColumnName(variable.RawSql, writer);
}
else
{
throw new InvalidOperationException("Unsupported placeholder in variable assignment " + variable.PlaceholderType);
}
writer.Append(" = ");
WriteExpression(expr, writer);
writer.AppendLine(";");
}
public virtual void Visit(SqlPlaceholder node)
{
}
public void Visit(SqlPlaceholder node)
{
}
