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
- regiisutil.cs
- HtmlProps.cs
- ParallelLoopState.cs
- InvalidContentTypeException.cs
- BoolLiteral.cs
- ConvertEvent.cs
- RoutedEventArgs.cs
- ConnectionPoolManager.cs
- StateFinalizationActivity.cs
- IgnoreFlushAndCloseStream.cs
- MimeBasePart.cs
- ActivityExecutionContextCollection.cs
- WizardForm.cs
- AttachedAnnotation.cs
- DataTrigger.cs
- DbConnectionHelper.cs
- GC.cs
- ColorContext.cs
- RichTextBox.cs
- ArrangedElementCollection.cs
- complextypematerializer.cs
- DataListItemEventArgs.cs
- OracleCommand.cs
- _NestedSingleAsyncResult.cs
- XsltArgumentList.cs
- DataGridViewRowConverter.cs
- UniqueTransportManagerRegistration.cs
- ListSurrogate.cs
- FixedSOMTableRow.cs
- DispatcherExceptionFilterEventArgs.cs
- WebBrowser.cs
- CorrelationTokenInvalidatedHandler.cs
- StringSorter.cs
- BaseCodePageEncoding.cs
- DockPanel.cs
- ExpressionVisitor.cs
- SoapEnumAttribute.cs
- DynamicField.cs
- XmlNavigatorStack.cs
- ConfigurationStrings.cs
- SimplePropertyEntry.cs
- AppSettingsReader.cs
- DataGridViewTextBoxCell.cs
- DrawingAttributeSerializer.cs
- ImmutableObjectAttribute.cs
- WindowsTreeView.cs
- CodeBinaryOperatorExpression.cs
- CacheEntry.cs
- ExpressionDumper.cs
- DocumentPage.cs
- TextContainer.cs
- DtdParser.cs
- DataColumnChangeEvent.cs
- HttpRequestCacheValidator.cs
- CompiledQuery.cs
- GridViewUpdatedEventArgs.cs
- BooleanExpr.cs
- ArrayConverter.cs
- QilValidationVisitor.cs
- DataGrid.cs
- ColorBuilder.cs
- SchemaRegistration.cs
- SelectorAutomationPeer.cs
- ToolboxItem.cs
- DependencyPropertyChangedEventArgs.cs
- FieldToken.cs
- ErrorHandler.cs
- SecurityUniqueId.cs
- PermissionAttributes.cs
- formatter.cs
- XmlSchemaInfo.cs
- ListParaClient.cs
- CollectionContainer.cs
- BinaryMessageEncodingBindingElement.cs
- AccessDataSource.cs
- AssemblyBuilderData.cs
- ExecutionContext.cs
- Number.cs
- RsaKeyIdentifierClause.cs
- AccessDataSource.cs
- SystemTcpConnection.cs
- PropertyPushdownHelper.cs
- ImageSource.cs
- VirtualStackFrame.cs
- ProxyWebPartConnectionCollection.cs
- Rfc2898DeriveBytes.cs
- loginstatus.cs
- DataSourceConverter.cs
- EmptyStringExpandableObjectConverter.cs
- TextTreeExtractElementUndoUnit.cs
- ResourceCategoryAttribute.cs
- ActivityInfo.cs
- TableCell.cs
- MsmqInputChannelListenerBase.cs
- XmlLinkedNode.cs
- NonSerializedAttribute.cs
- DrawingCollection.cs
- ProfessionalColors.cs
- GroupBox.cs
- CrossAppDomainChannel.cs