Code:
/ 4.0 / 4.0 / untmp / DEVDIV_TFS / Dev10 / Releases / RTMRel / ndp / fx / src / DataEntity / System / Data / SqlClient / SqlGen / TopClause.cs / 1305376 / TopClause.cs
//---------------------------------------------------------------------- //// Copyright (c) Microsoft Corporation. All rights reserved. // // // @owner [....] // @backupOwner [....] //--------------------------------------------------------------------- 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
- XmlILConstructAnalyzer.cs
- XmlSchemaSubstitutionGroup.cs
- PageDeviceFont.cs
- XPathNodePointer.cs
- PathGeometry.cs
- CodeTypeReferenceExpression.cs
- SafeMILHandleMemoryPressure.cs
- MatrixCamera.cs
- ConfigurationFileMap.cs
- SocketCache.cs
- PathHelper.cs
- ScriptingSectionGroup.cs
- HtmlShim.cs
- SystemException.cs
- DisplayMemberTemplateSelector.cs
- FamilyMap.cs
- XmlLanguage.cs
- MemoryFailPoint.cs
- TypeConverterAttribute.cs
- LeaseManager.cs
- SchemaCollectionCompiler.cs
- FormViewCommandEventArgs.cs
- ScriptResourceInfo.cs
- Boolean.cs
- SmiRequestExecutor.cs
- ToolStripGrip.cs
- WebZone.cs
- GridItemCollection.cs
- EncryptedType.cs
- CodeMemberEvent.cs
- safelinkcollection.cs
- CqlWriter.cs
- SafeHandles.cs
- RegexNode.cs
- wgx_exports.cs
- RelatedPropertyManager.cs
- AddInSegmentDirectoryNotFoundException.cs
- HwndMouseInputProvider.cs
- DropShadowEffect.cs
- IndexedGlyphRun.cs
- PolicyChain.cs
- InputReportEventArgs.cs
- CommandField.cs
- DataRecordInfo.cs
- ListBox.cs
- DefaultObjectMappingItemCollection.cs
- BridgeDataRecord.cs
- OAVariantLib.cs
- IISUnsafeMethods.cs
- HyperLink.cs
- XamlParser.cs
- MappingMetadataHelper.cs
- LinkButton.cs
- ButtonChrome.cs
- XmlChoiceIdentifierAttribute.cs
- AccessViolationException.cs
- NumericExpr.cs
- UserControlBuildProvider.cs
- JobPageOrder.cs
- FamilyCollection.cs
- ExpandableObjectConverter.cs
- SiteMapNodeItemEventArgs.cs
- FileDialogCustomPlace.cs
- InfoCardCryptoHelper.cs
- TraceShell.cs
- UnsafeNativeMethods.cs
- SharedPerformanceCounter.cs
- WebRequestModulesSection.cs
- InternalControlCollection.cs
- MessageBox.cs
- TypeContext.cs
- GAC.cs
- DecimalStorage.cs
- TextViewBase.cs
- Environment.cs
- ConfigurationSchemaErrors.cs
- _IPv6Address.cs
- TrackingRecord.cs
- WebBaseEventKeyComparer.cs
- ReferencedType.cs
- WSDualHttpBinding.cs
- SByte.cs
- HMACSHA1.cs
- DefaultHttpHandler.cs
- DbDeleteCommandTree.cs
- ExecutionContext.cs
- OpenTypeLayout.cs
- SyntaxCheck.cs
- IISMapPath.cs
- TCPClient.cs
- Util.cs
- XmlCharCheckingWriter.cs
- DBDataPermission.cs
- ItemAutomationPeer.cs
- System.Data.OracleClient_BID.cs
- nulltextnavigator.cs
- DefaultMemberAttribute.cs
- HttpPostedFile.cs
- QuaternionKeyFrameCollection.cs
- CallContext.cs