Code:
/ 4.0 / 4.0 / untmp / 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.
Link Menu
This book is available now!
Buy at Amazon US or
Buy at Amazon UK
- XmlElementAttribute.cs
- MarshalByValueComponent.cs
- HttpAsyncResult.cs
- util.cs
- RecommendedAsConfigurableAttribute.cs
- StatusBarPanelClickEvent.cs
- UiaCoreApi.cs
- SocketPermission.cs
- InvalidOperationException.cs
- SoapTransportImporter.cs
- CatalogZoneBase.cs
- ScriptingAuthenticationServiceSection.cs
- WebPartCollection.cs
- ListItemCollection.cs
- EditorZoneBase.cs
- SerializationException.cs
- ApplicationServiceHelper.cs
- PopupRootAutomationPeer.cs
- SourceLineInfo.cs
- SmtpException.cs
- XmlSchemaIdentityConstraint.cs
- BlockCollection.cs
- SparseMemoryStream.cs
- TdsParserHelperClasses.cs
- Binding.cs
- ReflectionHelper.cs
- OracleTimeSpan.cs
- SqlConnectionFactory.cs
- ToolboxDataAttribute.cs
- ConfigurationCollectionAttribute.cs
- ProfileGroupSettingsCollection.cs
- FragmentQueryProcessor.cs
- ByteConverter.cs
- XmlAttribute.cs
- XmlUtf8RawTextWriter.cs
- Marshal.cs
- RectangleGeometry.cs
- X509Certificate2.cs
- ConfigXmlSignificantWhitespace.cs
- FloaterParagraph.cs
- DataControlLinkButton.cs
- AmbientLight.cs
- IpcManager.cs
- UrlPath.cs
- DataServiceRequestException.cs
- DebugViewWriter.cs
- ListViewItemEventArgs.cs
- ObjectQueryState.cs
- DataGridViewRowConverter.cs
- LinkClickEvent.cs
- SystemException.cs
- BindingWorker.cs
- SystemIPAddressInformation.cs
- TargetFrameworkUtil.cs
- TextRangeSerialization.cs
- DataGridViewColumnHeaderCell.cs
- _ProxyRegBlob.cs
- ModelPerspective.cs
- OraclePermission.cs
- Viewport2DVisual3D.cs
- ClassHandlersStore.cs
- FormatterServices.cs
- XmlAttributeCollection.cs
- IssuanceLicense.cs
- KeyToListMap.cs
- Certificate.cs
- ColumnMapProcessor.cs
- StringToken.cs
- AppearanceEditorPart.cs
- Int32Rect.cs
- WhitespaceSignificantCollectionAttribute.cs
- DataGridState.cs
- SharedPerformanceCounter.cs
- ToolboxItemAttribute.cs
- ToolStripItemRenderEventArgs.cs
- NestedContainer.cs
- HtmlShimManager.cs
- SecurityKeyType.cs
- TextServicesLoader.cs
- Knowncolors.cs
- ModifiableIteratorCollection.cs
- TraceContextRecord.cs
- StateManagedCollection.cs
- EncryptedPackage.cs
- updatecommandorderer.cs
- DataGridViewCellStyleConverter.cs
- TimeoutException.cs
- ProjectionPlan.cs
- AssemblySettingAttributes.cs
- ValidationEventArgs.cs
- FamilyCollection.cs
- GeometryCombineModeValidation.cs
- DisplayToken.cs
- DataSourceXmlElementAttribute.cs
- ClearTypeHintValidation.cs
- ControllableStoryboardAction.cs
- SqlBinder.cs
- TimelineCollection.cs
- ProtectedConfiguration.cs
- WorkflowRuntimeServiceElement.cs