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
- EventLogPermission.cs
- RectAnimationClockResource.cs
- PathTooLongException.cs
- ProfileService.cs
- PowerStatus.cs
- TypeSource.cs
- PolyQuadraticBezierSegment.cs
- coordinatorfactory.cs
- IOException.cs
- HtmlElementEventArgs.cs
- CodeArrayCreateExpression.cs
- EntityDataSourceMemberPath.cs
- SqlCaseSimplifier.cs
- OverflowException.cs
- xmlfixedPageInfo.cs
- _UncName.cs
- Module.cs
- XPathAncestorQuery.cs
- DateTimeSerializationSection.cs
- ServiceNameCollection.cs
- BeginSelectCardRequest.cs
- PasswordRecoveryAutoFormat.cs
- TreeNodeStyleCollection.cs
- JpegBitmapEncoder.cs
- MemoryPressure.cs
- SystemResources.cs
- MouseButton.cs
- WarningException.cs
- TimeZone.cs
- SqlPersonalizationProvider.cs
- MethodBuilderInstantiation.cs
- ParameterCollection.cs
- ToolboxItem.cs
- DBDataPermissionAttribute.cs
- FixedSchema.cs
- ExpressionCopier.cs
- SwitchElementsCollection.cs
- CrossContextChannel.cs
- SamlAuthorizationDecisionStatement.cs
- StringUtil.cs
- ProcessHost.cs
- CriticalHandle.cs
- SqlCacheDependency.cs
- SiteOfOriginPart.cs
- SQLResource.cs
- SafeRightsManagementEnvironmentHandle.cs
- DbgCompiler.cs
- VisualTarget.cs
- TextBox.cs
- PropertyEmitter.cs
- MD5HashHelper.cs
- SQLUtility.cs
- DataGridViewBand.cs
- TextRangeAdaptor.cs
- ResourceReferenceExpressionConverter.cs
- SafeTimerHandle.cs
- TransactionContext.cs
- ClrPerspective.cs
- ImageBrush.cs
- IOThreadScheduler.cs
- ToolboxItemSnapLineBehavior.cs
- columnmapfactory.cs
- LZCodec.cs
- GridSplitter.cs
- ThicknessConverter.cs
- DispatcherHooks.cs
- IApplicationTrustManager.cs
- ChannelSinkStacks.cs
- Attributes.cs
- ImageCodecInfo.cs
- EventLogRecord.cs
- ArgumentValidation.cs
- BaseProcessor.cs
- EpmCustomContentDeSerializer.cs
- InternalDispatchObject.cs
- PolicyManager.cs
- XmlNotation.cs
- FocusTracker.cs
- InternalConfigHost.cs
- InfoCardRSAPKCS1KeyExchangeDeformatter.cs
- CodeGeneratorOptions.cs
- HostUtils.cs
- UniqueIdentifierService.cs
- TextWriterEngine.cs
- ClientFormsIdentity.cs
- XmlNodeList.cs
- safemediahandle.cs
- KeyedByTypeCollection.cs
- OleDbTransaction.cs
- UriSection.cs
- Stackframe.cs
- WebPartConnection.cs
- TreeViewItem.cs
- BaseValidatorDesigner.cs
- WmlListAdapter.cs
- DocumentPaginator.cs
- MobileControlsSectionHelper.cs
- DataGridTextBox.cs
- ColumnPropertiesGroup.cs
- XmlSchemaSimpleContentExtension.cs