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
- HttpClientCertificate.cs
- ClientConfigPaths.cs
- BoundColumn.cs
- UrlPath.cs
- VisualBasicSettings.cs
- ExpressionValueEditor.cs
- FieldNameLookup.cs
- XmlSchemaAttributeGroup.cs
- ClockController.cs
- __ConsoleStream.cs
- EncryptedPackageFilter.cs
- ServiceHttpModule.cs
- BookmarkScopeManager.cs
- ResolveMatchesMessage11.cs
- GPRECTF.cs
- Rect3D.cs
- SystemIPGlobalProperties.cs
- PathGeometry.cs
- UIElementHelper.cs
- ProcessingInstructionAction.cs
- NonSerializedAttribute.cs
- FrameSecurityDescriptor.cs
- DebugTracing.cs
- ObjectStateManagerMetadata.cs
- QueryPageSettingsEventArgs.cs
- log.cs
- DesignerSerializationOptionsAttribute.cs
- _SpnDictionary.cs
- RelationshipEntry.cs
- RequestBringIntoViewEventArgs.cs
- FloatUtil.cs
- DbLambda.cs
- WeakReferenceEnumerator.cs
- XmlnsDictionary.cs
- PasswordTextContainer.cs
- WindowsHyperlink.cs
- PartialCachingControl.cs
- LoginNameDesigner.cs
- ClrProviderManifest.cs
- RegistryKey.cs
- TrackingServices.cs
- Inflater.cs
- UserControl.cs
- CodeDOMProvider.cs
- TreeViewHitTestInfo.cs
- VideoDrawing.cs
- WSSecurityOneDotOneReceiveSecurityHeader.cs
- IPAddress.cs
- TrackBar.cs
- StandardBindingElement.cs
- SendOperation.cs
- ToolStripTemplateNode.cs
- Int32Storage.cs
- XPathExpr.cs
- BamlLocalizableResource.cs
- StringCollectionEditor.cs
- HyperlinkAutomationPeer.cs
- ModifierKeysValueSerializer.cs
- MergeFilterQuery.cs
- FileLevelControlBuilderAttribute.cs
- WebPartMenu.cs
- UnsafeNativeMethodsTablet.cs
- GuidConverter.cs
- BitStack.cs
- DataSysAttribute.cs
- NumericPagerField.cs
- ProgressPage.cs
- InputEventArgs.cs
- _DisconnectOverlappedAsyncResult.cs
- AccessDataSourceView.cs
- TextBoxBase.cs
- Interlocked.cs
- HtmlImage.cs
- ConstantSlot.cs
- IndexExpression.cs
- ConnectionPoolManager.cs
- UserControlDesigner.cs
- MetadataUtilsSmi.cs
- DropSourceBehavior.cs
- CapabilitiesState.cs
- PathGeometry.cs
- BaseParser.cs
- ContextConfiguration.cs
- CreateInstanceBinder.cs
- WindowProviderWrapper.cs
- AssemblyGen.cs
- DocumentViewerBaseAutomationPeer.cs
- InheritedPropertyChangedEventArgs.cs
- HttpStreamFormatter.cs
- bindurihelper.cs
- CoTaskMemSafeHandle.cs
- RelationshipNavigation.cs
- NonClientArea.cs
- SafeHandle.cs
- OleStrCAMarshaler.cs
- EventLog.cs
- AssemblyBuilder.cs
- TiffBitmapEncoder.cs
- SurrogateSelector.cs
- SpotLight.cs