Code:
/ 4.0 / 4.0 / untmp / DEVDIV_TFS / Dev10 / Releases / RTMRel / ndp / fx / src / DataEntity / System / Data / SqlClient / SqlGen / TopClause.cs / 1305376 / TopClause.cs
//---------------------------------------------------------------------- //// Copyright (c) Microsoft Corporation. All rights reserved. // // // @owner [....] // @backupOwner [....] //--------------------------------------------------------------------- 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
- WebCodeGenerator.cs
- Component.cs
- HtmlShimManager.cs
- DbProviderFactoriesConfigurationHandler.cs
- FixedSOMFixedBlock.cs
- EditorZoneBase.cs
- Connector.cs
- ApplicationBuildProvider.cs
- TextAutomationPeer.cs
- InstanceCompleteException.cs
- XhtmlBasicLinkAdapter.cs
- SemanticBasicElement.cs
- UndoManager.cs
- MonthCalendar.cs
- BitmapSource.cs
- ToolboxComponentsCreatingEventArgs.cs
- ProxyWebPartConnectionCollection.cs
- AutomationElement.cs
- LongValidator.cs
- DataQuery.cs
- DigitShape.cs
- SHA512CryptoServiceProvider.cs
- InternalConfigConfigurationFactory.cs
- ResourcePool.cs
- SqlCommandSet.cs
- BitmapScalingModeValidation.cs
- EntityDataSourceChangedEventArgs.cs
- TextOnlyOutput.cs
- AuthorizationRuleCollection.cs
- CodeDelegateCreateExpression.cs
- ExpressionBuilder.cs
- EdgeProfileValidation.cs
- xml.cs
- ProtectedConfigurationSection.cs
- IpcServerChannel.cs
- CachedFontFace.cs
- CleanUpVirtualizedItemEventArgs.cs
- ClipboardProcessor.cs
- TextWriter.cs
- GridViewSortEventArgs.cs
- TokenFactoryFactory.cs
- ObjectTypeMapping.cs
- MenuItemStyleCollection.cs
- WebZoneDesigner.cs
- EventLogException.cs
- Descriptor.cs
- ITreeGenerator.cs
- ProfileProvider.cs
- Translator.cs
- Table.cs
- shaperfactoryquerycacheentry.cs
- IxmlLineInfo.cs
- GradientSpreadMethodValidation.cs
- BookmarkTable.cs
- EntityEntry.cs
- ServiceManager.cs
- keycontainerpermission.cs
- EntityCommandDefinition.cs
- NavigationFailedEventArgs.cs
- MetadataUtil.cs
- StateMachine.cs
- XmlSchemaSubstitutionGroup.cs
- SettingsBindableAttribute.cs
- TimersDescriptionAttribute.cs
- Regex.cs
- _ProxyRegBlob.cs
- StoragePropertyMapping.cs
- HttpListenerException.cs
- PenThreadWorker.cs
- SqlConnectionPoolGroupProviderInfo.cs
- KerberosSecurityTokenProvider.cs
- ToolStripGrip.cs
- MimeBasePart.cs
- SortQueryOperator.cs
- ObjectMemberMapping.cs
- ClientBuildManagerTypeDescriptionProviderBridge.cs
- WebAdminConfigurationHelper.cs
- DrawingImage.cs
- IntersectQueryOperator.cs
- DefaultBindingPropertyAttribute.cs
- ResourcePool.cs
- MethodToken.cs
- OnOperation.cs
- DataStorage.cs
- AbsoluteQuery.cs
- DrawingGroup.cs
- AppDomainCompilerProxy.cs
- ThrowHelper.cs
- FixedSOMLineCollection.cs
- ContractTypeNameCollection.cs
- DoWorkEventArgs.cs
- BaseParagraph.cs
- FieldMetadata.cs
- ToolStripScrollButton.cs
- Update.cs
- PrincipalPermission.cs
- BoundingRectTracker.cs
- DATA_BLOB.cs
- IDReferencePropertyAttribute.cs
- ButtonFieldBase.cs