Code:
/ Net / Net / 3.5.50727.3053 / DEVDIV / depot / DevDiv / releases / Orcas / SP / 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
- Geometry3D.cs
- MemberAssignment.cs
- Panel.cs
- IApplicationTrustManager.cs
- AnimationClock.cs
- MetaTableHelper.cs
- InArgument.cs
- CorrelationTokenInvalidatedHandler.cs
- DocumentGridContextMenu.cs
- documentsequencetextview.cs
- LocalizabilityAttribute.cs
- WebDisplayNameAttribute.cs
- OrderByLifter.cs
- backend.cs
- DispatcherExceptionEventArgs.cs
- TypeDescriptionProviderAttribute.cs
- HttpException.cs
- TypeSystem.cs
- XPathAncestorQuery.cs
- EnvelopedPkcs7.cs
- DesignObjectWrapper.cs
- StateDesigner.LayoutSelectionGlyph.cs
- DataGridViewDataErrorEventArgs.cs
- RawStylusInput.cs
- BindingElementCollection.cs
- Vector3D.cs
- Pkcs9Attribute.cs
- BindingOperations.cs
- WebPartConnectionsConnectVerb.cs
- TypedTableHandler.cs
- ComplexTypeEmitter.cs
- ContractComponent.cs
- PixelShader.cs
- DataSourceGroupCollection.cs
- DSGeneratorProblem.cs
- GenerateDerivedKeyRequest.cs
- PaintValueEventArgs.cs
- WebBrowserNavigatedEventHandler.cs
- CodeStatementCollection.cs
- RelationshipManager.cs
- NaturalLanguageHyphenator.cs
- MessageSecurityOverMsmq.cs
- XmlSerializerSection.cs
- UnmanagedBitmapWrapper.cs
- SessionPageStatePersister.cs
- MULTI_QI.cs
- ColorConverter.cs
- TrustSection.cs
- NGCPageContentCollectionSerializerAsync.cs
- ProviderUtil.cs
- PolyLineSegment.cs
- ColorIndependentAnimationStorage.cs
- SystemIPv4InterfaceProperties.cs
- TrustSection.cs
- LayoutUtils.cs
- XmlSchemaFacet.cs
- DataTableMappingCollection.cs
- Typography.cs
- WebSysDescriptionAttribute.cs
- PerformanceCounterPermissionEntryCollection.cs
- InheritanceAttribute.cs
- SqlRetyper.cs
- DropShadowBitmapEffect.cs
- RecognizerStateChangedEventArgs.cs
- Guid.cs
- documentsequencetextpointer.cs
- AssemblyAssociatedContentFileAttribute.cs
- SimpleHandlerFactory.cs
- EventLog.cs
- AsyncPostBackTrigger.cs
- RowToParametersTransformer.cs
- MatrixAnimationUsingPath.cs
- SchemaAttDef.cs
- UncommonField.cs
- StopStoryboard.cs
- BlockCollection.cs
- AddInBase.cs
- ImageListUtils.cs
- WpfKnownMemberInvoker.cs
- KeyedByTypeCollection.cs
- ObjectQueryProvider.cs
- ReadOnlyDictionary.cs
- IPGlobalProperties.cs
- Parallel.cs
- Converter.cs
- PlaceHolder.cs
- WebPartDisplayModeCollection.cs
- AssemblyBuilder.cs
- Mapping.cs
- TraversalRequest.cs
- PropertySegmentSerializationProvider.cs
- MasterPageBuildProvider.cs
- SafeReadContext.cs
- DbProviderConfigurationHandler.cs
- MessageFilter.cs
- SqlTransaction.cs
- PtsHelper.cs
- TextCharacters.cs
- ProvidersHelper.cs
- ActivityPreviewDesigner.cs