Code:
/ 4.0 / 4.0 / 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. //---------------------------------------------------------------------- //// 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
- IsolatedStorageException.cs
- Compiler.cs
- AppSettingsExpressionBuilder.cs
- ConnectionPoolManager.cs
- ConsoleTraceListener.cs
- HttpEncoderUtility.cs
- TableLayoutSettingsTypeConverter.cs
- SspiWrapper.cs
- shaper.cs
- ControlBuilder.cs
- SingleConverter.cs
- ToolStripItemTextRenderEventArgs.cs
- Selector.cs
- HotSpotCollection.cs
- DbConnectionPoolGroupProviderInfo.cs
- HashCodeCombiner.cs
- TextBox.cs
- Header.cs
- XmlToDatasetMap.cs
- ClientSession.cs
- UnsafeNativeMethods.cs
- DocumentOrderComparer.cs
- NamedObject.cs
- RangeValuePatternIdentifiers.cs
- XmlNamespaceManager.cs
- TraceContext.cs
- Metadata.cs
- WorkflowServiceHostFactory.cs
- Compensate.cs
- HTTPNotFoundHandler.cs
- HtmlInputRadioButton.cs
- OracleDateTime.cs
- HandleCollector.cs
- RelatedCurrencyManager.cs
- InternalTransaction.cs
- PanningMessageFilter.cs
- InitiatorSessionSymmetricTransportSecurityProtocol.cs
- ViewLoader.cs
- Point4DValueSerializer.cs
- AuthenticationModuleElementCollection.cs
- IISMapPath.cs
- IgnorePropertiesAttribute.cs
- FormsAuthenticationModule.cs
- SqlDependency.cs
- ByteStream.cs
- OrderedDictionaryStateHelper.cs
- SafeFreeMibTable.cs
- WebBrowserProgressChangedEventHandler.cs
- ToolboxComponentsCreatedEventArgs.cs
- MinMaxParagraphWidth.cs
- TypeDescriptor.cs
- SwitchExpression.cs
- TouchesCapturedWithinProperty.cs
- LeftCellWrapper.cs
- ConfigurationValues.cs
- ModuleElement.cs
- ZipIOModeEnforcingStream.cs
- EdmMember.cs
- HybridDictionary.cs
- GridViewCommandEventArgs.cs
- ExtractorMetadata.cs
- ExistsInCollection.cs
- DbDataSourceEnumerator.cs
- BStrWrapper.cs
- SystemIPInterfaceProperties.cs
- SelectionEditingBehavior.cs
- AuthorizationRule.cs
- _ConnectOverlappedAsyncResult.cs
- RNGCryptoServiceProvider.cs
- TabItemWrapperAutomationPeer.cs
- Message.cs
- DataGridViewLayoutData.cs
- Select.cs
- HMACSHA384.cs
- FontStretches.cs
- SEHException.cs
- EventDescriptor.cs
- CssClassPropertyAttribute.cs
- NotificationContext.cs
- WindowsClaimSet.cs
- DataGridViewCheckBoxColumn.cs
- SafeArrayRankMismatchException.cs
- Accessible.cs
- UInt64.cs
- SapiInterop.cs
- RangeBase.cs
- SpecularMaterial.cs
- ResolveNextArgumentWorkItem.cs
- XmlDocumentFragment.cs
- CompositionAdorner.cs
- CompilerInfo.cs
- ProfileSection.cs
- WebPartEditorOkVerb.cs
- CopyAttributesAction.cs
- ConnectionOrientedTransportElement.cs
- XmlSchemaGroupRef.cs
- WindowsListViewItemCheckBox.cs
- SignedXml.cs
- FigureParagraph.cs
- NamedPermissionSet.cs