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
- FreezableDefaultValueFactory.cs
- CommonRemoteMemoryBlock.cs
- AuthenticationModuleElementCollection.cs
- GridViewUpdateEventArgs.cs
- SemaphoreSlim.cs
- activationcontext.cs
- BaseProcessor.cs
- AttributeCollection.cs
- URLMembershipCondition.cs
- CheckBox.cs
- TextMetrics.cs
- KeyInstance.cs
- ImageFormatConverter.cs
- EntityDataSourceView.cs
- Expressions.cs
- MonikerHelper.cs
- MonitoringDescriptionAttribute.cs
- ReaderWriterLockWrapper.cs
- EmptyEnumerator.cs
- BindingSource.cs
- DbConnectionStringCommon.cs
- InfoCardTrace.cs
- SoundPlayer.cs
- TraceLog.cs
- DocobjHost.cs
- MtomMessageEncoder.cs
- Sql8ExpressionRewriter.cs
- HttpValueCollection.cs
- Coordinator.cs
- ObjectListShowCommandsEventArgs.cs
- LinqDataSourceInsertEventArgs.cs
- PropertyEntry.cs
- AttributeInfo.cs
- StartUpEventArgs.cs
- Enlistment.cs
- RotateTransform.cs
- ExtractedStateEntry.cs
- DeviceContext.cs
- PartBasedPackageProperties.cs
- RuleProcessor.cs
- SelectedDatesCollection.cs
- WebBrowserProgressChangedEventHandler.cs
- GridViewEditEventArgs.cs
- SafeNativeMemoryHandle.cs
- HtmlToClrEventProxy.cs
- SafeHandles.cs
- MouseActionValueSerializer.cs
- ComboBox.cs
- VisualStates.cs
- SecurityIdentifierConverter.cs
- DataGridViewComboBoxCell.cs
- BitmapEffectvisualstate.cs
- VisualCollection.cs
- DetailsViewRowCollection.cs
- XPathNodePointer.cs
- OptimalBreakSession.cs
- PersonalizationProviderHelper.cs
- RawAppCommandInputReport.cs
- ConstraintConverter.cs
- SynchronizationHandlesCodeDomSerializer.cs
- PaginationProgressEventArgs.cs
- SimpleWorkerRequest.cs
- ExpressionsCollectionConverter.cs
- ResetableIterator.cs
- SecureEnvironment.cs
- Pen.cs
- IncrementalCompileAnalyzer.cs
- NameValueConfigurationElement.cs
- XmlQueryStaticData.cs
- AttributeQuery.cs
- Timer.cs
- DesignerLoader.cs
- AssertHelper.cs
- Util.cs
- ProcessRequestArgs.cs
- WCFServiceClientProxyGenerator.cs
- MiniParameterInfo.cs
- HostingMessageProperty.cs
- IsolatedStorage.cs
- _StreamFramer.cs
- GeneralTransform3D.cs
- xml.cs
- DataBindingHandlerAttribute.cs
- QueryPrefixOp.cs
- PageAction.cs
- DesignerActionKeyboardBehavior.cs
- SecurityPolicySection.cs
- FollowerQueueCreator.cs
- XmlBinaryReaderSession.cs
- ChangePassword.cs
- TableSectionStyle.cs
- WriteTimeStream.cs
- Header.cs
- ConnectionManagementElement.cs
- CmsInterop.cs
- SqlFunctions.cs
- MediaCommands.cs
- TcpTransportElement.cs
- BasicKeyConstraint.cs
- SettingsBindableAttribute.cs