Code:
/ Net / Net / 3.5.50727.3053 / DEVDIV / depot / DevDiv / releases / Orcas / SP / ndp / fx / src / DLinq / Dlinq / SqlClient / Query / SqlLiftIndependentRowExpressions.cs / 2 / SqlLiftIndependentRowExpressions.cs
using System; using System.Collections.Generic; using System.Text; using System.Diagnostics.CodeAnalysis; namespace System.Data.Linq.SqlClient { ////// Find projection expressions on the right side of CROSS APPLY that do not /// depend exclusively on right side productions and move them outside of the /// CROSS APPLY by enclosing the CROSS APPLY with a new source. /// class SqlLiftIndependentRowExpressions { internal static SqlNode Lift(SqlNode node) { ColumnLifter cl = new ColumnLifter(); node = cl.Visit(node); return node; } private class ColumnLifter : SqlVisitor { SelectScope expressionSink; SqlAggregateChecker aggregateChecker; internal ColumnLifter() { this.aggregateChecker = new SqlAggregateChecker(); } class SelectScope { // Stack of projections lifted from the right to be pushed on the left. internal Stack> Lifted = new Stack
>(); internal IEnumerable
LeftProduction; internal HashSet ReferencedExpressions = new HashSet (); } internal override SqlSelect VisitSelect(SqlSelect select) { SelectScope s = expressionSink; // Don't lift through a TOP. if (select.Top != null) { expressionSink = null; } // Don't lift through a GROUP BY (or implicit GROUP BY). if (select.GroupBy.Count > 0 || this.aggregateChecker.HasAggregates(select)) { expressionSink = null; } // Don't lift through DISTINCT if (select.IsDistinct) { expressionSink = null; } if (expressionSink != null) { List keep = new List (); List lift = new List (); foreach (SqlColumn sc in select.Row.Columns) { bool referencesLeftsideAliases = SqlAliasesReferenced.ReferencesAny(sc.Expression, expressionSink.LeftProduction); bool isLockedExpression = expressionSink.ReferencedExpressions.Contains(sc); if (referencesLeftsideAliases && !isLockedExpression) { lift.Add(sc); } else { keep.Add(sc); } } select.Row.Columns.Clear(); select.Row.Columns.AddRange(keep); if (lift.Count > 0) { expressionSink.Lifted.Push(lift); } } SqlSelect sel = base.VisitSelect(select); expressionSink = s; return sel; } internal override SqlExpression VisitColumnRef(SqlColumnRef cref) { if (expressionSink!=null) { expressionSink.ReferencedExpressions.Add(cref.Column); } return cref; } internal override SqlSource VisitJoin(SqlJoin join) { if (join.JoinType == SqlJoinType.CrossApply) { // Visit the left side as usual. join.Left = this.VisitSource(join.Left); // Visit the condition as usual. join.Condition = this.VisitExpression(join.Condition); // Visit the right, with the expressionSink set. SelectScope s = expressionSink; expressionSink = new SelectScope(); expressionSink.LeftProduction = SqlGatherProducedAliases.Gather(join.Left); join.Right = this.VisitSource(join.Right); // Were liftable expressions found? SqlSource newSource = join; foreach (List cols in expressionSink.Lifted) { newSource = PushSourceDown(newSource, cols); } expressionSink = s; return newSource; } return base.VisitJoin(join); } [SuppressMessage("Microsoft.Performance", "CA1822:MarkMembersAsStatic", Justification="Unknown reason.")] private SqlSource PushSourceDown(SqlSource sqlSource, List cols) { SqlSelect ns = new SqlSelect(new SqlNop(cols[0].ClrType, cols[0].SqlType, sqlSource.SourceExpression), sqlSource, sqlSource.SourceExpression); ns.Row.Columns.AddRange(cols); return new SqlAlias(ns); } } } } // 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 { /// /// Find projection expressions on the right side of CROSS APPLY that do not /// depend exclusively on right side productions and move them outside of the /// CROSS APPLY by enclosing the CROSS APPLY with a new source. /// class SqlLiftIndependentRowExpressions { internal static SqlNode Lift(SqlNode node) { ColumnLifter cl = new ColumnLifter(); node = cl.Visit(node); return node; } private class ColumnLifter : SqlVisitor { SelectScope expressionSink; SqlAggregateChecker aggregateChecker; internal ColumnLifter() { this.aggregateChecker = new SqlAggregateChecker(); } class SelectScope { // Stack of projections lifted from the right to be pushed on the left. internal Stack> Lifted = new Stack
>(); internal IEnumerable
LeftProduction; internal HashSet ReferencedExpressions = new HashSet (); } internal override SqlSelect VisitSelect(SqlSelect select) { SelectScope s = expressionSink; // Don't lift through a TOP. if (select.Top != null) { expressionSink = null; } // Don't lift through a GROUP BY (or implicit GROUP BY). if (select.GroupBy.Count > 0 || this.aggregateChecker.HasAggregates(select)) { expressionSink = null; } // Don't lift through DISTINCT if (select.IsDistinct) { expressionSink = null; } if (expressionSink != null) { List keep = new List (); List lift = new List (); foreach (SqlColumn sc in select.Row.Columns) { bool referencesLeftsideAliases = SqlAliasesReferenced.ReferencesAny(sc.Expression, expressionSink.LeftProduction); bool isLockedExpression = expressionSink.ReferencedExpressions.Contains(sc); if (referencesLeftsideAliases && !isLockedExpression) { lift.Add(sc); } else { keep.Add(sc); } } select.Row.Columns.Clear(); select.Row.Columns.AddRange(keep); if (lift.Count > 0) { expressionSink.Lifted.Push(lift); } } SqlSelect sel = base.VisitSelect(select); expressionSink = s; return sel; } internal override SqlExpression VisitColumnRef(SqlColumnRef cref) { if (expressionSink!=null) { expressionSink.ReferencedExpressions.Add(cref.Column); } return cref; } internal override SqlSource VisitJoin(SqlJoin join) { if (join.JoinType == SqlJoinType.CrossApply) { // Visit the left side as usual. join.Left = this.VisitSource(join.Left); // Visit the condition as usual. join.Condition = this.VisitExpression(join.Condition); // Visit the right, with the expressionSink set. SelectScope s = expressionSink; expressionSink = new SelectScope(); expressionSink.LeftProduction = SqlGatherProducedAliases.Gather(join.Left); join.Right = this.VisitSource(join.Right); // Were liftable expressions found? SqlSource newSource = join; foreach (List cols in expressionSink.Lifted) { newSource = PushSourceDown(newSource, cols); } expressionSink = s; return newSource; } return base.VisitJoin(join); } [SuppressMessage("Microsoft.Performance", "CA1822:MarkMembersAsStatic", Justification="Unknown reason.")] private SqlSource PushSourceDown(SqlSource sqlSource, List cols) { SqlSelect ns = new SqlSelect(new SqlNop(cols[0].ClrType, cols[0].SqlType, sqlSource.SourceExpression), sqlSource, sqlSource.SourceExpression); ns.Row.Columns.AddRange(cols); return new SqlAlias(ns); } } } } // 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
- CodeDOMProvider.cs
- DataControlFieldHeaderCell.cs
- CatalogZoneBase.cs
- TraceSource.cs
- NativeCppClassAttribute.cs
- newinstructionaction.cs
- ButtonFieldBase.cs
- InfoCardRSAPKCS1KeyExchangeDeformatter.cs
- ApplicationException.cs
- InputBuffer.cs
- DataObjectMethodAttribute.cs
- CancellationScope.cs
- CharacterMetricsDictionary.cs
- ToolStripButton.cs
- SqlErrorCollection.cs
- XmlSchemaSet.cs
- TimeSpan.cs
- TextAdaptor.cs
- MatchAttribute.cs
- FixedTextContainer.cs
- CodeExpressionStatement.cs
- RegisteredHiddenField.cs
- ThreadPool.cs
- HWStack.cs
- ExcludePathInfo.cs
- MachineKeyConverter.cs
- FileClassifier.cs
- _Rfc2616CacheValidators.cs
- FileDialog_Vista_Interop.cs
- SqlServices.cs
- BasePropertyDescriptor.cs
- CodeAttributeDeclaration.cs
- WebPartConnectVerb.cs
- RSAOAEPKeyExchangeDeformatter.cs
- ModelChangedEventArgsImpl.cs
- HybridWebProxyFinder.cs
- DummyDataSource.cs
- IdentityModelDictionary.cs
- FontStyleConverter.cs
- basemetadatamappingvisitor.cs
- Span.cs
- PrinterUnitConvert.cs
- ExtensionCollection.cs
- XMLSyntaxException.cs
- Attributes.cs
- AppDomainFactory.cs
- SQLBinary.cs
- Run.cs
- WebSysDisplayNameAttribute.cs
- TableLayoutPanelCodeDomSerializer.cs
- StreamSecurityUpgradeInitiator.cs
- PenThreadWorker.cs
- BasicExpressionVisitor.cs
- ProxyWebPart.cs
- EventBookmark.cs
- SrgsRuleRef.cs
- Component.cs
- DES.cs
- exports.cs
- LinkDesigner.cs
- GridViewRow.cs
- VolatileEnlistmentMultiplexing.cs
- PersistenceProvider.cs
- MimeTypePropertyAttribute.cs
- ScaleTransform3D.cs
- StaticSiteMapProvider.cs
- ClientRolePrincipal.cs
- _SafeNetHandles.cs
- PrePrepareMethodAttribute.cs
- XmlWrappingReader.cs
- RealProxy.cs
- AssemblyEvidenceFactory.cs
- AsyncMethodInvoker.cs
- RTLAwareMessageBox.cs
- Debug.cs
- WebHttpDispatchOperationSelector.cs
- ProtocolReflector.cs
- ApplicationInterop.cs
- FactoryGenerator.cs
- SemanticAnalyzer.cs
- RelAssertionDirectKeyIdentifierClause.cs
- HandledMouseEvent.cs
- Trace.cs
- TriggerActionCollection.cs
- SelectedGridItemChangedEvent.cs
- RouteTable.cs
- XPathSingletonIterator.cs
- ConnectionStringSettingsCollection.cs
- NavigationEventArgs.cs
- OdbcStatementHandle.cs
- WebPartZone.cs
- GeneralTransformCollection.cs
- IFlowDocumentViewer.cs
- LifetimeServices.cs
- HScrollBar.cs
- NameObjectCollectionBase.cs
- DataBinder.cs
- TextRangeEditTables.cs
- BookmarkTable.cs
- DataGridViewAccessibleObject.cs