C# SqlWriter.WriteKeyword方法代码示例

		public override void WriteTo(SqlWriter writer) {
			writer.WriteKeyword("FOR UPDATE");
			if (columns.Count > 0) {
				writer.WriteKeyword(" OF ");
				writer.WriteScriptSequence(columns, WhitespacePadding.None, w => w.Write(", "));
			}
		}

		public override void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.WriteScript(valueExpression, WhitespacePadding.None);
			writer.WriteKeyword(" IS");
			base.WriteTo(writer);
			writer.WriteKeyword(" NULL");
		}

		public override void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.WriteKeyword("DROP INDEX ");
			writer.WriteScript(indexName, WhitespacePadding.None);
			writer.WriteKeyword(" ON ");
			writer.WriteScript(tableName, WhitespacePadding.None);
			writer.WriteScript(indexOptions, WhitespacePadding.SpaceBefore);
		}

		public override sealed void WriteTo(SqlWriter writer) {
			if (position != CursorPosition.None) {
				writer.WriteKeyword(position.ToString().ToUpperInvariant());
				writer.Write(' ');
			}
			WriteOffset(writer);
			writer.WriteKeyword("FROM");
		}

		protected override void WriteParameterQualifiers(SqlWriter writer) {
			if (varying) {
				writer.WriteKeyword(" VARYING");
			}
			base.WriteParameterQualifiers(writer);
			if (output) {
				writer.WriteKeyword(" OUTPUT");
			}
		}

		protected virtual void WriteMatchedTo(SqlWriter writer) {
			if (string.IsNullOrEmpty(NotMatchedBy)) {
				writer.WriteKeyword("MATCHED");
			} else {
				writer.WriteKeyword("NOT MATCHED BY ");
				writer.WriteKeyword(NotMatchedBy);
			}
			writer.WriteScript(predicate, WhitespacePadding.None, w => w.WriteOperator(" AND "), null);
		}

		public override void WriteTo(SqlWriter writer) {
			if (HasValue) {
				writer.WriteKeyword("USING XML INDEX ");
				writer.WriteScript(indexName, WhitespacePadding.None);
				writer.WriteLine();
				writer.WriteKeyword("FOR ");
				writer.Write(IndexForSpecifier);
			}
		}

		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) {
			writer.WriteKeyword(" TRIGGER ");
			if (All) {
				writer.WriteKeyword("ALL");
			} else {
				writer.WriteScriptSequence(triggerNames, WhitespacePadding.None, w => w.Write(", "));
			}
			writer.WriteKeyword(" ON ");
			writer.WriteScript(target, WhitespacePadding.None);
		}

		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.WriteEnum(tableCheck, WhitespacePadding.SpaceAfter);
			WriteCheckOperation(writer);
			writer.WriteKeyword(" CONSTRAINT ");
			if (constraintName != null) {
				writer.WriteScript(constraintName, WhitespacePadding.None);
			} else {
				writer.WriteKeyword("ALL");
			}
		}

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

		public override void WriteTo(SqlWriter writer) {
			writer.WriteKeyword("FOR XML ");
			writer.WriteKeyword(KindSpecifier);
			if (elementName != null) {
				writer.Write(" (");
				writer.WriteScript(elementName, WhitespacePadding.None);
				writer.Write(')');
			}
			if (directives.Count > 0) {
				writer.Write(", ");
				writer.WriteScriptSequence(directives, WhitespacePadding.None, w => w.Write(", "));
			}
		}