Code:
/ 4.0 / 4.0 / 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. 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
- TempFiles.cs
- PrinterResolution.cs
- ProfileBuildProvider.cs
- EUCJPEncoding.cs
- MimeAnyImporter.cs
- _ScatterGatherBuffers.cs
- DrawingContextDrawingContextWalker.cs
- SqlTypesSchemaImporter.cs
- GlyphManager.cs
- XamlStyleSerializer.cs
- MembershipUser.cs
- MediaContextNotificationWindow.cs
- LazyTextWriterCreator.cs
- CharUnicodeInfo.cs
- RangeValidator.cs
- Range.cs
- HttpRequestBase.cs
- ResourcesChangeInfo.cs
- GregorianCalendar.cs
- PermissionAttributes.cs
- Hash.cs
- StorageInfo.cs
- OleDbEnumerator.cs
- smtpconnection.cs
- WorkflowInstanceUnhandledExceptionRecord.cs
- TaiwanLunisolarCalendar.cs
- System.Data_BID.cs
- ListBoxAutomationPeer.cs
- DataGridViewBand.cs
- MatrixKeyFrameCollection.cs
- basecomparevalidator.cs
- WebEncodingValidatorAttribute.cs
- CaseStatement.cs
- CellRelation.cs
- PermissionSetTriple.cs
- CalendarDay.cs
- FilteredXmlReader.cs
- EventLogPermissionEntry.cs
- CodeArrayIndexerExpression.cs
- diagnosticsswitches.cs
- GridItem.cs
- PackageFilter.cs
- DataGridViewTextBoxCell.cs
- WorkflowPrinting.cs
- StrongNameKeyPair.cs
- ObjectAnimationUsingKeyFrames.cs
- Registry.cs
- EasingKeyFrames.cs
- AmbientLight.cs
- Compiler.cs
- RequestCachePolicyConverter.cs
- PrinterUnitConvert.cs
- InlineUIContainer.cs
- RequiredFieldValidator.cs
- CoordinationService.cs
- SettingsPropertyCollection.cs
- HttpCookieCollection.cs
- ErrorFormatter.cs
- ValueQuery.cs
- FileSecurity.cs
- StorageComplexTypeMapping.cs
- VisualTreeHelper.cs
- SubpageParaClient.cs
- SafeArrayRankMismatchException.cs
- DocumentSequence.cs
- webeventbuffer.cs
- TransactionProtocol.cs
- FragmentNavigationEventArgs.cs
- DataControlLinkButton.cs
- RegexCaptureCollection.cs
- CultureInfoConverter.cs
- SocketInformation.cs
- ExtensionQuery.cs
- HttpConfigurationContext.cs
- XPathNodePointer.cs
- DataObjectSettingDataEventArgs.cs
- DependencyObjectPropertyDescriptor.cs
- ArcSegment.cs
- DataFormat.cs
- UserControlBuildProvider.cs
- DataGridViewCellStyle.cs
- SaveFileDialog.cs
- IpcPort.cs
- CompositeCollectionView.cs
- RelationshipNavigation.cs
- EditorPart.cs
- propertytag.cs
- ReadWriteObjectLock.cs
- BitmapEffectDrawingContextState.cs
- OleDbWrapper.cs
- PreProcessor.cs
- Exceptions.cs
- BrowserDefinitionCollection.cs
- AttributeEmitter.cs
- BeginStoryboard.cs
- EncoderFallback.cs
- SemanticBasicElement.cs
- LazyInitializer.cs
- TextTreePropertyUndoUnit.cs
- DbQueryCommandTree.cs