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
- SubstitutionDesigner.cs
- SatelliteContractVersionAttribute.cs
- CorrelationToken.cs
- InteropDesigner.xaml.cs
- BaseParser.cs
- ApplicationTrust.cs
- PerspectiveCamera.cs
- WindowsSpinner.cs
- TimelineClockCollection.cs
- ConfigurationStrings.cs
- processwaithandle.cs
- SecureEnvironment.cs
- SystemInformation.cs
- DesigntimeLicenseContext.cs
- x509store.cs
- MetabaseServerConfig.cs
- VectorCollectionConverter.cs
- TcpDuplicateContext.cs
- HostedNamedPipeTransportManager.cs
- WebControl.cs
- SamlAttribute.cs
- ControlPersister.cs
- RepeaterItemEventArgs.cs
- ExtendedPropertiesHandler.cs
- InstanceDataCollection.cs
- PromptBuilder.cs
- PropertyTabChangedEvent.cs
- TypeReference.cs
- SerTrace.cs
- QueryAccessibilityHelpEvent.cs
- XmlQualifiedName.cs
- XmlKeywords.cs
- InstanceHandle.cs
- BinHexEncoding.cs
- UIPermission.cs
- IndexedEnumerable.cs
- Descriptor.cs
- LoginName.cs
- SerializerProvider.cs
- SourceLocationProvider.cs
- PrinterUnitConvert.cs
- PathSegment.cs
- RSAPKCS1KeyExchangeFormatter.cs
- _OSSOCK.cs
- CodeNamespaceCollection.cs
- PolyLineSegmentFigureLogic.cs
- ColorConverter.cs
- SRGSCompiler.cs
- TextParaLineResult.cs
- securitycriticaldata.cs
- ObfuscateAssemblyAttribute.cs
- xmlformatgeneratorstatics.cs
- ObsoleteAttribute.cs
- XAMLParseException.cs
- SrgsDocumentParser.cs
- LocalIdKeyIdentifierClause.cs
- HandleCollector.cs
- DataControlLinkButton.cs
- RemoteArgument.cs
- SHA1.cs
- DynamicDataManager.cs
- ResolveResponseInfo.cs
- XPathItem.cs
- TailPinnedEventArgs.cs
- CompiledQueryCacheEntry.cs
- SqlErrorCollection.cs
- BreakRecordTable.cs
- _TransmitFileOverlappedAsyncResult.cs
- ExpandSegmentCollection.cs
- HostProtectionPermission.cs
- InfoCardTraceRecord.cs
- WindowsFormsLinkLabel.cs
- SqlErrorCollection.cs
- UserPrincipalNameElement.cs
- NonSerializedAttribute.cs
- KeyGestureConverter.cs
- HuffCodec.cs
- Visual3D.cs
- NullableDecimalSumAggregationOperator.cs
- Inline.cs
- XmlDownloadManager.cs
- OleTxTransaction.cs
- HttpEncoder.cs
- ExtensionDataObject.cs
- Panel.cs
- ScrollChrome.cs
- StateManagedCollection.cs
- Geometry.cs
- WindowsHyperlink.cs
- SafeBuffer.cs
- SecurityState.cs
- GridViewCellAutomationPeer.cs
- DoubleCollectionConverter.cs
- HttpRuntimeSection.cs
- ExcCanonicalXml.cs
- WebEvents.cs
- PersonalizationState.cs
- Quaternion.cs
- DataTemplate.cs
- BigInt.cs