Code:
/ Dotnetfx_Vista_SP2 / Dotnetfx_Vista_SP2 / 8.0.50727.4016 / DEVDIV / depot / DevDiv / releases / Orcas / QFE / 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
- ItemsPanelTemplate.cs
- WebPartsPersonalization.cs
- NamedPipeChannelFactory.cs
- PackageProperties.cs
- SymmetricCryptoHandle.cs
- COMException.cs
- x509store.cs
- DbConnectionStringCommon.cs
- ThreadPool.cs
- TextTreeFixupNode.cs
- PropertyGridView.cs
- EndOfStreamException.cs
- TextViewSelectionProcessor.cs
- DataMemberAttribute.cs
- GraphicsContainer.cs
- mda.cs
- DependencyObjectPropertyDescriptor.cs
- DataGrid.cs
- HierarchicalDataTemplate.cs
- SafeRegistryHandle.cs
- UnitySerializationHolder.cs
- TemplatedWizardStep.cs
- BuilderElements.cs
- DataGridViewElement.cs
- _AutoWebProxyScriptWrapper.cs
- DataGridViewColumnCollectionDialog.cs
- DataList.cs
- ColorPalette.cs
- StrongNameMembershipCondition.cs
- PEFileReader.cs
- RequestCache.cs
- BasicBrowserDialog.designer.cs
- EditorPartChrome.cs
- MergeLocalizationDirectives.cs
- SchemaContext.cs
- IntMinMaxAggregationOperator.cs
- References.cs
- DataGridViewComboBoxCell.cs
- DateTimeUtil.cs
- Run.cs
- ResourcesBuildProvider.cs
- TimeSpanSecondsOrInfiniteConverter.cs
- FocusManager.cs
- XmlSchemaAll.cs
- CryptoApi.cs
- ImageUrlEditor.cs
- TokenBasedSetEnumerator.cs
- StyleSheetComponentEditor.cs
- RootProfilePropertySettingsCollection.cs
- TypeReference.cs
- CardSpaceException.cs
- MemberInfoSerializationHolder.cs
- DragCompletedEventArgs.cs
- TypeLoadException.cs
- CompositeCollectionView.cs
- ImmComposition.cs
- LocalizableAttribute.cs
- ArrayHelper.cs
- ControlType.cs
- SqlDependencyUtils.cs
- ProfessionalColorTable.cs
- LogArchiveSnapshot.cs
- FormViewDeletedEventArgs.cs
- RegexTypeEditor.cs
- DelegatingTypeDescriptionProvider.cs
- GlyphingCache.cs
- TypeDependencyAttribute.cs
- OleDbParameterCollection.cs
- _Win32.cs
- SqlCacheDependencyDatabaseCollection.cs
- RadioButtonFlatAdapter.cs
- InputScopeAttribute.cs
- TransformerInfoCollection.cs
- XmlAttributeAttribute.cs
- ToolStripDropDownItem.cs
- WindowsAuthenticationModule.cs
- MetadataException.cs
- VectorValueSerializer.cs
- WebColorConverter.cs
- AnnotationMap.cs
- EndpointFilterProvider.cs
- CurrentChangedEventManager.cs
- OperationAbortedException.cs
- PlanCompilerUtil.cs
- WindowsPrincipal.cs
- BinHexEncoder.cs
- SafeSecurityHelper.cs
- EmptyReadOnlyDictionaryInternal.cs
- XmlQueryOutput.cs
- HttpDebugHandler.cs
- WindowsTitleBar.cs
- X509RawDataKeyIdentifierClause.cs
- EventBindingService.cs
- DecimalConstantAttribute.cs
- ClientApiGenerator.cs
- TextSerializer.cs
- MailMessageEventArgs.cs
- CounterCreationDataCollection.cs
- Facet.cs
- ClientCultureInfo.cs