Code:
/ Dotnetfx_Win7_3.5.1 / Dotnetfx_Win7_3.5.1 / 3.5.1 / DEVDIV / depot / DevDiv / releases / Orcas / NetFXw7 / 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
- TypeConstant.cs
- Transform.cs
- RuleAction.cs
- StreamInfo.cs
- ErrorRuntimeConfig.cs
- Condition.cs
- FileIOPermission.cs
- OdbcParameterCollection.cs
- SimpleTextLine.cs
- QueryRewriter.cs
- basenumberconverter.cs
- DropShadowBitmapEffect.cs
- UIPermission.cs
- HttpClientCertificate.cs
- ModelServiceImpl.cs
- Int64AnimationUsingKeyFrames.cs
- CookielessHelper.cs
- InheritanceContextChangedEventManager.cs
- Int16Storage.cs
- mda.cs
- QueryableDataSourceHelper.cs
- ZipIOModeEnforcingStream.cs
- PathFigureCollectionValueSerializer.cs
- AppDomainGrammarProxy.cs
- GridViewEditEventArgs.cs
- HtmlWindowCollection.cs
- DefaultEvaluationContext.cs
- PageCache.cs
- XmlSerializerAssemblyAttribute.cs
- PrivilegedConfigurationManager.cs
- TextEditorSpelling.cs
- DelegatedStream.cs
- MobileCapabilities.cs
- ComplexPropertyEntry.cs
- ResourceProviderFactory.cs
- EventMappingSettingsCollection.cs
- SafeTimerHandle.cs
- BaseValidator.cs
- CreateSequence.cs
- Ipv6Element.cs
- ToolboxDataAttribute.cs
- LessThan.cs
- NullableBoolConverter.cs
- DispatcherExceptionEventArgs.cs
- UndoManager.cs
- BufferModeSettings.cs
- WebPartAddingEventArgs.cs
- CharacterString.cs
- ResXResourceSet.cs
- SQLDateTime.cs
- VariableModifiersHelper.cs
- Schema.cs
- keycontainerpermission.cs
- SemanticBasicElement.cs
- Lease.cs
- WindowsListViewGroupHelper.cs
- ThreadStaticAttribute.cs
- ToolStripTemplateNode.cs
- DocumentSequenceHighlightLayer.cs
- FileDialogCustomPlace.cs
- ObjectComplexPropertyMapping.cs
- ObjectHelper.cs
- SchemaInfo.cs
- Transform3D.cs
- InputReportEventArgs.cs
- ObjectListShowCommandsEventArgs.cs
- ConfigurationSettings.cs
- ContainerParagraph.cs
- TextBlock.cs
- OverlappedAsyncResult.cs
- HtmlInputCheckBox.cs
- PermissionSetTriple.cs
- AssociationSet.cs
- IdentitySection.cs
- XmlAtomicValue.cs
- EventBuilder.cs
- QilInvokeEarlyBound.cs
- HwndProxyElementProvider.cs
- GroupJoinQueryOperator.cs
- BmpBitmapDecoder.cs
- AppDomainProtocolHandler.cs
- EncodingDataItem.cs
- Int32Converter.cs
- BamlMapTable.cs
- MatrixConverter.cs
- RoleManagerModule.cs
- CuspData.cs
- ClassicBorderDecorator.cs
- ObsoleteAttribute.cs
- RijndaelManaged.cs
- BinaryUtilClasses.cs
- MarkupExtensionReturnTypeAttribute.cs
- EditorPartCollection.cs
- TypeUtil.cs
- BCryptHashAlgorithm.cs
- IntSecurity.cs
- Literal.cs
- FixedSOMGroup.cs
- SlipBehavior.cs
- PropertyChangedEventArgs.cs