C# SqlWriter类代码示例

		public override void WriteTo(SqlWriter writer) {
			base.WriteTo(writer);
			writer.WriteKeyword("DEFAULT ");
			writer.Write('(');
			writer.WriteScript(defaultValue, WhitespacePadding.None);
			writer.Write(')');
		}

		internal void WriteNonGlobalInternal(SqlWriter writer) {
			if (!quote) {
				writer.Write(Value);
			} else {
				base.WriteToInternal(writer, false);
			}
		}

		public override void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.WriteKeyword("CREATE XML SCHEMA COLLECTION ");
			writer.WriteScript(xmlSchemaCollectionName, WhitespacePadding.None);
			writer.WriteKeyword(" AS ");
			writer.WriteScript(expression, WhitespacePadding.None);
		}

 /// <summary>
 /// We delegate the writing of the fragment to the appropriate type.
 /// </summary>
 /// <param name="writer"></param>
 /// <param name="sqlGenerator"></param>
 public void WriteSql(SqlWriter writer, SqlGenerator sqlGenerator)
 {
   if (null != _sqlFragments)
   {
     foreach (object o in _sqlFragments)
     {
       string str = (o as String);
       if (null != str)
       {
         writer.Write(str);
       }
       else
       {
         ISqlFragment sqlFragment = (o as ISqlFragment);
         if (null != sqlFragment)
         {
           sqlFragment.WriteSql(writer, sqlGenerator);
         }
         else
         {
           throw new InvalidOperationException();
         }
       }
     }
   }
 }

		protected internal override void WriteToInternal(SqlWriter writer, bool isPartOfQualifiedName) {
			Debug.Assert(!isPartOfQualifiedName);
			if (global) {
				writer.WriteKeyword("GLOBAL ");
			}
			WriteNonGlobalInternal(writer);
		}

 public static Statement CreateAddColumnStatement(string tableName, Column column)
 {
     var writer = new SqlWriter();
     writer.Alter.Table.QuotedName(tableName).Add.Flush();
     WriteColumnDefinition(writer, column);
     return new Statement(writer.ToString(), Statement.StatementType.Text, Statement.ResultType.None);
 }

		public override void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.WriteKeyword("OPTION ");
			writer.Write('(');
			writer.WriteScriptSequence(options, WhitespacePadding.None, w => w.Write(", "));
			writer.Write(')');
		}

		protected internal override void WriteToInternal(SqlWriter writer, bool isPartOfQualifiedName) {
			if (IsWildcard) {
				writer.Write(Value);
			} else {
				base.WriteToInternal(writer, isPartOfQualifiedName);
			}
		}

		public override void WriteTo(SqlWriter writer) {
			base.WriteTo(writer);
			writer.WriteKeyword("CHECK ");
			writer.WriteScript(replication, WhitespacePadding.SpaceAfter);
			writer.WriteScript(predicate, WhitespacePadding.None);
			writer.Write(')');
		}

		public override void WriteTo(SqlWriter writer) {
			writer.WriteScript(serverName, WhitespacePadding.None, null, w => w.Write('.'));
			writer.WriteScript(databaseName, WhitespacePadding.None, null, w => w.Write('.'));
			writer.WriteScript(schemaName, WhitespacePadding.None, null, w => w.Write('.'));
			writer.WriteScript(tableName, WhitespacePadding.None);
			base.WriteTo(writer);
		}

 /// <summary>
 /// Initializes a new instance of the <see cref="ProcedureGenerator"/> class.
 /// </summary>
 /// <param name="table">The table.</param>
 public ProcedureGenerator(DatabaseTable table)
     : base(table)
 {
     SqlWriter = new SqlWriter(table, SqlType.Oracle);
     SqlWriter.InStoredProcedure = true;
     PackageName = "PACK_" + TableName;
 }

		public override void WriteTo(SqlWriter writer) {
			WriteCommentsTo(writer);
			writer.WriteFunction("UPDATE");
			writer.Write('(');
			writer.WriteScript(columnName, WhitespacePadding.None);
			writer.Write(')');
		}

		public override void WriteTo(SqlWriter writer) {
			writer.WriteFunction("COUNT");
			writer.Write('(');
			writer.WriteDuplicateRestriction(restriction, WhitespacePadding.SpaceAfter);
			writer.WriteScript(expression, WhitespacePadding.None);
			writer.Write(')');
		}

		protected internal override void WriteToInternal(SqlWriter writer, bool isPartOfQualifiedName) {
			if (isPartOfQualifiedName || (!IsBuiltinType)) {
				base.WriteToInternal(writer, isPartOfQualifiedName);
			} else {
				writer.WriteType(Value);
			}
		}

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