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
- RemotingAttributes.cs
- TableRow.cs
- Point.cs
- File.cs
- LinkDescriptor.cs
- LinearKeyFrames.cs
- XmlArrayAttribute.cs
- PagePropertiesChangingEventArgs.cs
- TypeHelper.cs
- TraceContextRecord.cs
- TickBar.cs
- _SslSessionsCache.cs
- WindowShowOrOpenTracker.cs
- WebBrowserPermission.cs
- BulletChrome.cs
- base64Transforms.cs
- DataList.cs
- LicenseContext.cs
- DockPatternIdentifiers.cs
- ExitEventArgs.cs
- XmlILModule.cs
- ExpandedWrapper.cs
- ControlBindingsCollection.cs
- RawStylusInputCustomDataList.cs
- XmlCDATASection.cs
- EntitySetBase.cs
- KeyPressEvent.cs
- ControlCachePolicy.cs
- WindowsAuthenticationEventArgs.cs
- JsonStringDataContract.cs
- DataGridView.cs
- StaticDataManager.cs
- SqlTransaction.cs
- Clock.cs
- XmlAtomicValue.cs
- PageThemeParser.cs
- Decimal.cs
- X509ChainElement.cs
- UserControlDocumentDesigner.cs
- _ListenerAsyncResult.cs
- SqlCommandSet.cs
- ChangeToolStripParentVerb.cs
- FilteredDataSetHelper.cs
- LogExtentCollection.cs
- CollectionViewGroupRoot.cs
- PointLight.cs
- dataSvcMapFileLoader.cs
- Root.cs
- CompiledIdentityConstraint.cs
- QuinticEase.cs
- RankException.cs
- TypeBinaryExpression.cs
- CompositeScriptReferenceEventArgs.cs
- UnmanagedMarshal.cs
- TrailingSpaceComparer.cs
- TextServicesCompartmentContext.cs
- ItemChangedEventArgs.cs
- HijriCalendar.cs
- SQLInt32Storage.cs
- WebPartDescription.cs
- TraceRecord.cs
- TextFormatterImp.cs
- Stylus.cs
- CacheChildrenQuery.cs
- UnicodeEncoding.cs
- NetCodeGroup.cs
- SerializationEventsCache.cs
- TypedServiceOperationListItem.cs
- WebPartTransformerAttribute.cs
- ProcessModelInfo.cs
- RemoteX509Token.cs
- ColorAnimationUsingKeyFrames.cs
- QilValidationVisitor.cs
- XmlSchemaAny.cs
- RelatedView.cs
- IndicFontClient.cs
- ExpressionsCollectionConverter.cs
- CompiledRegexRunnerFactory.cs
- TrustLevel.cs
- ScrollEventArgs.cs
- FieldToken.cs
- SimpleRecyclingCache.cs
- JsonDeserializer.cs
- EnterpriseServicesHelper.cs
- StateBag.cs
- httpserverutility.cs
- ExtendedProperty.cs
- PeerTransportSecurityElement.cs
- CallContext.cs
- FileLevelControlBuilderAttribute.cs
- Version.cs
- CollectionContainer.cs
- ExceptionUtil.cs
- DataStreamFromComStream.cs
- DataGridView.cs
- DataGridRow.cs
- ApplicationDirectory.cs
- BasicHttpSecurityMode.cs
- XmlValidatingReaderImpl.cs
- FormsAuthenticationTicket.cs