emilcicos

user stats

Member SinceNovember 5, 2012
Last VisitJuly 30, 2014

Contact

developer for

Entity Framework

emilcicos

personal statement

No personal statement has been written.

activity stream

July 28, 2014 - Entity Framework: Commented work item: [Perf] Regression between 6.1 and 6.1.1

July 28, 2014 - Entity Framework: Pushed f77a6cb3cbcb59cfd2e6e1182da1425a0736797c, CodePlex 2369: FilterOpRules.Rule_FilterOverLeftOuterJoin is deferred until after the NullSemantics and JoinElimination phases to allow the expansion of the filter predicate to account for nulls (required by the Predicate.PreservesNulls), and respectively to eliminate duplicate left out joins before promoting to inner join (necessary due to a limitation in the JoinElimination phase). ApplyOpRules.Rule_OuterApplyOverFilter needs to be deferred as well. In case of one to one relationships when something is queried from the principal via the navigation property on the dependent, the interdependency between these two transformation rules results in an expression tree with unnecessary joins that cannot be eliminated because of another limitation in the JoinElimination phase (see case b. described in the comments on JoinGraph.TryTurnLeftOuterJoinsIntoInnerJoins). The fix defers ApplyOpRules.Rule_OuterApplyOverFilter by skipping execution when PlanCompiler.DeferredTransformations flag is true. The rule is executed during the PostJoinElimination transformations phase.

July 25, 2014 - Entity Framework: Commented work item: Outer apply and duplicate left outer joins in query. Also the SQL query seems nicer if generated with EF5.

July 25, 2014 - Entity Framework: Commented work item: Outer apply and duplicate left outer joins in query. Also the SQL query seems nicer if generated with EF5.

July 25, 2014 - Entity Framework: Modified work item: Outer apply and duplicate left outer joins in query. Also the SQL query seems nicer if generated with EF5.

July 25, 2014 - Entity Framework: Commented work item: Outer apply and duplicate left outer joins in query.

July 25, 2014 - Entity Framework: Commented work item: Outer apply and duplicate left outer joins in query.

July 25, 2014 - Entity Framework: Commented work item: Regression in 6.1.1 wrong left join instead of inner join

July 25, 2014 - Entity Framework: Modified work item: Projection With Null Check Causing Too Many Joins

July 25, 2014 - Entity Framework: Commented work item: Projection With Null Check Causing Too Many Joins

projects i'm following

No projects being followed.

forks

No forks.