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
- ellipse.cs
- UpdatableWrapper.cs
- BufferedWebEventProvider.cs
- TemplateNameScope.cs
- WebPartConnectionsConnectVerb.cs
- StylusPointProperties.cs
- webeventbuffer.cs
- ListGeneralPage.cs
- LabelLiteral.cs
- PersonalizationStateInfoCollection.cs
- NameScope.cs
- DirectoryInfo.cs
- ConstantProjectedSlot.cs
- ImageIndexConverter.cs
- Brush.cs
- MulticastIPAddressInformationCollection.cs
- TimeoutException.cs
- PrintPageEvent.cs
- Encoding.cs
- sortedlist.cs
- AdapterUtil.cs
- DbConnectionPoolGroup.cs
- XmlReflectionMember.cs
- HttpMethodAttribute.cs
- MetadataHelper.cs
- DataErrorValidationRule.cs
- Opcode.cs
- userdatakeys.cs
- PageAsyncTask.cs
- GenerateScriptTypeAttribute.cs
- UnauthorizedAccessException.cs
- XmlAttributeHolder.cs
- PageBreakRecord.cs
- _AuthenticationState.cs
- SQLBytes.cs
- AmbientEnvironment.cs
- ParallelTimeline.cs
- OrderedDictionary.cs
- SubqueryRules.cs
- DataGridItem.cs
- ThreadAttributes.cs
- WindowsButton.cs
- DataContext.cs
- FormatSettings.cs
- NumberSubstitution.cs
- FormViewPagerRow.cs
- AssociatedControlConverter.cs
- DecimalStorage.cs
- HtmlSelectionListAdapter.cs
- IPipelineRuntime.cs
- RegistryPermission.cs
- Decorator.cs
- XsltLibrary.cs
- SqlTypeSystemProvider.cs
- ProfileSection.cs
- UndoEngine.cs
- DataGridViewCellConverter.cs
- ActivationService.cs
- XmlLangPropertyAttribute.cs
- SemanticAnalyzer.cs
- AutomationIdentifier.cs
- RuntimeHandles.cs
- ConnectionConsumerAttribute.cs
- ItemMap.cs
- DataGridViewRow.cs
- EntityContainerAssociationSet.cs
- SatelliteContractVersionAttribute.cs
- TrackBar.cs
- DecoderNLS.cs
- Canvas.cs
- RtfControls.cs
- CancellationToken.cs
- DesignerForm.cs
- SqlReferenceCollection.cs
- DataGridrowEditEndingEventArgs.cs
- StylusPoint.cs
- EmulateRecognizeCompletedEventArgs.cs
- ImageMapEventArgs.cs
- CompensableActivity.cs
- DesignerTransaction.cs
- SAPIEngineTypes.cs
- AsymmetricKeyExchangeFormatter.cs
- TransactionTable.cs
- InstanceOwnerQueryResult.cs
- Setter.cs
- Stackframe.cs
- RectAnimation.cs
- StreamAsIStream.cs
- LinqDataSourceContextData.cs
- Page.cs
- TextViewElement.cs
- XmlSecureResolver.cs
- KoreanCalendar.cs
- SizeAnimation.cs
- MasterPage.cs
- BindingManagerDataErrorEventArgs.cs
- BitmapFrame.cs
- CompositeScriptReference.cs
- SspiSafeHandles.cs
- EntityContainerEmitter.cs