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
- XmlObjectSerializerReadContext.cs
- Rect3D.cs
- LoginCancelEventArgs.cs
- PermissionSetTriple.cs
- CustomCategoryAttribute.cs
- ParenthesizePropertyNameAttribute.cs
- ToolStripPanelCell.cs
- AdapterUtil.cs
- Component.cs
- InvalidateEvent.cs
- StylusButtonEventArgs.cs
- ModifiableIteratorCollection.cs
- VectorValueSerializer.cs
- DefaultValueConverter.cs
- AutoGeneratedField.cs
- DesignerListAdapter.cs
- HtmlTextArea.cs
- MD5.cs
- SerializationStore.cs
- BamlRecordReader.cs
- WindowHideOrCloseTracker.cs
- SqlDataSource.cs
- PropertyValueChangedEvent.cs
- CompatibleComparer.cs
- TimeoutValidationAttribute.cs
- ObjectAnimationBase.cs
- EvidenceBase.cs
- ToolStripScrollButton.cs
- DBConnectionString.cs
- ProtectedProviderSettings.cs
- TextRangeProviderWrapper.cs
- XPathNodeInfoAtom.cs
- Token.cs
- Rectangle.cs
- BamlBinaryWriter.cs
- OleDbEnumerator.cs
- MetadataCacheItem.cs
- XmlSerializerNamespaces.cs
- TerminateDesigner.cs
- BCryptHashAlgorithm.cs
- BamlLocalizableResourceKey.cs
- FixedFindEngine.cs
- QilParameter.cs
- ConfigurationErrorsException.cs
- ProfileProvider.cs
- COM2ComponentEditor.cs
- ConstructorArgumentAttribute.cs
- GenericTextProperties.cs
- StatusBarDrawItemEvent.cs
- CommandHelpers.cs
- EnvelopeVersion.cs
- NativeMethods.cs
- SettingsPropertyValueCollection.cs
- DivideByZeroException.cs
- Soap.cs
- BitmapFrame.cs
- StringAttributeCollection.cs
- Region.cs
- QilList.cs
- MultiByteCodec.cs
- RelativeSource.cs
- CheckBoxField.cs
- MembershipValidatePasswordEventArgs.cs
- ButtonStandardAdapter.cs
- ProfileServiceManager.cs
- StaticExtension.cs
- CompilerInfo.cs
- WebPartDisplayModeEventArgs.cs
- EventlogProvider.cs
- EventManager.cs
- InternalResources.cs
- XmlNamespaceDeclarationsAttribute.cs
- MenuAdapter.cs
- DataBindingHandlerAttribute.cs
- safex509handles.cs
- TemplateControlCodeDomTreeGenerator.cs
- ReliableDuplexSessionChannel.cs
- ClientClassGenerator.cs
- DescendantQuery.cs
- DataBoundControl.cs
- CTreeGenerator.cs
- DataGridTextBox.cs
- TextSelectionHelper.cs
- StylusButtonCollection.cs
- StretchValidation.cs
- ProjectionCamera.cs
- ExtensionDataReader.cs
- SqlDataSourceCache.cs
- SqlProfileProvider.cs
- FactoryId.cs
- CodeSubDirectory.cs
- _NtlmClient.cs
- MenuItem.cs
- DecimalStorage.cs
- ByteConverter.cs
- SocketException.cs
- NullExtension.cs
- HttpHandlerActionCollection.cs
- ReadContentAsBinaryHelper.cs
- StreamInfo.cs