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
- Point3DIndependentAnimationStorage.cs
- CommonDialog.cs
- XmlSchemaProviderAttribute.cs
- InkCanvasSelectionAdorner.cs
- SafeWaitHandle.cs
- RegexWorker.cs
- HttpConfigurationContext.cs
- AdjustableArrowCap.cs
- WindowsFont.cs
- SynchronizationLockException.cs
- RequiredArgumentAttribute.cs
- EntityStoreSchemaFilterEntry.cs
- PolyQuadraticBezierSegment.cs
- QueryContinueDragEvent.cs
- SamlEvidence.cs
- ActivityCollectionMarkupSerializer.cs
- HtmlHead.cs
- ImpersonationContext.cs
- XmlSchemaComplexType.cs
- SessionStateUtil.cs
- Misc.cs
- MetadataItemEmitter.cs
- TemplateContentLoader.cs
- FtpCachePolicyElement.cs
- SecurityTraceRecordHelper.cs
- ZipIOCentralDirectoryBlock.cs
- ScriptingWebServicesSectionGroup.cs
- CompoundFileStreamReference.cs
- ObjectDisposedException.cs
- SubpageParaClient.cs
- ButtonColumn.cs
- OrderByQueryOptionExpression.cs
- WeakReferenceList.cs
- ConsoleTraceListener.cs
- EditBehavior.cs
- AnimationStorage.cs
- ZoneLinkButton.cs
- HtmlInputCheckBox.cs
- UrlSyndicationContent.cs
- SQLBinaryStorage.cs
- SimpleType.cs
- PeerNameRecord.cs
- Renderer.cs
- LexicalChunk.cs
- CompositeScriptReference.cs
- RegisteredArrayDeclaration.cs
- VirtualizedCellInfoCollection.cs
- DispatcherTimer.cs
- DataBoundControlHelper.cs
- LightweightEntityWrapper.cs
- XmlSchemaException.cs
- PropertyGridView.cs
- HttpListenerException.cs
- ThicknessAnimation.cs
- ClientTarget.cs
- MobileRedirect.cs
- WindowsSolidBrush.cs
- ImageMap.cs
- ProxyHwnd.cs
- SystemIPGlobalProperties.cs
- LockedAssemblyCache.cs
- DecoderFallback.cs
- RegexStringValidatorAttribute.cs
- CommandID.cs
- XmlQueryCardinality.cs
- DataPager.cs
- FloatMinMaxAggregationOperator.cs
- EntityDataSourceSelectedEventArgs.cs
- SqlGenericUtil.cs
- EdmToObjectNamespaceMap.cs
- DataRowChangeEvent.cs
- SR.Designer.cs
- SessionPageStateSection.cs
- SpecularMaterial.cs
- FileSecurity.cs
- ServiceCredentialsElement.cs
- OdbcCommand.cs
- DiscoveryClientReferences.cs
- COM2PropertyPageUITypeConverter.cs
- XmlName.cs
- MenuCommand.cs
- MenuEventArgs.cs
- PackageStore.cs
- RegisteredArrayDeclaration.cs
- ProfileEventArgs.cs
- PagedControl.cs
- RegexInterpreter.cs
- NavigationProperty.cs
- LoginUtil.cs
- ReadOnlyAttribute.cs
- ButtonBaseAdapter.cs
- DataColumn.cs
- ConnectionsZone.cs
- CancelRequestedQuery.cs
- TemplateKeyConverter.cs
- TrackingValidationObjectDictionary.cs
- ExpressionEditor.cs
- SafeCryptContextHandle.cs
- TypeTypeConverter.cs
- HtmlTitle.cs