public override void WriteToStream(IndentStream stream)
{
stream.Write("DELETE");
if (TopExpr != null)
{
stream.Write(" ");
TopExpr.WriteToStream(stream);
}
stream.Write(" FROM ");
Table.WriteToStream(stream);
if (WithOptions != null && WithOptions.Count > 0)
{
stream.Write(" WITH(");
WithOptions.WriteToStreamWithComma(stream);
stream.Write(")");
}
if (OutputList != null && OutputList.Count > 0)
{
stream.WriteLine();
stream.Write("OUTPUT ");
OutputList.WriteToStreamWithComma(stream);
}
if (IntoTableExpr != null)
{
stream.WriteLine();
IntoTableExpr.WriteToStream(stream);
}
if (OutputList1 != null && OutputList1.Count > 0)
{
stream.WriteLine();
stream.Write("OUTPUT ");
OutputList.WriteToStreamWithComma(stream);
}
if (FromSourceList != null && FromSourceList.Count > 0)
{
stream.WriteLine();
stream.Write("FROM ");
FromSourceList.WriteToStreamWithComma(stream);
}
if (WhereExpr != null)
{
stream.WriteLine();
stream.Write("WHERE ");
WhereExpr.WriteToStream(stream);
}
if (OptionExpr != null)
{
stream.WriteLine();
OptionExpr.WriteToStream(stream);
}
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("INSERT INTO ");
Table.WriteToStream(stream);
if (ColumnsList != null && ColumnsList.Count > 0)
{
stream.Write("(");
ColumnsList.WriteToStreamWithComma(stream);
stream.Write(")");
}
if (WithExpr != null)
{
stream.Write(" ");
WithExpr.WriteToStream(stream);
}
if (OutputList != null && OutputList.Count > 0)
{
stream.WriteLine();
stream.Write("OUTPUT ");
OutputList.WriteToStreamWithComma(stream);
}
if (OutputIntoExpr != null)
{
stream.WriteLine();
OutputIntoExpr.WriteToStream(stream);
}
stream.WriteLine();
SelectFromExpr.WriteToStream(stream);
}
public override void WriteToStream(IndentStream stream)
{
stream.Write("UPDATE");
if (TopCount != null)
{
stream.Write(" ");
TopCount.WriteToStream(stream);
}
if (Table != null)
{
stream.Write(" ");
Table.WriteToStream(stream);
}
if (WithOptions != null && WithOptions.Count > 0)
{
stream.Write(" WITH(");
WithOptions.WriteToStreamWithComma(stream);
stream.Write(")");
}
stream.Write(" SET ");
SetColumnsList.WriteToStreamWithComma(stream);
if (OutputList != null && OutputList.Count > 0)
{
stream.WriteLine();
stream.Write("OUTPUT ");
OutputList.WriteToStreamWithComma(stream);
}
if (IntoExpr != null)
{
stream.WriteLine();
IntoExpr.WriteToStream(stream);
}
if (FromTableList != null && FromTableList.Count > 0)
{
stream.WriteLine();
stream.Write("FROM ");
FromTableList.WriteToStreamWithComma(stream);
}
if (WhereExpr != null)
{
stream.WriteLine();
stream.Write("WHERE ");
WhereExpr.WriteToStream(stream);
}
}