Code:
/ Dotnetfx_Win7_3.5.1 / Dotnetfx_Win7_3.5.1 / 3.5.1 / DEVDIV / depot / DevDiv / releases / Orcas / NetFXw7 / ndp / fx / src / DataEntity / System / Data / SqlClient / SqlGen / TopClause.cs / 1 / TopClause.cs
//---------------------------------------------------------------------- //// Copyright (c) Microsoft Corporation. All rights reserved. // // // @owner [....], [....] //--------------------------------------------------------------------- using System; using System.Collections.Generic; using System.Diagnostics; using System.Globalization; using System.IO; using System.Text; using System.Data.SqlClient; using System.Data.Metadata.Edm; using System.Data.Common.CommandTrees; namespace System.Data.SqlClient.SqlGen { ////// TopClause represents the a TOP expression in a SqlSelectStatement. /// It has a count property, which indicates how many TOP rows should be selected and a /// boolen WithTies property. /// class TopClause : ISqlFragment { ISqlFragment topCount; bool withTies; ////// Do we need to add a WITH_TIES to the top statement /// internal bool WithTies { get { return withTies; } } ////// How many top rows should be selected. /// internal ISqlFragment TopCount { get { return topCount; } } ////// Creates a TopClause with the given topCount and withTies. /// /// /// internal TopClause(ISqlFragment topCount, bool withTies) { this.topCount = topCount; this.withTies = withTies; } ////// Creates a TopClause with the given topCount and withTies. /// /// /// internal TopClause(int topCount, bool withTies) { SqlBuilder sqlBuilder = new SqlBuilder(); sqlBuilder.Append(topCount.ToString(CultureInfo.InvariantCulture)); this.topCount = sqlBuilder; this.withTies = withTies; } #region ISqlFragment Members ////// Write out the TOP part of sql select statement /// It basically writes TOP (X) [WITH TIES]. /// The brackets around X are ommited for Sql8. /// /// /// public void WriteSql(SqlWriter writer, SqlGenerator sqlGenerator) { writer.Write("TOP "); if (sqlGenerator.SqlVersion != SqlVersion.Sql8) { writer.Write("("); } this.TopCount.WriteSql(writer, sqlGenerator); if (sqlGenerator.SqlVersion != SqlVersion.Sql8) { writer.Write(")"); } writer.Write(" "); if (this.WithTies) { writer.Write("WITH TIES "); } } #endregion } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007. //---------------------------------------------------------------------- //// Copyright (c) Microsoft Corporation. All rights reserved. // // // @owner [....], [....] //--------------------------------------------------------------------- using System; using System.Collections.Generic; using System.Diagnostics; using System.Globalization; using System.IO; using System.Text; using System.Data.SqlClient; using System.Data.Metadata.Edm; using System.Data.Common.CommandTrees; namespace System.Data.SqlClient.SqlGen { ////// TopClause represents the a TOP expression in a SqlSelectStatement. /// It has a count property, which indicates how many TOP rows should be selected and a /// boolen WithTies property. /// class TopClause : ISqlFragment { ISqlFragment topCount; bool withTies; ////// Do we need to add a WITH_TIES to the top statement /// internal bool WithTies { get { return withTies; } } ////// How many top rows should be selected. /// internal ISqlFragment TopCount { get { return topCount; } } ////// Creates a TopClause with the given topCount and withTies. /// /// /// internal TopClause(ISqlFragment topCount, bool withTies) { this.topCount = topCount; this.withTies = withTies; } ////// Creates a TopClause with the given topCount and withTies. /// /// /// internal TopClause(int topCount, bool withTies) { SqlBuilder sqlBuilder = new SqlBuilder(); sqlBuilder.Append(topCount.ToString(CultureInfo.InvariantCulture)); this.topCount = sqlBuilder; this.withTies = withTies; } #region ISqlFragment Members ////// Write out the TOP part of sql select statement /// It basically writes TOP (X) [WITH TIES]. /// The brackets around X are ommited for Sql8. /// /// /// public void WriteSql(SqlWriter writer, SqlGenerator sqlGenerator) { writer.Write("TOP "); if (sqlGenerator.SqlVersion != SqlVersion.Sql8) { writer.Write("("); } this.TopCount.WriteSql(writer, sqlGenerator); if (sqlGenerator.SqlVersion != SqlVersion.Sql8) { writer.Write(")"); } writer.Write(" "); if (this.WithTies) { writer.Write("WITH TIES "); } } #endregion } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007.
Link Menu
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- SharedPersonalizationStateInfo.cs
- TreeIterators.cs
- ThreadStateException.cs
- DataControlFieldCollection.cs
- SqlServices.cs
- OdbcReferenceCollection.cs
- FileInfo.cs
- DataErrorValidationRule.cs
- ContextMarshalException.cs
- SymbolMethod.cs
- SqlDataSourceCustomCommandEditor.cs
- WeakEventTable.cs
- ConstructorBuilder.cs
- PostBackOptions.cs
- SecurityHelper.cs
- XmlSiteMapProvider.cs
- RotateTransform.cs
- CursorInteropHelper.cs
- PackageStore.cs
- TreeNodeStyle.cs
- XmlTextAttribute.cs
- SchemaImporterExtensionElementCollection.cs
- SessionStateContainer.cs
- columnmapkeybuilder.cs
- UnicastIPAddressInformationCollection.cs
- FunctionMappingTranslator.cs
- TextEndOfParagraph.cs
- UnsafeNativeMethods.cs
- XmlSchemaAppInfo.cs
- Operator.cs
- AnnotationComponentChooser.cs
- XmlEntityReference.cs
- DataGridCheckBoxColumn.cs
- TypeElement.cs
- securitycriticaldataformultiplegetandset.cs
- AspNetPartialTrustHelpers.cs
- Command.cs
- path.cs
- _SingleItemRequestCache.cs
- SoapElementAttribute.cs
- ExpandCollapsePattern.cs
- FixedSOMImage.cs
- UpdatePanel.cs
- StringSource.cs
- ImageDrawing.cs
- WebCodeGenerator.cs
- DaylightTime.cs
- DCSafeHandle.cs
- Rotation3D.cs
- MenuItemBindingCollection.cs
- BorderSidesEditor.cs
- Convert.cs
- InkCanvasInnerCanvas.cs
- PointHitTestResult.cs
- Journaling.cs
- CodeAttributeDeclaration.cs
- IISMapPath.cs
- _SSPIWrapper.cs
- Validator.cs
- ToolboxBitmapAttribute.cs
- DesignerVerbToolStripMenuItem.cs
- SamlAdvice.cs
- Internal.cs
- PermissionSet.cs
- UITypeEditor.cs
- EnumUnknown.cs
- Tile.cs
- DecimalAnimationUsingKeyFrames.cs
- RefreshEventArgs.cs
- RowTypeElement.cs
- EncodingNLS.cs
- OleDbDataReader.cs
- FixedDocumentSequencePaginator.cs
- CorrelationQuery.cs
- RegularExpressionValidator.cs
- TraceData.cs
- MonitoringDescriptionAttribute.cs
- SweepDirectionValidation.cs
- EventLogTraceListener.cs
- TransformerInfo.cs
- RC2CryptoServiceProvider.cs
- EncodingNLS.cs
- TextComposition.cs
- Rotation3DAnimationBase.cs
- StylusEventArgs.cs
- XmlEntityReference.cs
- TargetException.cs
- WebResourceUtil.cs
- BaseCodeDomTreeGenerator.cs
- CacheOutputQuery.cs
- LoadedOrUnloadedOperation.cs
- ObjectFullSpanRewriter.cs
- __FastResourceComparer.cs
- RegexGroup.cs
- DateTimeValueSerializerContext.cs
- designeractionbehavior.cs
- TextDecorationLocationValidation.cs
- EventDescriptor.cs
- WebConfigurationFileMap.cs
- UnsafeNetInfoNativeMethods.cs