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
- RegexReplacement.cs
- ParserContext.cs
- PropertyChangedEventManager.cs
- IPAddress.cs
- CacheDependency.cs
- DataTable.cs
- RedirectionProxy.cs
- LoadMessageLogger.cs
- TimestampInformation.cs
- ObjectDataSourceMethodEventArgs.cs
- HttpContext.cs
- PersonalizationStateQuery.cs
- DataServiceContext.cs
- TargetFrameworkAttribute.cs
- DataGridViewSelectedColumnCollection.cs
- BufferedWebEventProvider.cs
- ObjectListSelectEventArgs.cs
- Column.cs
- cookieexception.cs
- EncodingInfo.cs
- ACL.cs
- NotifyCollectionChangedEventArgs.cs
- TypedCompletedAsyncResult.cs
- CqlParserHelpers.cs
- Ppl.cs
- DataGridHeaderBorder.cs
- SoapSchemaMember.cs
- KeyConstraint.cs
- Privilege.cs
- ChildTable.cs
- BasicCellRelation.cs
- XmlAutoDetectWriter.cs
- DbDataRecord.cs
- SectionInput.cs
- PageContentCollection.cs
- MSAAWinEventWrap.cs
- InstallerTypeAttribute.cs
- DocumentStream.cs
- ComponentEvent.cs
- XmlSchemaCompilationSettings.cs
- ContextTokenTypeConverter.cs
- AutoResizedEvent.cs
- PackageRelationshipCollection.cs
- FormCollection.cs
- SqlTopReducer.cs
- BitmapEffectDrawingContextWalker.cs
- DetailsViewPagerRow.cs
- TdsParserSafeHandles.cs
- TypographyProperties.cs
- AssemblyBuilderData.cs
- AutoResizedEvent.cs
- BitmapEffectDrawingContextState.cs
- SqlClientWrapperSmiStreamChars.cs
- StateBag.cs
- ProxyWebPart.cs
- CodeSubDirectoriesCollection.cs
- Freezable.cs
- ToolStripScrollButton.cs
- PerfService.cs
- BitmapEffect.cs
- XmlUtf8RawTextWriter.cs
- FixedTextSelectionProcessor.cs
- WeakReference.cs
- ExceptionAggregator.cs
- GridViewDeleteEventArgs.cs
- FormViewInsertEventArgs.cs
- SymLanguageType.cs
- ServiceContractViewControl.Designer.cs
- ProjectionPruner.cs
- RtfFormatStack.cs
- PrivateFontCollection.cs
- XmlILAnnotation.cs
- FtpCachePolicyElement.cs
- CodeNamespaceImportCollection.cs
- ProofTokenCryptoHandle.cs
- SafeRightsManagementEnvironmentHandle.cs
- TTSEvent.cs
- CultureSpecificStringDictionary.cs
- SessionStateContainer.cs
- WindowsStatusBar.cs
- LinkButton.cs
- WSFederationHttpBindingElement.cs
- filewebrequest.cs
- SecurityKeyUsage.cs
- FormattedTextSymbols.cs
- ToolStripGripRenderEventArgs.cs
- ToolStripOverflowButton.cs
- XmlSchemaGroup.cs
- Label.cs
- WmlImageAdapter.cs
- ContentElement.cs
- SourceSwitch.cs
- PointConverter.cs
- JsonReaderDelegator.cs
- ObjectDataSourceEventArgs.cs
- WorkerRequest.cs
- XmlSchemaSimpleContent.cs
- ExtractorMetadata.cs
- Cursor.cs
- BinHexEncoder.cs