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
- DataSetUtil.cs
- ResourcePropertyMemberCodeDomSerializer.cs
- ViewCellRelation.cs
- ToolStripDropDownItemDesigner.cs
- DesignerForm.cs
- Dispatcher.cs
- PersistChildrenAttribute.cs
- TypeInfo.cs
- Deserializer.cs
- TextSelection.cs
- ParameterReplacerVisitor.cs
- LogicalExpr.cs
- List.cs
- HttpTransportSecurity.cs
- DbConnectionClosed.cs
- FrameworkElement.cs
- StreamAsIStream.cs
- PeerPresenceInfo.cs
- HttpCapabilitiesEvaluator.cs
- VisualState.cs
- Timer.cs
- TcpClientCredentialType.cs
- Button.cs
- SplitterDesigner.cs
- KeysConverter.cs
- StylusPoint.cs
- DebugView.cs
- StyleConverter.cs
- WebWorkflowRole.cs
- Panel.cs
- SimpleApplicationHost.cs
- recordstatefactory.cs
- TransformerTypeCollection.cs
- DataGridLinkButton.cs
- Decorator.cs
- AsymmetricAlgorithm.cs
- ParallelForEach.cs
- documentsequencetextview.cs
- JournalEntryStack.cs
- PropertySet.cs
- XmlTextAttribute.cs
- WindowsIdentity.cs
- CompositeCollectionView.cs
- MinMaxParagraphWidth.cs
- EncryptedPackageFilter.cs
- Type.cs
- Pkcs7Recipient.cs
- ServiceAppDomainAssociationProvider.cs
- CatalogPartChrome.cs
- CharacterMetricsDictionary.cs
- InteropDesigner.xaml.cs
- GlobalId.cs
- XmlSchemas.cs
- MarkupCompilePass2.cs
- DataGrid.cs
- PrintEvent.cs
- UrlMappingCollection.cs
- CultureTableRecord.cs
- Pkcs9Attribute.cs
- DataService.cs
- PrimaryKeyTypeConverter.cs
- UInt32Converter.cs
- SecureUICommand.cs
- SafeThreadHandle.cs
- RsaSecurityToken.cs
- LogLogRecordHeader.cs
- StrokeNodeEnumerator.cs
- ListBindingConverter.cs
- Typeface.cs
- InkSerializer.cs
- ping.cs
- ReflectionHelper.cs
- PlatformNotSupportedException.cs
- NamedElement.cs
- UnsignedPublishLicense.cs
- XmlSubtreeReader.cs
- AnnotationObservableCollection.cs
- TreeViewCancelEvent.cs
- EventWaitHandle.cs
- ClientTarget.cs
- SqlStatistics.cs
- PageAdapter.cs
- UIElement.cs
- DataSourceExpressionCollection.cs
- Command.cs
- LinqDataSourceDeleteEventArgs.cs
- DataGridrowEditEndingEventArgs.cs
- NamedPermissionSet.cs
- SkinBuilder.cs
- EditorPartDesigner.cs
- BindingMAnagerBase.cs
- EraserBehavior.cs
- NullableBoolConverter.cs
- Rotation3D.cs
- ColorAnimationBase.cs
- VarInfo.cs
- TextViewBase.cs
- BindingMAnagerBase.cs
- CopyAction.cs
- PolyLineSegmentFigureLogic.cs