C# SqlWriter.Indent方法代码示例

		public override void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.WriteKeyword("IF ");
			using (writer.Indent()) {
				writer.WriteScript(condition, WhitespacePadding.SpaceAfter);
			}
			if (thenStatement is StatementBlock) {
				writer.WriteScript(thenStatement, WhitespacePadding.None);
			} else {
				using (writer.Indent()) {
					writer.WriteScript(thenStatement, WhitespacePadding.NewlineBefore);
				}
			}
			writer.WriteScript(elseStatement, WhitespacePadding.None, w => w.WriteKeyword(" ELSE "), null);
		}

		public override void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.WriteKeyword("BEGIN TRY");
			using (writer.Indent()) {
				writer.WriteScriptSequence(tryStatements, WhitespacePadding.NewlineBefore, w => w.Write(';'));
				writer.WriteLine(";");
			}
			writer.WriteKeyword("END TRY");
			writer.WriteLine();
			writer.WriteKeyword("BEGIN CATCH");
			using (writer.Indent()) {
				writer.WriteScriptSequence(catchStatements, WhitespacePadding.NewlineBefore, w => w.Write(';'));
				writer.WriteLine(";");
			}
			writer.WriteKeyword("END CATCH");
		}

		public override void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.Write('(');
			using (writer.Indent()) {
				writer.WriteScript(expression, WhitespacePadding.None);
			}
			writer.Write(')');
		}

		public override void WriteTo(SqlWriter writer) {
			writer.Write('(');
			using (writer.Indent()) {
				writer.WriteScript(select, WhitespacePadding.NewlineBefore);
			}
			writer.WriteLine();
			writer.Write(')');
			base.WriteTo(writer);
		}

		public override void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.Write('(');
			using (writer.Indent()) {
				writer.WriteScript(value, WhitespacePadding.NewlineBefore);
			}
			writer.WriteLine();
			writer.Write(')');
		}

		public override void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.WriteKeyword(any ? "ANY" : "ALL");
			writer.Write(" (");
			using (writer.Indent()) {
				writer.WriteScript(subquery, WhitespacePadding.None);
			}
			writer.Write(')');
		}

		public override void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.WriteScript(queryOptions, WhitespacePadding.NewlineAfter);
			writer.WriteKeyword("SELECT ");
			using (writer.Indent()) {
				selectQuery.WriteToWithoutSelect(writer);
				writer.WriteScript(queryHint, WhitespacePadding.SpaceBefore);
			}
		}

		public override void WriteTo(SqlWriter writer) {
			writer.Write('(');
			using (writer.Indent()) {
				writer.WriteScript(inner, WhitespacePadding.NewlineBefore);
				writer.WriteScriptSequence(joins, WhitespacePadding.NewlineBefore, null);
			}
			writer.WriteLine();
			writer.Write(')');
		}

		public override void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.WriteKeyword("EXISTS ");
			using (writer.Indent()) {
				writer.WriteLine("(");
				writer.WriteScript(selectQuery, WhitespacePadding.None);
			}
			writer.WriteLine();
			writer.Write(')');
		}

		public override sealed void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.WriteKeyword("WHEN ");
			using (writer.Indent()) {
				WriteMatchedTo(writer);
				writer.WriteKeyword(" THEN");
				writer.WriteLine();
				writer.WriteScript(operation, WhitespacePadding.None);
			}
		}

		public override void WriteTo(SqlWriter writer) {
			base.WriteTo(writer);
			writer.WriteKeyword("AS TABLE ");
			writer.Write('(');
			using (writer.Indent()) {
				writer.WriteScriptSequence(tableDefinitions, WhitespacePadding.NewlineBefore, w => w.Write(","));
			}
			writer.WriteLine();
			writer.Write(')');
		}

		public override void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.WriteKeyword("BEGIN");
			writer.WriteLine();
			using (writer.Indent()) {
				writer.WriteScriptSequence(statements, WhitespacePadding.None, w => w.WriteLine(";"));
				writer.WriteLine(";");
			}
			writer.WriteKeyword("END");
		}

		public override void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.WriteKeyword("DECLARE ");
			writer.WriteScript(variableName, WhitespacePadding.None);
			writer.WriteKeyword(" TABLE ");
			writer.Write('(');
			using (writer.Indent()) {
				writer.WriteScriptSequence(tableDefinitions, WhitespacePadding.NewlineBefore, w => w.Write(','));
			}
			writer.WriteLine();
			writer.Write(')');
		}

		public override void WriteTo(SqlWriter writer) {
			writer.WriteKeyword("FETCH ");
			writer.WriteScript(cursorPosition, WhitespacePadding.SpaceAfter);
			writer.WriteScript(cursorName, WhitespacePadding.None);
			if (destinationVariables.Count > 0) {
				using (writer.Indent()) {
					writer.WriteLine();
					writer.WriteKeyword("INTO ");
					writer.WriteScriptSequence(destinationVariables, WhitespacePadding.None, w => w.Write(", "));
				}
			}
		}

		public override sealed void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.WriteScript(queryOptions, WhitespacePadding.NewlineAfter);
			writer.WriteKeyword("INSERT ");
			using (writer.Indent()) {
				writer.WriteScript(topExpression, WhitespacePadding.SpaceAfter);
				writer.WriteLine();
				writer.WriteKeyword("INTO ");
				writer.WriteScript(destinationRowset, WhitespacePadding.None);
				WriteToInternal(writer);
				writer.WriteScript(QueryHint, WhitespacePadding.NewlineBefore);
			}
		}