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
- Properties.cs
- MemberInitExpression.cs
- SatelliteContractVersionAttribute.cs
- ModuleConfigurationInfo.cs
- AccessibleObject.cs
- PageDeviceFont.cs
- XmlSchemaSimpleContent.cs
- UshortList2.cs
- ControlIdConverter.cs
- HandledMouseEvent.cs
- ImageConverter.cs
- ObjectMaterializedEventArgs.cs
- CopyNodeSetAction.cs
- FormsAuthenticationModule.cs
- SecurityTokenTypes.cs
- XamlSerializerUtil.cs
- WebBrowserPermission.cs
- FileEnumerator.cs
- TypeGeneratedEventArgs.cs
- MediaPlayerState.cs
- EllipseGeometry.cs
- Deflater.cs
- SqlIdentifier.cs
- OdbcError.cs
- controlskin.cs
- XmlTextReader.cs
- SigningProgress.cs
- FacetChecker.cs
- DragDrop.cs
- control.ime.cs
- EntityDataSourceChangedEventArgs.cs
- GlyphInfoList.cs
- MenuRendererClassic.cs
- Guid.cs
- ConversionContext.cs
- InstanceLockLostException.cs
- LoginCancelEventArgs.cs
- DataControlLinkButton.cs
- DynamicField.cs
- WindowsListViewGroupHelper.cs
- RuntimeConfigLKG.cs
- OutputCacheSettingsSection.cs
- RouteParameter.cs
- ConfigurationCollectionAttribute.cs
- HorizontalAlignConverter.cs
- WorkflowOperationAsyncResult.cs
- ConfigurationSection.cs
- DataMisalignedException.cs
- ExeConfigurationFileMap.cs
- ObjectCloneHelper.cs
- InkCollectionBehavior.cs
- ToolStripItemRenderEventArgs.cs
- XmlMapping.cs
- OutputCacheModule.cs
- HttpApplicationFactory.cs
- FileReservationCollection.cs
- IsolatedStorageFileStream.cs
- ParallelActivityDesigner.cs
- SqlCachedBuffer.cs
- ResourcesBuildProvider.cs
- DataListCommandEventArgs.cs
- Subset.cs
- OdbcException.cs
- StickyNoteHelper.cs
- WebPartVerbsEventArgs.cs
- AncestorChangedEventArgs.cs
- NamedPermissionSet.cs
- SelectionPattern.cs
- UnknownWrapper.cs
- X509Certificate2Collection.cs
- SolidColorBrush.cs
- EngineSiteSapi.cs
- ScalarType.cs
- DataRecordInternal.cs
- HttpClientCertificate.cs
- SwitchAttribute.cs
- XslTransform.cs
- Module.cs
- StateChangeEvent.cs
- ToolStripButton.cs
- UInt64.cs
- Drawing.cs
- MsmqAuthenticationMode.cs
- TracedNativeMethods.cs
- ConfigXmlSignificantWhitespace.cs
- UnsafeNativeMethods.cs
- PolicyManager.cs
- Context.cs
- ComEventsSink.cs
- TransactionScope.cs
- GradientBrush.cs
- SizeFConverter.cs
- X509Certificate2.cs
- DetailsViewCommandEventArgs.cs
- IDispatchConstantAttribute.cs
- CancelEventArgs.cs
- ACL.cs
- _DisconnectOverlappedAsyncResult.cs
- HttpSysSettings.cs
- X509Certificate2.cs