Code:
/ Net / Net / 3.5.50727.3053 / DEVDIV / depot / DevDiv / releases / Orcas / SP / 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
- CompModHelpers.cs
- Triangle.cs
- BitmapEffectInputConnector.cs
- WindowsToolbar.cs
- BaseParagraph.cs
- XPathQueryGenerator.cs
- ObjectDataSourceSelectingEventArgs.cs
- Deserializer.cs
- GenerateHelper.cs
- CustomAttribute.cs
- SafeNativeMethods.cs
- LoginUtil.cs
- PropertyEmitterBase.cs
- FlowDocumentFormatter.cs
- BackEase.cs
- LinqDataSource.cs
- _ConnectStream.cs
- AttributeInfo.cs
- Primitive.cs
- UIElementParaClient.cs
- WorkflowOperationBehavior.cs
- FontEmbeddingManager.cs
- WebPartZoneCollection.cs
- TextAutomationPeer.cs
- FunctionImportMapping.ReturnTypeRenameMapping.cs
- LinkedResourceCollection.cs
- StateRuntime.cs
- ApplicationDirectoryMembershipCondition.cs
- MultiTrigger.cs
- RegularExpressionValidator.cs
- FilteredXmlReader.cs
- ConcurrentBag.cs
- TreeNodeSelectionProcessor.cs
- Attributes.cs
- AccessibilityHelperForXpWin2k3.cs
- EntityType.cs
- DynamicILGenerator.cs
- BamlRecordHelper.cs
- AspNetSynchronizationContext.cs
- _LocalDataStoreMgr.cs
- SelectionRangeConverter.cs
- SQLMoney.cs
- TextContainerChangeEventArgs.cs
- JsonFormatGeneratorStatics.cs
- ScopeElement.cs
- ElementUtil.cs
- SimpleTypeResolver.cs
- ServiceManager.cs
- CopyNamespacesAction.cs
- BindingMemberInfo.cs
- ViewCellRelation.cs
- Point4DConverter.cs
- DictionaryTraceRecord.cs
- DragCompletedEventArgs.cs
- ExpressionNormalizer.cs
- MissingSatelliteAssemblyException.cs
- XmlEventCache.cs
- CompilationUnit.cs
- PointAnimationUsingKeyFrames.cs
- DataGridViewSelectedRowCollection.cs
- ApplicationId.cs
- ZipIOLocalFileDataDescriptor.cs
- ResourceManager.cs
- MethodAccessException.cs
- StyleTypedPropertyAttribute.cs
- AutoCompleteStringCollection.cs
- NullableLongMinMaxAggregationOperator.cs
- TileBrush.cs
- TextEmbeddedObject.cs
- InternalConfigHost.cs
- ParenthesizePropertyNameAttribute.cs
- FontUnit.cs
- FolderBrowserDialogDesigner.cs
- DataGridViewCellMouseEventArgs.cs
- METAHEADER.cs
- ZoneButton.cs
- XPathSingletonIterator.cs
- SQLDoubleStorage.cs
- Listbox.cs
- ResourceReferenceExpressionConverter.cs
- HostingEnvironment.cs
- DataKey.cs
- SqlConnectionPoolGroupProviderInfo.cs
- GPPOINTF.cs
- Color.cs
- ResourcesChangeInfo.cs
- DataObjectSettingDataEventArgs.cs
- ManipulationDelta.cs
- StrokeNodeOperations2.cs
- SchemaImporterExtensionsSection.cs
- LogicalMethodInfo.cs
- AspNetPartialTrustHelpers.cs
- MetadataSection.cs
- EarlyBoundInfo.cs
- ExclusiveNamedPipeTransportManager.cs
- ElementAction.cs
- CommandConverter.cs
- StylusPointDescription.cs
- TextParaClient.cs
- TagNameToTypeMapper.cs