Code:
/ Dotnetfx_Win7_3.5.1 / Dotnetfx_Win7_3.5.1 / 3.5.1 / DEVDIV / depot / DevDiv / releases / Orcas / NetFXw7 / 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
- CreateUserWizardStep.cs
- HtmlTextBoxAdapter.cs
- EmptyEnumerable.cs
- ExpandSegment.cs
- SecurityBindingElementImporter.cs
- SourceSwitch.cs
- CompModSwitches.cs
- StylusPointPropertyInfoDefaults.cs
- DataRecordInternal.cs
- ValueChangedEventManager.cs
- Deflater.cs
- DesignUtil.cs
- MetaModel.cs
- TimeoutException.cs
- latinshape.cs
- CodeTypeReferenceExpression.cs
- HtmlInputButton.cs
- XmlCharCheckingWriter.cs
- PageCodeDomTreeGenerator.cs
- ExpandButtonVisibilityConverter.cs
- EventEntry.cs
- IdentityReference.cs
- ExpressionEditorAttribute.cs
- BaseCodePageEncoding.cs
- MaskedTextProvider.cs
- DataGridItemEventArgs.cs
- TranslateTransform.cs
- TextTreeInsertUndoUnit.cs
- InternalCache.cs
- ValidationRule.cs
- SessionStateSection.cs
- Point4DConverter.cs
- _IPv6Address.cs
- DCSafeHandle.cs
- StorageComplexTypeMapping.cs
- GradientStopCollection.cs
- FaultHandlingFilter.cs
- RtfControlWordInfo.cs
- SecureEnvironment.cs
- HostProtectionPermission.cs
- WebControlsSection.cs
- SplitterDesigner.cs
- DbConnectionFactory.cs
- CurrencyManager.cs
- Executor.cs
- TreeNodeSelectionProcessor.cs
- UrlMappingCollection.cs
- ScrollViewerAutomationPeer.cs
- ProxyWebPartManagerDesigner.cs
- ImageAutomationPeer.cs
- MeasureData.cs
- CounterSet.cs
- Ray3DHitTestResult.cs
- BitmapDecoder.cs
- XmlSchemaChoice.cs
- CodeVariableReferenceExpression.cs
- VarRefManager.cs
- SetterBase.cs
- EventSinkHelperWriter.cs
- OverflowException.cs
- XamlStream.cs
- WebPartExportVerb.cs
- DefaultDiscoveryServiceExtension.cs
- Security.cs
- AttachedPropertyDescriptor.cs
- VolatileEnlistmentMultiplexing.cs
- HierarchicalDataBoundControl.cs
- SelectedGridItemChangedEvent.cs
- HtmlWindowCollection.cs
- RawTextInputReport.cs
- PageCatalogPart.cs
- OledbConnectionStringbuilder.cs
- ObjRef.cs
- TaskFormBase.cs
- _NegotiateClient.cs
- HttpStreamXmlDictionaryWriter.cs
- XpsPackagingException.cs
- SourceSwitch.cs
- StringPropertyBuilder.cs
- CompoundFileStorageReference.cs
- ServerValidateEventArgs.cs
- HostedElements.cs
- StreamInfo.cs
- DesignerSerializationVisibilityAttribute.cs
- ParameterToken.cs
- Serializer.cs
- OrderByBuilder.cs
- Tracking.cs
- SchemaTableOptionalColumn.cs
- IdnMapping.cs
- Matrix.cs
- OrderToken.cs
- PageBuildProvider.cs
- SplitterCancelEvent.cs
- CombinedGeometry.cs
- ResourceProperty.cs
- DataObjectMethodAttribute.cs
- SafePEFileHandle.cs
- RowsCopiedEventArgs.cs
- MarshalByValueComponent.cs