Code:
/ Net / Net / 3.5.50727.3053 / DEVDIV / depot / DevDiv / releases / Orcas / SP / ndp / fx / src / DLinq / Dlinq / SqlClient / Query / SqlUnionizer.cs / 1 / SqlUnionizer.cs
using System; using System.Collections.Generic; using System.Text; using System.Diagnostics.CodeAnalysis; namespace System.Data.Linq.SqlClient { internal class SqlUnionizer { internal static SqlNode Unionize(SqlNode node) { return new Visitor().Visit(node); } class Visitor : SqlVisitor { internal override SqlSelect VisitSelect(SqlSelect select) { base.VisitSelect(select); // enforce exact ordering of columns in union selects SqlUnion union = this.GetUnion(select.From); if (union != null) { SqlSelect sleft = union.Left as SqlSelect; SqlSelect sright = union.Right as SqlSelect; if (sleft != null & sright != null) { // preset ordinals to high values (so any unreachable column definition is ordered last) for (int i = 0, n = sleft.Row.Columns.Count; i < n; i++) { sleft.Row.Columns[i].Ordinal = select.Row.Columns.Count + i; } for (int i = 0, n = sright.Row.Columns.Count; i < n; i++) { sright.Row.Columns[i].Ordinal = select.Row.Columns.Count + i; } // next assign ordinals to all direct columns in subselects for (int i = 0, n = select.Row.Columns.Count; i < n; i++) { SqlExprSet es = select.Row.Columns[i].Expression as SqlExprSet; if (es != null) { for (int e = 0, en = es.Expressions.Count; e < en; e++) { SqlColumnRef cr = es.Expressions[e] as SqlColumnRef; if (cr != null && e >= select.Row.Columns.Count) { cr.Column.Ordinal = i; } } } } // next sort columns in left & right subselects Comparisoncomp = (x,y) => x.Ordinal - y.Ordinal; sleft.Row.Columns.Sort(comp); sright.Row.Columns.Sort(comp); } } return select; } [SuppressMessage("Microsoft.Performance", "CA1822:MarkMembersAsStatic", Justification="Unknown reason.")] private SqlUnion GetUnion(SqlSource source) { SqlAlias alias = source as SqlAlias; if (alias != null) { SqlUnion union = alias.Node as SqlUnion; if (union != null) return union; } return null; } } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007. // Copyright (c) Microsoft Corporation. All rights reserved. using System; using System.Collections.Generic; using System.Text; using System.Diagnostics.CodeAnalysis; namespace System.Data.Linq.SqlClient { internal class SqlUnionizer { internal static SqlNode Unionize(SqlNode node) { return new Visitor().Visit(node); } class Visitor : SqlVisitor { internal override SqlSelect VisitSelect(SqlSelect select) { base.VisitSelect(select); // enforce exact ordering of columns in union selects SqlUnion union = this.GetUnion(select.From); if (union != null) { SqlSelect sleft = union.Left as SqlSelect; SqlSelect sright = union.Right as SqlSelect; if (sleft != null & sright != null) { // preset ordinals to high values (so any unreachable column definition is ordered last) for (int i = 0, n = sleft.Row.Columns.Count; i < n; i++) { sleft.Row.Columns[i].Ordinal = select.Row.Columns.Count + i; } for (int i = 0, n = sright.Row.Columns.Count; i < n; i++) { sright.Row.Columns[i].Ordinal = select.Row.Columns.Count + i; } // next assign ordinals to all direct columns in subselects for (int i = 0, n = select.Row.Columns.Count; i < n; i++) { SqlExprSet es = select.Row.Columns[i].Expression as SqlExprSet; if (es != null) { for (int e = 0, en = es.Expressions.Count; e < en; e++) { SqlColumnRef cr = es.Expressions[e] as SqlColumnRef; if (cr != null && e >= select.Row.Columns.Count) { cr.Column.Ordinal = i; } } } } // next sort columns in left & right subselects Comparison comp = (x,y) => x.Ordinal - y.Ordinal; sleft.Row.Columns.Sort(comp); sright.Row.Columns.Sort(comp); } } return select; } [SuppressMessage("Microsoft.Performance", "CA1822:MarkMembersAsStatic", Justification="Unknown reason.")] private SqlUnion GetUnion(SqlSource source) { SqlAlias alias = source as SqlAlias; if (alias != null) { SqlUnion union = alias.Node as SqlUnion; if (union != null) return union; } return null; } } } } // File provided for Reference Use Only by Microsoft Corporation (c) 2007. // Copyright (c) Microsoft Corporation. All rights reserved.
Link Menu
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- SqlNotificationEventArgs.cs
- TaskScheduler.cs
- MonthCalendar.cs
- MessageAction.cs
- EventWaitHandleSecurity.cs
- NamedPermissionSet.cs
- PageCodeDomTreeGenerator.cs
- SymbolEqualComparer.cs
- MouseCaptureWithinProperty.cs
- VarRemapper.cs
- WebPartTransformer.cs
- Quad.cs
- BitmapScalingModeValidation.cs
- Tile.cs
- StringUtil.cs
- Button.cs
- FilterEventArgs.cs
- AtlasWeb.Designer.cs
- DateTimeOffsetConverter.cs
- TextOutput.cs
- SoapHeaders.cs
- MexTcpBindingElement.cs
- _RequestCacheProtocol.cs
- ProcessHost.cs
- SourceLineInfo.cs
- EncryptedData.cs
- HMACMD5.cs
- SortDescription.cs
- XmlUnspecifiedAttribute.cs
- InvalidOperationException.cs
- SafeSecurityHandles.cs
- GroupJoinQueryOperator.cs
- RegexMatchCollection.cs
- InternalControlCollection.cs
- SchemaTypeEmitter.cs
- IImplicitResourceProvider.cs
- LinearQuaternionKeyFrame.cs
- EntityContainerEntitySetDefiningQuery.cs
- NamespaceTable.cs
- PageParser.cs
- TextEncodedRawTextWriter.cs
- InvokerUtil.cs
- XmlNodeComparer.cs
- _RequestCacheProtocol.cs
- ProcessManager.cs
- DialogWindow.cs
- MetadataUtil.cs
- ScriptManager.cs
- ToolStripOverflowButton.cs
- FloaterParaClient.cs
- WindowsSpinner.cs
- Win32MouseDevice.cs
- ListViewCancelEventArgs.cs
- MultiBinding.cs
- SmtpNegotiateAuthenticationModule.cs
- Pen.cs
- RawStylusSystemGestureInputReport.cs
- BitmapEffectInputData.cs
- DbConnectionPoolCounters.cs
- XsltFunctions.cs
- SudsWriter.cs
- SqlDeflator.cs
- QueueProcessor.cs
- BitmapFrameDecode.cs
- DataError.cs
- KeyboardNavigation.cs
- TaskFormBase.cs
- HijriCalendar.cs
- DefaultValueTypeConverter.cs
- SequentialUshortCollection.cs
- QilPatternFactory.cs
- TakeQueryOptionExpression.cs
- EntityDataSourceWrapperPropertyDescriptor.cs
- HttpConfigurationContext.cs
- DragCompletedEventArgs.cs
- MetadataCache.cs
- InputMethod.cs
- SR.cs
- SchemaImporterExtensionElementCollection.cs
- PostBackTrigger.cs
- RequestTimeoutManager.cs
- MessageBox.cs
- ConnectorMovedEventArgs.cs
- TableLayoutPanelResizeGlyph.cs
- CounterCreationDataCollection.cs
- Int32Storage.cs
- HeaderedItemsControl.cs
- DoubleLinkListEnumerator.cs
- PeerTransportSecuritySettings.cs
- FormatterServices.cs
- ToolStripDropDownItem.cs
- WebPartTracker.cs
- OneOfScalarConst.cs
- ProcessModule.cs
- OdbcTransaction.cs
- ApplicationSettingsBase.cs
- TransformDescriptor.cs
- WebPartCatalogCloseVerb.cs
- WindowsAuthenticationEventArgs.cs
- AuthorizationSection.cs