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
- BinaryNode.cs
- SHA384CryptoServiceProvider.cs
- Sql8ExpressionRewriter.cs
- TimeoutValidationAttribute.cs
- UserInitiatedRoutedEventPermissionAttribute.cs
- WebPartZone.cs
- UpWmlPageAdapter.cs
- WsdlServiceChannelBuilder.cs
- StickyNoteContentControl.cs
- InternalRelationshipCollection.cs
- MultiPropertyDescriptorGridEntry.cs
- RectangleHotSpot.cs
- Ray3DHitTestResult.cs
- XpsFilter.cs
- AccessDataSourceView.cs
- RuleSettings.cs
- LinearGradientBrush.cs
- SoapCodeExporter.cs
- NamespaceMapping.cs
- XmlSerializerSection.cs
- HttpClientCertificate.cs
- LinqDataSourceHelper.cs
- FocusWithinProperty.cs
- DesignDataSource.cs
- CommonDialog.cs
- SQLSingleStorage.cs
- Point3DCollectionValueSerializer.cs
- MiniMapControl.xaml.cs
- TextProperties.cs
- DesignTimeResourceProviderFactoryAttribute.cs
- LazyInitializer.cs
- WindowsFormsHost.cs
- EditorZoneBase.cs
- OneToOneMappingSerializer.cs
- RemotingAttributes.cs
- PenThreadWorker.cs
- ProcessHost.cs
- PathData.cs
- EditCommandColumn.cs
- HttpWrapper.cs
- MessageQueuePermissionEntryCollection.cs
- FileEnumerator.cs
- HuffCodec.cs
- DockAndAnchorLayout.cs
- WebException.cs
- PersonalizationStateInfoCollection.cs
- PasswordTextContainer.cs
- MethodAccessException.cs
- CodeExpressionCollection.cs
- MulticastOption.cs
- ExpandSegment.cs
- DbProviderFactory.cs
- CodeNamespaceImport.cs
- ObjectDesignerDataSourceView.cs
- LinkedDataMemberFieldEditor.cs
- InvokeMemberBinder.cs
- EntityReference.cs
- RegistryKey.cs
- IISUnsafeMethods.cs
- DeleteMemberBinder.cs
- UserUseLicenseDictionaryLoader.cs
- CodeNamespaceImport.cs
- KeySplineConverter.cs
- ParameterCollection.cs
- FlowchartDesigner.xaml.cs
- XhtmlBasicImageAdapter.cs
- Registry.cs
- CounterSample.cs
- SystemException.cs
- PauseStoryboard.cs
- securitycriticaldataformultiplegetandset.cs
- TextPenaltyModule.cs
- Material.cs
- LocatorPart.cs
- FontNamesConverter.cs
- RootProjectionNode.cs
- DataGridViewCellFormattingEventArgs.cs
- RoutedEventValueSerializer.cs
- SoapClientProtocol.cs
- UnknownWrapper.cs
- CounterCreationData.cs
- WindowsSolidBrush.cs
- DataControlFieldCollection.cs
- DeflateStreamAsyncResult.cs
- COSERVERINFO.cs
- WebPartConnectionsEventArgs.cs
- OptimalBreakSession.cs
- ellipse.cs
- NavigationPropertyAccessor.cs
- JournalEntryListConverter.cs
- WindowsScroll.cs
- Trace.cs
- AsynchronousChannelMergeEnumerator.cs
- Control.cs
- EntityViewGenerator.cs
- HttpModule.cs
- AppSettingsExpressionBuilder.cs
- ContainerTracking.cs
- CultureTableRecord.cs
- OptionalRstParameters.cs