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
- JumpPath.cs
- PersonalizationStateQuery.cs
- XmlUTF8TextReader.cs
- ArglessEventHandlerProxy.cs
- ProfileManager.cs
- HtmlUtf8RawTextWriter.cs
- ListViewGroupItemCollection.cs
- GridViewDeletedEventArgs.cs
- entitydatasourceentitysetnameconverter.cs
- TypeProvider.cs
- InkCanvasSelection.cs
- SHA1Managed.cs
- IISMapPath.cs
- ProviderUtil.cs
- TextPenaltyModule.cs
- ProxyElement.cs
- RankException.cs
- SizeAnimationBase.cs
- ResourceDictionary.cs
- PathFigureCollection.cs
- ExpressionLexer.cs
- Subtree.cs
- ProxyWebPart.cs
- PersonalizationAdministration.cs
- ExceptionHandlerDesigner.cs
- Rect3D.cs
- BindingCollection.cs
- PasswordTextContainer.cs
- Assembly.cs
- HyperLinkStyle.cs
- SiteMapHierarchicalDataSourceView.cs
- StringComparer.cs
- SqlXmlStorage.cs
- AxisAngleRotation3D.cs
- UriParserTemplates.cs
- TraceHandler.cs
- SecurityRuntime.cs
- Int32CAMarshaler.cs
- XmlKeywords.cs
- Label.cs
- MultiPropertyDescriptorGridEntry.cs
- JsonQNameDataContract.cs
- SafeEventLogWriteHandle.cs
- AttachInfo.cs
- UnsafeNativeMethods.cs
- StreamHelper.cs
- DataGridViewDataConnection.cs
- RectAnimationClockResource.cs
- TableDetailsCollection.cs
- ContentElementAutomationPeer.cs
- FixedPageProcessor.cs
- StylusCaptureWithinProperty.cs
- DurationConverter.cs
- StorageRoot.cs
- TabRenderer.cs
- XPathMessageFilterTable.cs
- XmlSiteMapProvider.cs
- Socket.cs
- WebPartRestoreVerb.cs
- GlobalProxySelection.cs
- HttpHandlersSection.cs
- UriSectionReader.cs
- RawStylusActions.cs
- UpDownBase.cs
- SqlBulkCopy.cs
- AsyncStreamReader.cs
- SerializationSectionGroup.cs
- SynchronizedInputPattern.cs
- OdbcReferenceCollection.cs
- CursorInteropHelper.cs
- CheckedPointers.cs
- Executor.cs
- NativeObjectSecurity.cs
- Wrapper.cs
- TypefaceMap.cs
- RuntimeWrappedException.cs
- EntityDataSourceWrapperCollection.cs
- DoubleAnimationUsingPath.cs
- MarkupProperty.cs
- XmlQuerySequence.cs
- RegistryKey.cs
- SmiContext.cs
- QualifiedId.cs
- ParameterRefs.cs
- RelativeSource.cs
- WebBrowserContainer.cs
- ExpandoClass.cs
- selecteditemcollection.cs
- MemberMaps.cs
- PKCS1MaskGenerationMethod.cs
- TripleDES.cs
- CompilerError.cs
- PictureBox.cs
- UserControlAutomationPeer.cs
- AssemblyCollection.cs
- DllHostInitializer.cs
- ClientUrlResolverWrapper.cs
- RSAOAEPKeyExchangeFormatter.cs
- Schema.cs
- FieldCollectionEditor.cs