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
- _NegotiateClient.cs
- ArrayTypeMismatchException.cs
- BrowsableAttribute.cs
- FixedSOMContainer.cs
- BindUriHelper.cs
- DataServiceHostFactory.cs
- FormView.cs
- IfAction.cs
- SizeLimitedCache.cs
- ContentElementAutomationPeer.cs
- DataFormats.cs
- AxisAngleRotation3D.cs
- DictionarySectionHandler.cs
- KnownBoxes.cs
- ListItem.cs
- SelectedDatesCollection.cs
- NegotiateStream.cs
- NotifyIcon.cs
- ScrollChrome.cs
- Label.cs
- IPAddressCollection.cs
- DataObjectSettingDataEventArgs.cs
- XmlWhitespace.cs
- TrueReadOnlyCollection.cs
- ListViewInsertedEventArgs.cs
- HierarchicalDataTemplate.cs
- ScriptControl.cs
- RNGCryptoServiceProvider.cs
- DataRecordObjectView.cs
- ExpressionParser.cs
- GridViewRowEventArgs.cs
- parserscommon.cs
- InitializationEventAttribute.cs
- _ProxyChain.cs
- EntityDesignerDataSourceView.cs
- ByteStream.cs
- AdapterDictionary.cs
- EncryptionUtility.cs
- ProfileBuildProvider.cs
- HttpServerVarsCollection.cs
- TextEndOfSegment.cs
- XpsInterleavingPolicy.cs
- HttpStreamXmlDictionaryWriter.cs
- SqlXmlStorage.cs
- LogRestartAreaEnumerator.cs
- CommonXSendMessage.cs
- XmlArrayAttribute.cs
- ConcurrentBag.cs
- ObjectContext.cs
- EditingScope.cs
- NullRuntimeConfig.cs
- RSAProtectedConfigurationProvider.cs
- TrustLevelCollection.cs
- TreeNodeStyleCollection.cs
- LinearGradientBrush.cs
- LockRecursionException.cs
- Native.cs
- ImageField.cs
- Expression.cs
- Stroke2.cs
- SqlWorkflowInstanceStore.cs
- LocalBuilder.cs
- WindowsHyperlink.cs
- ButtonDesigner.cs
- RunInstallerAttribute.cs
- SimpleFieldTemplateUserControl.cs
- ChildrenQuery.cs
- DetailsViewModeEventArgs.cs
- XmlDataSourceDesigner.cs
- MbpInfo.cs
- WindowsFormsHost.cs
- DesignerValidatorAdapter.cs
- GroupQuery.cs
- GridViewUpdateEventArgs.cs
- Stroke.cs
- RequestTimeoutManager.cs
- TextPenaltyModule.cs
- HttpVersion.cs
- CodeGotoStatement.cs
- WebColorConverter.cs
- RuntimeHandles.cs
- MemberDescriptor.cs
- FileSystemWatcher.cs
- PropertyGridView.cs
- OutputBuffer.cs
- WebPartCloseVerb.cs
- SimpleMailWebEventProvider.cs
- PointAnimationUsingPath.cs
- HttpListenerPrefixCollection.cs
- SynchronizedPool.cs
- PageCodeDomTreeGenerator.cs
- WebPartRestoreVerb.cs
- SafeFileMappingHandle.cs
- BitmapEffectrendercontext.cs
- ClassHandlersStore.cs
- ControlValuePropertyAttribute.cs
- ClientTargetSection.cs
- SqlCommandBuilder.cs
- DescendentsWalkerBase.cs
- EncodingDataItem.cs