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
- ProtocolsConfigurationHandler.cs
- XmlDocumentSerializer.cs
- LoadRetryAsyncResult.cs
- PolicyImporterElement.cs
- XmlBindingWorker.cs
- BooleanExpr.cs
- XamlStream.cs
- GifBitmapDecoder.cs
- ContextStaticAttribute.cs
- OleDbParameter.cs
- BitmapCodecInfo.cs
- PasswordTextNavigator.cs
- DescriptionAttribute.cs
- TypeInitializationException.cs
- XmlDeclaration.cs
- HandleRef.cs
- PeerNameResolver.cs
- TiffBitmapDecoder.cs
- IntSecurity.cs
- ImageSource.cs
- MiniCustomAttributeInfo.cs
- CustomWebEventKey.cs
- ExtensionSurface.cs
- Subtree.cs
- DesignerDataTableBase.cs
- BinaryFormatterWriter.cs
- ChangeTracker.cs
- TargetControlTypeAttribute.cs
- BaseAutoFormat.cs
- SqlTypeConverter.cs
- SpnegoTokenAuthenticator.cs
- TextEditorTables.cs
- MenuEventArgs.cs
- EntityContainerEmitter.cs
- WindowsIPAddress.cs
- SourceFilter.cs
- DataGridViewCellPaintingEventArgs.cs
- FixedSOMFixedBlock.cs
- ExportException.cs
- SatelliteContractVersionAttribute.cs
- RTLAwareMessageBox.cs
- XmlImplementation.cs
- ThrowOnMultipleAssignment.cs
- LineSegment.cs
- FilterFactory.cs
- LowerCaseStringConverter.cs
- HttpVersion.cs
- DataGridCaption.cs
- ResourceDisplayNameAttribute.cs
- PreservationFileReader.cs
- CodeAttributeArgument.cs
- securestring.cs
- EventLogTraceListener.cs
- ClientSettingsProvider.cs
- TextFormatterContext.cs
- UriTemplateDispatchFormatter.cs
- PipeStream.cs
- BamlWriter.cs
- DodSequenceMerge.cs
- SqlComparer.cs
- webclient.cs
- NumberSubstitution.cs
- AsymmetricAlgorithm.cs
- ContextStack.cs
- PerfService.cs
- AspNetSynchronizationContext.cs
- DataListItemEventArgs.cs
- TargetControlTypeCache.cs
- ChannelTracker.cs
- LastQueryOperator.cs
- XPathSelfQuery.cs
- ListViewUpdatedEventArgs.cs
- Int16AnimationBase.cs
- GroupByQueryOperator.cs
- ServiceHostingEnvironmentSection.cs
- WebServicesInteroperability.cs
- WindowsSecurityTokenAuthenticator.cs
- SecurityHelper.cs
- SendMessageContent.cs
- ConstraintEnumerator.cs
- RankException.cs
- Image.cs
- SafeFileMapViewHandle.cs
- ExpressionPrinter.cs
- PropertyValueEditor.cs
- OleDbConnectionInternal.cs
- TreeChangeInfo.cs
- SectionInput.cs
- ContextInformation.cs
- WindowPattern.cs
- TimeSpanValidator.cs
- PeerName.cs
- EventWaitHandle.cs
- Block.cs
- StrongNameMembershipCondition.cs
- XmlSchemaInferenceException.cs
- UserPreferenceChangedEventArgs.cs
- Utils.cs
- XmlCDATASection.cs
- FontNamesConverter.cs