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
- SystemResources.cs
- HostUtils.cs
- DBParameter.cs
- DocobjHost.cs
- Comparer.cs
- XmlHierarchicalEnumerable.cs
- XPathDocumentNavigator.cs
- HtmlElement.cs
- FileDialogCustomPlace.cs
- TransformedBitmap.cs
- LowerCaseStringConverter.cs
- PolicyUnit.cs
- DefinitionUpdate.cs
- _TimerThread.cs
- SqlRetyper.cs
- TextTreeNode.cs
- EventSinkHelperWriter.cs
- DataGridViewSelectedRowCollection.cs
- BatchStream.cs
- XamlSerializer.cs
- TagPrefixCollection.cs
- XmlSchemaImporter.cs
- ViewBox.cs
- DoubleLinkList.cs
- EntityContainerAssociationSet.cs
- HttpDebugHandler.cs
- ScriptModule.cs
- VisualBrush.cs
- XmlWriterTraceListener.cs
- PeerNameRecord.cs
- PrintingPermission.cs
- InkCanvasSelection.cs
- ValidationHelpers.cs
- ApplicationFileCodeDomTreeGenerator.cs
- RegexCharClass.cs
- CurrentChangedEventManager.cs
- SqlDataSourceConnectionPanel.cs
- shaper.cs
- HttpResponseMessageProperty.cs
- DataGridParentRows.cs
- AppSettingsReader.cs
- WebPartCatalogAddVerb.cs
- SHA256.cs
- GrammarBuilderPhrase.cs
- HttpCachePolicyElement.cs
- MinMaxParagraphWidth.cs
- CqlQuery.cs
- Command.cs
- TreeNodeSelectionProcessor.cs
- WebEvents.cs
- ImagingCache.cs
- IISUnsafeMethods.cs
- UnsafeNativeMethods.cs
- FillRuleValidation.cs
- ListBoxChrome.cs
- RegistryPermission.cs
- CodeAttachEventStatement.cs
- TreeViewImageKeyConverter.cs
- TextPenaltyModule.cs
- SecuritySessionSecurityTokenAuthenticator.cs
- Timer.cs
- TickBar.cs
- RelationshipNavigation.cs
- JournalEntryStack.cs
- SmtpAuthenticationManager.cs
- EventLogRecord.cs
- DbSourceParameterCollection.cs
- X509CertificateCollection.cs
- GridViewEditEventArgs.cs
- OdbcDataReader.cs
- SqlDataSourceEnumerator.cs
- TextBoxAutomationPeer.cs
- DbParameterCollectionHelper.cs
- XmlTextReader.cs
- ViewGenerator.cs
- ZipPackagePart.cs
- SpanIndex.cs
- VariableAction.cs
- EnumConverter.cs
- Scripts.cs
- RegistrySecurity.cs
- EqualityComparer.cs
- ValidationRuleCollection.cs
- WebPartRestoreVerb.cs
- MsmqProcessProtocolHandler.cs
- CharStorage.cs
- HtmlControlDesigner.cs
- WindowsUserNameCachingSecurityTokenAuthenticator.cs
- HandlerElement.cs
- RequestCachePolicyConverter.cs
- CheckBox.cs
- WmlCommandAdapter.cs
- SecurityElement.cs
- IResourceProvider.cs
- ValueChangedEventManager.cs
- FindCriteriaCD1.cs
- X509Certificate.cs
- LayoutEngine.cs
- Win32Interop.cs
- XmlSignatureProperties.cs