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
- URLIdentityPermission.cs
- DataGridViewSortCompareEventArgs.cs
- SafeHandles.cs
- CommentAction.cs
- PersonalizationProviderCollection.cs
- cookie.cs
- OdbcConnectionFactory.cs
- Unit.cs
- latinshape.cs
- PointLightBase.cs
- XMLSchema.cs
- LockedAssemblyCache.cs
- ColumnCollection.cs
- DocumentXPathNavigator.cs
- ListSourceHelper.cs
- FormDesigner.cs
- Bitmap.cs
- SettingsBindableAttribute.cs
- Geometry.cs
- x509utils.cs
- ClientProxyGenerator.cs
- DBSqlParserTableCollection.cs
- StructuredTypeEmitter.cs
- PositiveTimeSpanValidator.cs
- SmtpMail.cs
- WorkflowEnvironment.cs
- TriggerCollection.cs
- RawAppCommandInputReport.cs
- ToolboxItemLoader.cs
- Translator.cs
- QilSortKey.cs
- ContextMenu.cs
- ModelItemCollection.cs
- CachingHintValidation.cs
- HwndProxyElementProvider.cs
- RemotingException.cs
- HttpCachePolicyWrapper.cs
- ObjectParameterCollection.cs
- WindowsGrip.cs
- HttpListenerPrefixCollection.cs
- NavigationPropertyEmitter.cs
- ListViewDeleteEventArgs.cs
- AppSettingsReader.cs
- SemaphoreSlim.cs
- Int64Converter.cs
- SemanticKeyElement.cs
- XDRSchema.cs
- OpCodes.cs
- CounterSampleCalculator.cs
- ValidationErrorEventArgs.cs
- TaskForm.cs
- FlowDocumentPage.cs
- ExtendedPropertyCollection.cs
- CacheOutputQuery.cs
- FamilyCollection.cs
- ResourceDisplayNameAttribute.cs
- OdbcConnectionStringbuilder.cs
- AlphaSortedEnumConverter.cs
- HtmlInputPassword.cs
- ApplicationDirectory.cs
- PackagingUtilities.cs
- SequentialUshortCollection.cs
- login.cs
- MexServiceChannelBuilder.cs
- TagMapInfo.cs
- _ConnectionGroup.cs
- SerializationEventsCache.cs
- DbException.cs
- TransformPatternIdentifiers.cs
- ConfigXmlText.cs
- _HeaderInfoTable.cs
- EntityClassGenerator.cs
- FrameworkContentElement.cs
- BaseInfoTable.cs
- ReceiveReply.cs
- Soap.cs
- TreeViewDataItemAutomationPeer.cs
- ColorConverter.cs
- FixedSOMTextRun.cs
- RelationshipConverter.cs
- VersionPair.cs
- DataSourceCacheDurationConverter.cs
- DrawingContextWalker.cs
- OptimalTextSource.cs
- DecoderExceptionFallback.cs
- HandlerBase.cs
- WebPartZoneBase.cs
- XmlDictionaryWriter.cs
- XmlDomTextWriter.cs
- TextBox.cs
- TranslateTransform3D.cs
- HttpWebRequest.cs
- ChameleonKey.cs
- BulletedList.cs
- ValidatorCollection.cs
- OleDbConnectionFactory.cs
- InitializationEventAttribute.cs
- SortedList.cs
- MultiplexingDispatchMessageFormatter.cs
- FormsAuthenticationConfiguration.cs