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
- SiteIdentityPermission.cs
- TableRowsCollectionEditor.cs
- FontInfo.cs
- CacheDependency.cs
- RadioButtonList.cs
- ColumnHeaderConverter.cs
- SubclassTypeValidator.cs
- AppendHelper.cs
- AttributeEmitter.cs
- FlowDocumentFormatter.cs
- GridViewColumnCollectionChangedEventArgs.cs
- XmlExtensionFunction.cs
- DashStyle.cs
- FilterableData.cs
- DesignTimeResourceProviderFactoryAttribute.cs
- _ProxyChain.cs
- AttributeTableBuilder.cs
- ClientSection.cs
- DiagnosticTrace.cs
- DataGrid.cs
- TabControlAutomationPeer.cs
- WindowsStatic.cs
- DataGridViewRow.cs
- EncryptedXml.cs
- TdsParameterSetter.cs
- StackBuilderSink.cs
- URLMembershipCondition.cs
- AttachmentCollection.cs
- ThaiBuddhistCalendar.cs
- CounterSetInstance.cs
- EventListenerClientSide.cs
- EventWaitHandle.cs
- TimelineGroup.cs
- ScriptDescriptor.cs
- CurrentChangingEventArgs.cs
- ScrollProviderWrapper.cs
- ObfuscateAssemblyAttribute.cs
- XmlNodeChangedEventManager.cs
- GetWinFXPath.cs
- EdmFunction.cs
- SerializerWriterEventHandlers.cs
- LinqMaximalSubtreeNominator.cs
- LinqDataSourceDisposeEventArgs.cs
- X509Certificate2Collection.cs
- GridViewColumnCollectionChangedEventArgs.cs
- PrePostDescendentsWalker.cs
- PasswordPropertyTextAttribute.cs
- PropertyGridView.cs
- BindingExpressionUncommonField.cs
- XPathScanner.cs
- ConfigPathUtility.cs
- WorkerRequest.cs
- GradientStopCollection.cs
- SqlClientWrapperSmiStreamChars.cs
- Container.cs
- LambdaCompiler.Binary.cs
- ItemsControl.cs
- TTSVoice.cs
- TablePatternIdentifiers.cs
- XComponentModel.cs
- QilInvokeLateBound.cs
- FigureParaClient.cs
- XhtmlBasicLiteralTextAdapter.cs
- RadioButtonList.cs
- GetWorkflowTree.cs
- CodeIdentifier.cs
- PropertyChangingEventArgs.cs
- SimpleApplicationHost.cs
- HebrewCalendar.cs
- BitmapPalettes.cs
- ExternalCalls.cs
- Parser.cs
- TemplateXamlParser.cs
- ListenerElementsCollection.cs
- ToolBar.cs
- DeviceContexts.cs
- TextContainerHelper.cs
- StylusButton.cs
- SHA1CryptoServiceProvider.cs
- DataMemberAttribute.cs
- WebBrowserNavigatedEventHandler.cs
- ActivationArguments.cs
- LayoutEvent.cs
- wpf-etw.cs
- SpellCheck.cs
- SessionStateUtil.cs
- ReadOnlyActivityGlyph.cs
- MetadataItem_Static.cs
- EmptyQuery.cs
- DbProviderFactories.cs
- CompressionTransform.cs
- AssemblyAttributes.cs
- WebPartVerb.cs
- TemplateControlParser.cs
- UIElement3DAutomationPeer.cs
- TemplatedMailWebEventProvider.cs
- NameValueSectionHandler.cs
- DataGridViewCheckBoxColumn.cs
- ErrorReporting.cs
- AddIn.cs