Code:
/ 4.0 / 4.0 / untmp / DEVDIV_TFS / Dev10 / Releases / RTMRel / ndp / fx / src / DLinq / Dlinq / SqlClient / Query / SqlUnionizer.cs / 1305376 / 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.
Link Menu

This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- TreeBuilderXamlTranslator.cs
- DesignerTransaction.cs
- FreezableCollection.cs
- SafeProcessHandle.cs
- XmlSerializer.cs
- MenuCommand.cs
- StateChangeEvent.cs
- SizeAnimationBase.cs
- SettingsPropertyValueCollection.cs
- RequestUriProcessor.cs
- XmlBufferReader.cs
- ToolStripItemBehavior.cs
- As.cs
- TableLayoutStyleCollection.cs
- MemberProjectedSlot.cs
- ClickablePoint.cs
- GridPattern.cs
- OutputCacheProfile.cs
- TextTreeFixupNode.cs
- Storyboard.cs
- QilGeneratorEnv.cs
- Collection.cs
- TableLayoutStyleCollection.cs
- WindowVisualStateTracker.cs
- Token.cs
- FontUnitConverter.cs
- ReaderWriterLock.cs
- SqlReorderer.cs
- BindingsCollection.cs
- XmlSerializableReader.cs
- HyperLinkColumn.cs
- XmlSchemaComplexType.cs
- xdrvalidator.cs
- TiffBitmapDecoder.cs
- DocumentViewerBaseAutomationPeer.cs
- LogRestartAreaEnumerator.cs
- Section.cs
- OptionalColumn.cs
- BuilderInfo.cs
- DataGridViewTextBoxColumn.cs
- SafeWaitHandle.cs
- CounterSetInstanceCounterDataSet.cs
- PersonalizableTypeEntry.cs
- LayoutSettings.cs
- SystemColorTracker.cs
- DataPointer.cs
- ExpressionBuilderCollection.cs
- ListViewSelectEventArgs.cs
- MexBindingBindingCollectionElement.cs
- ApplicationDirectory.cs
- OdbcErrorCollection.cs
- MsmqMessageProperty.cs
- LineVisual.cs
- StaticTextPointer.cs
- FileLoadException.cs
- TargetInvocationException.cs
- ResXResourceWriter.cs
- PropertyTab.cs
- DirtyTextRange.cs
- WebPartExportVerb.cs
- AssemblyNameUtility.cs
- TickBar.cs
- DependencyStoreSurrogate.cs
- MultiplexingDispatchMessageFormatter.cs
- SQLInt16Storage.cs
- DateTimeParse.cs
- TraceData.cs
- ContentTextAutomationPeer.cs
- ScriptMethodAttribute.cs
- WorkflowMarkupElementEventArgs.cs
- HuffModule.cs
- ServiceOperation.cs
- TreeView.cs
- ComponentCollection.cs
- InvalidProgramException.cs
- EllipseGeometry.cs
- StrongNamePublicKeyBlob.cs
- VectorValueSerializer.cs
- AppSettingsExpressionBuilder.cs
- FrameworkRichTextComposition.cs
- LogRestartAreaEnumerator.cs
- FontDialog.cs
- SafeHandles.cs
- DateTimeConstantAttribute.cs
- SqlRewriteScalarSubqueries.cs
- XmlHierarchicalEnumerable.cs
- ECDiffieHellman.cs
- SystemIPv4InterfaceProperties.cs
- SystemIcmpV6Statistics.cs
- DataGridViewRowContextMenuStripNeededEventArgs.cs
- Win32Exception.cs
- BinarySerializer.cs
- OutputScopeManager.cs
- CodeIdentifier.cs
- UnmanagedHandle.cs
- GotoExpression.cs
- TypeConverterBase.cs
- StandardCommandToolStripMenuItem.cs
- StringValidator.cs
- streamingZipPartStream.cs