Code:
/ 4.0 / 4.0 / untmp / DEVDIV_TFS / Dev10 / Releases / RTMRel / ndp / fx / src / DLinq / Dlinq / SqlClient / Query / SqlLiftWhereClauses.cs / 1305376 / SqlLiftWhereClauses.cs
using System;
using System.Collections.Generic;
using System.Text;
using System.Data.Linq.Mapping;
using System.Data.Linq.Provider;
namespace System.Data.Linq.SqlClient {
///
/// Hoist WHERE clauses as close to the root as possible.
///
class SqlLiftWhereClauses {
internal static SqlNode Lift(SqlNode node, TypeSystemProvider typeProvider, MetaModel model) {
return new Lifter(typeProvider, model).Visit(node);
}
class Lifter : SqlVisitor {
private class Scope {
internal Scope Parent;
internal SqlExpression Where;
internal Scope(SqlExpression where, Scope parent) {
this.Where = where;
this.Parent = parent;
}
};
Scope current;
SqlFactory sql;
SqlAggregateChecker aggregateChecker;
SqlRowNumberChecker rowNumberChecker;
internal Lifter(TypeSystemProvider typeProvider, MetaModel model) {
this.sql = new SqlFactory(typeProvider, model);
this.aggregateChecker = new SqlAggregateChecker();
this.rowNumberChecker = new SqlRowNumberChecker();
}
internal override SqlSelect VisitSelect(SqlSelect select) {
Scope save = this.current;
this.current = new Scope(select.Where, this.current);
SqlSelect result = base.VisitSelect(select);
bool stopHoisting =
select.IsDistinct ||
select.GroupBy.Count > 0 ||
this.aggregateChecker.HasAggregates(select) ||
select.Top != null ||
this.rowNumberChecker.HasRowNumber(select);
// Shift as much of the current WHERE to the parent as possible.
if (this.current != null) {
if (this.current.Parent != null && !stopHoisting) {
this.current.Parent.Where = sql.AndAccumulate(this.current.Parent.Where, this.current.Where);
this.current.Where = null;
}
select.Where = this.current.Where;
}
this.current = save;
return result;
}
internal override SqlNode VisitUnion(SqlUnion su) {
Scope save = this.current;
this.current = null;
SqlNode result = base.VisitUnion(su);
this.current = save;
return result;
}
internal override SqlSource VisitJoin(SqlJoin join) {
// block where clauses from being lifted out of the cardinality-dependent
// side of an outer join.
Scope save = this.current;
try {
switch (join.JoinType) {
case SqlJoinType.Cross:
case SqlJoinType.CrossApply:
case SqlJoinType.Inner:
return base.VisitJoin(join);
case SqlJoinType.LeftOuter:
case SqlJoinType.OuterApply: {
join.Left = this.VisitSource(join.Left);
this.current = null;
join.Right = this.VisitSource(join.Right);
join.Condition = this.VisitExpression(join.Condition);
return join;
}
default:
this.current = null;
return base.VisitJoin(join);
}
}
finally {
this.current = save;
}
}
internal override SqlExpression VisitSubSelect(SqlSubSelect ss) {
// block where clauses from being lifted out of a sub-query
Scope save = this.current;
this.current = null;
SqlExpression result = base.VisitSubSelect(ss);
this.current = save;
return result;
}
internal override SqlExpression VisitClientQuery(SqlClientQuery cq) {
// block where clauses from being lifted out of a client-materialized sub-query
Scope save = this.current;
this.current = null;
SqlExpression result = base.VisitClientQuery(cq);
this.current = save;
return result;
}
}
}
}
// 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
- SizeAnimation.cs
- CodeTypeOfExpression.cs
- HasCopySemanticsAttribute.cs
- SpeakProgressEventArgs.cs
- XsdBuildProvider.cs
- JsonMessageEncoderFactory.cs
- BuildProviderCollection.cs
- Expressions.cs
- StringDictionary.cs
- HTTP_SERVICE_CONFIG_URLACL_KEY.cs
- AuthenticationModulesSection.cs
- DictionaryMarkupSerializer.cs
- ContainerUtilities.cs
- XmlDocumentFragment.cs
- EntityDataSourceDataSelection.cs
- TdsParser.cs
- documentsequencetextcontainer.cs
- ExtensionWindow.cs
- SqlXml.cs
- AsyncCompletedEventArgs.cs
- CodeVariableReferenceExpression.cs
- DateTimeConverter2.cs
- WpfSharedBamlSchemaContext.cs
- MethodBody.cs
- DbConnectionHelper.cs
- CodeSnippetStatement.cs
- CodeParameterDeclarationExpressionCollection.cs
- AttributeUsageAttribute.cs
- DllHostedComPlusServiceHost.cs
- PolyLineSegmentFigureLogic.cs
- AttributeCollection.cs
- DeferredReference.cs
- pingexception.cs
- mediaclock.cs
- PeerDefaultCustomResolverClient.cs
- GlyphInfoList.cs
- ContractNamespaceAttribute.cs
- TextTreeRootTextBlock.cs
- StaticFileHandler.cs
- ConfigurationManager.cs
- WebPartTransformerAttribute.cs
- DataViewSetting.cs
- linebase.cs
- RowSpanVector.cs
- UIElement3DAutomationPeer.cs
- EntityTemplateUserControl.cs
- NamedServiceModelExtensionCollectionElement.cs
- InternalConfirm.cs
- Gdiplus.cs
- TrackingProfile.cs
- FunctionDetailsReader.cs
- SystemWebSectionGroup.cs
- DesignTimeXamlWriter.cs
- DPTypeDescriptorContext.cs
- FileLoadException.cs
- GridViewAutomationPeer.cs
- TriggerBase.cs
- UdpDuplexChannel.cs
- ZoneMembershipCondition.cs
- FastPropertyAccessor.cs
- SaveFileDialog.cs
- MappingSource.cs
- ListenerTraceUtility.cs
- HttpHandler.cs
- SystemDropShadowChrome.cs
- DbParameterHelper.cs
- SemaphoreSecurity.cs
- InvokeProviderWrapper.cs
- ListenerElementsCollection.cs
- ImageListImageEditor.cs
- DataGridColumnHeadersPresenterAutomationPeer.cs
- DataGridViewCellValidatingEventArgs.cs
- CompilerParameters.cs
- GcHandle.cs
- ExpressionBuilderContext.cs
- PropertyValueChangedEvent.cs
- DiscreteKeyFrames.cs
- XmlExceptionHelper.cs
- TypeContext.cs
- ExpressionWriter.cs
- safesecurityhelperavalon.cs
- FixedNode.cs
- HtmlTableRow.cs
- XmlSchemaComplexContentExtension.cs
- ProjectionCamera.cs
- MsmqIntegrationBindingElement.cs
- SimpleLine.cs
- PrintDialog.cs
- EmptyControlCollection.cs
- ColorConverter.cs
- SqlConnectionPoolGroupProviderInfo.cs
- IISUnsafeMethods.cs
- CodeMemberProperty.cs
- UnitySerializationHolder.cs
- SqlBuilder.cs
- RegisteredScript.cs
- Comparer.cs
- SafeBitVector32.cs
- ThemeDirectoryCompiler.cs
- UnsafeNativeMethodsTablet.cs