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
- PolicyUnit.cs
- TargetConverter.cs
- FontWeights.cs
- DbException.cs
- DataPagerFieldCommandEventArgs.cs
- SetterTriggerConditionValueConverter.cs
- XamlPoint3DCollectionSerializer.cs
- ForEachAction.cs
- AnchoredBlock.cs
- Animatable.cs
- PerformanceCounters.cs
- PathFigure.cs
- XmlUTF8TextReader.cs
- DataGridTable.cs
- TemplateKey.cs
- DataTransferEventArgs.cs
- DataControlButton.cs
- Style.cs
- ResourceReferenceExpression.cs
- LinqDataView.cs
- Metadata.cs
- EntityDataSourceQueryBuilder.cs
- UserNameSecurityTokenProvider.cs
- OrCondition.cs
- Mapping.cs
- HttpDictionary.cs
- ColorContext.cs
- SafeNativeMethodsCLR.cs
- DesignerView.Commands.cs
- EditorPartChrome.cs
- InfoCardRSAOAEPKeyExchangeDeformatter.cs
- GeneralTransform3DTo2D.cs
- LayoutDump.cs
- GridViewRowCollection.cs
- ImageListImage.cs
- PropertyValueEditor.cs
- OleDbConnectionPoolGroupProviderInfo.cs
- TextHidden.cs
- WebServiceAttribute.cs
- UIElementCollection.cs
- HTMLTextWriter.cs
- UnsafeNativeMethods.cs
- OneOfTypeConst.cs
- WebPartDescription.cs
- PowerStatus.cs
- EntityChangedParams.cs
- TextBoxAutomationPeer.cs
- MouseBinding.cs
- GPRECTF.cs
- FieldNameLookup.cs
- WrappedIUnknown.cs
- ListViewSelectEventArgs.cs
- documentsequencetextpointer.cs
- OleDbTransaction.cs
- ByteFacetDescriptionElement.cs
- IsolatedStorageException.cs
- GridProviderWrapper.cs
- NumberFunctions.cs
- XmlTypeMapping.cs
- CharacterBuffer.cs
- FactoryGenerator.cs
- safemediahandle.cs
- EpmContentDeSerializerBase.cs
- StrokeNodeEnumerator.cs
- HttpModuleCollection.cs
- FigureParagraph.cs
- XmlAnyElementAttribute.cs
- StandardBindingImporter.cs
- LicenseProviderAttribute.cs
- Certificate.cs
- UserControlFileEditor.cs
- VisualStyleTypesAndProperties.cs
- DiagnosticEventProvider.cs
- ContentControl.cs
- BitmapData.cs
- DesignerAutoFormatStyle.cs
- SqlBulkCopyColumnMappingCollection.cs
- messageonlyhwndwrapper.cs
- DocumentAutomationPeer.cs
- SamlNameIdentifierClaimResource.cs
- PackagePart.cs
- BaseServiceProvider.cs
- MainMenu.cs
- CapabilitiesAssignment.cs
- RootBuilder.cs
- PropertyChangedEventManager.cs
- HttpRequest.cs
- DataColumnPropertyDescriptor.cs
- StoryFragments.cs
- PathSegment.cs
- WebServiceParameterData.cs
- ConfigurationSettings.cs
- BrushMappingModeValidation.cs
- ToolboxDataAttribute.cs
- GestureRecognitionResult.cs
- HotSpotCollection.cs
- ResourceLoader.cs
- SecurityKeyIdentifier.cs
- XmlUTF8TextWriter.cs
- StyleSelector.cs