Code:
/ Dotnetfx_Vista_SP2 / Dotnetfx_Vista_SP2 / 8.0.50727.4016 / DEVDIV / depot / DevDiv / releases / Orcas / QFE / 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
- WebPartDescriptionCollection.cs
- ProfileManager.cs
- DataBindingHandlerAttribute.cs
- WindowHideOrCloseTracker.cs
- ContainerControl.cs
- RotationValidation.cs
- TextServicesLoader.cs
- TileModeValidation.cs
- SetIndexBinder.cs
- DefaultPropertyAttribute.cs
- TemplateAction.cs
- LockRecursionException.cs
- MsmqIntegrationProcessProtocolHandler.cs
- DesignerTransaction.cs
- SimpleType.cs
- PartialList.cs
- ValidationPropertyAttribute.cs
- SelectedGridItemChangedEvent.cs
- InputReport.cs
- CharacterBufferReference.cs
- SqlExpressionNullability.cs
- EmbossBitmapEffect.cs
- MsmqAppDomainProtocolHandler.cs
- ClosureBinding.cs
- XamlStyleSerializer.cs
- HttpPostLocalhostServerProtocol.cs
- FacetChecker.cs
- ScrollableControl.cs
- DataGridHeaderBorder.cs
- ImportOptions.cs
- SplitterPanel.cs
- DataGridViewColumn.cs
- RuntimeVariableList.cs
- KeyInstance.cs
- ClientEventManager.cs
- TransactionManager.cs
- LinqDataSourceView.cs
- HtmlInputControl.cs
- WindowsClientElement.cs
- ConfigErrorGlyph.cs
- XmlDataImplementation.cs
- CompositeTypefaceMetrics.cs
- FixedSOMTable.cs
- TogglePatternIdentifiers.cs
- DataGridViewRowsAddedEventArgs.cs
- BindableTemplateBuilder.cs
- AudioFileOut.cs
- TrustLevelCollection.cs
- FormatterConverter.cs
- CryptoApi.cs
- ItemType.cs
- UserControlCodeDomTreeGenerator.cs
- RegexCompiler.cs
- ExpandSegmentCollection.cs
- PropertyValueUIItem.cs
- EntityCommandExecutionException.cs
- SQLInt16Storage.cs
- ConnectionPointCookie.cs
- WrappedReader.cs
- FragmentNavigationEventArgs.cs
- DPTypeDescriptorContext.cs
- Queue.cs
- SoapFormatExtensions.cs
- PropertyIdentifier.cs
- SQLInt32.cs
- PointF.cs
- UIElement3DAutomationPeer.cs
- ConstraintCollection.cs
- XmlEntityReference.cs
- CalendarAutoFormat.cs
- ServicePoint.cs
- SqlRecordBuffer.cs
- DataFieldConverter.cs
- MailAddressCollection.cs
- DbProviderManifest.cs
- COM2PropertyDescriptor.cs
- IfAction.cs
- CompilerError.cs
- TranslateTransform3D.cs
- TypeConverterHelper.cs
- RtfControls.cs
- ConsoleCancelEventArgs.cs
- ToolBarOverflowPanel.cs
- datacache.cs
- SettingsPropertyValue.cs
- HtmlInputHidden.cs
- XmlAttributeProperties.cs
- ProcessStartInfo.cs
- ThreadAbortException.cs
- UxThemeWrapper.cs
- DeploymentSectionCache.cs
- DurableInstance.cs
- SqlCacheDependencyDatabase.cs
- WebPartExportVerb.cs
- XmlHelper.cs
- WsdlServiceChannelBuilder.cs
- Column.cs
- ChangeTracker.cs
- GridViewRowPresenterBase.cs
- FillErrorEventArgs.cs