Code:
/ Dotnetfx_Vista_SP2 / Dotnetfx_Vista_SP2 / 8.0.50727.4016 / DEVDIV / depot / DevDiv / releases / Orcas / QFE / 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
- HostedElements.cs
- Enlistment.cs
- ConnectionConsumerAttribute.cs
- WhitespaceRuleReader.cs
- WebPartDisplayMode.cs
- Region.cs
- CookieProtection.cs
- MultipartIdentifier.cs
- KeyValuePair.cs
- DataGridViewCellCancelEventArgs.cs
- DrawListViewItemEventArgs.cs
- Converter.cs
- ExtensionQuery.cs
- HttpCookie.cs
- XPathNodeList.cs
- TextureBrush.cs
- FastEncoderWindow.cs
- SettingsSavedEventArgs.cs
- MetabaseSettings.cs
- FixedLineResult.cs
- WebColorConverter.cs
- SqlBuffer.cs
- ToolStripTemplateNode.cs
- OleDbCommandBuilder.cs
- embossbitmapeffect.cs
- PropertyMapper.cs
- ThemeableAttribute.cs
- DataGridCellsPresenter.cs
- HostingEnvironment.cs
- Constraint.cs
- FillRuleValidation.cs
- StylusCaptureWithinProperty.cs
- SafeProcessHandle.cs
- ProcessInputEventArgs.cs
- cache.cs
- Label.cs
- RawTextInputReport.cs
- MailWriter.cs
- Hex.cs
- Int64AnimationUsingKeyFrames.cs
- FileNotFoundException.cs
- CompiledQueryCacheEntry.cs
- ItemCheckEvent.cs
- Overlapped.cs
- DynamicValidatorEventArgs.cs
- SqlConnectionFactory.cs
- TcpProcessProtocolHandler.cs
- EntityDataSourceUtil.cs
- UserInitiatedNavigationPermission.cs
- XpsResourceDictionary.cs
- MenuItemCollection.cs
- PageAction.cs
- SynchronizationScope.cs
- SimpleBitVector32.cs
- TextReader.cs
- ProcessHost.cs
- PermissionSetEnumerator.cs
- CollectionsUtil.cs
- MimePart.cs
- TableParaClient.cs
- DataContractSerializerFaultFormatter.cs
- AdornerHitTestResult.cs
- UpdateCommand.cs
- TextProperties.cs
- FontSizeConverter.cs
- LinqDataSource.cs
- ClientSettingsProvider.cs
- ErrorStyle.cs
- TemplateNodeContextMenu.cs
- EdmToObjectNamespaceMap.cs
- UriScheme.cs
- SortQuery.cs
- Thickness.cs
- VectorAnimationUsingKeyFrames.cs
- HttpCacheVaryByContentEncodings.cs
- FileUtil.cs
- HandlerWithFactory.cs
- ErrorHandler.cs
- PathData.cs
- EventWaitHandle.cs
- ListControlStringCollectionEditor.cs
- SqlTypeConverter.cs
- ZipFileInfoCollection.cs
- ObjectStateFormatter.cs
- BitmapEffectDrawing.cs
- TypeDependencyAttribute.cs
- CalloutQueueItem.cs
- ListItemCollection.cs
- NumericExpr.cs
- AuthenticatedStream.cs
- EventListener.cs
- JoinElimination.cs
- httpserverutility.cs
- NetTcpSecurity.cs
- MetadataPropertyvalue.cs
- StylusButtonEventArgs.cs
- RowToParametersTransformer.cs
- Polygon.cs
- DataSvcMapFile.cs
- PagedDataSource.cs