public virtual ProjectionExpression AddOuterJoinTest(ProjectionExpression proj)
{
var test = this.GetOuterJoinTest(proj.Select);
var select = proj.Select;
ColumnExpression testCol = null;
// look to see if test expression exists in columns already
foreach (var col in select.Columns)
{
if (test.Equals(col.Expression))
{
var colType = this.TypeSystem.GetColumnType(test.Type);
testCol = new ColumnExpression(test.Type, colType, select.Alias, col.Name, null);
break;
}
}
if (testCol == null)
{
// add expression to projection
testCol = test as ColumnExpression;
string colName = (testCol != null) ? testCol.Name : "Test";
colName = proj.Select.Columns.GetAvailableColumnName(colName);
var colType = this.TypeSystem.GetColumnType(test.Type);
select = select.AddColumn(new ColumnDeclaration(colName, null, test, colType));
testCol = new ColumnExpression(test.Type, colType, select.Alias, colName, null);
}
var newProjector = new OuterJoinedExpression(testCol, proj.Projector);
return(new ProjectionExpression(select, newProjector, proj.Aggregator));
}
protected virtual Expression VisitOuterJoined(OuterJoinedExpression outer)
{
var test = this.Visit(outer.Test);
var expression = this.Visit(outer.Expression);
return(this.UpdateOuterJoined(outer, test, expression));
}
protected OuterJoinedExpression UpdateOuterJoined(OuterJoinedExpression outer, Expression test, Expression expression)
{
if (test != outer.Test || expression != outer.Expression)
{
return(new OuterJoinedExpression(test, expression));
}
return(outer);
}
protected virtual Expression VisitOuterJoined(OuterJoinedExpression outer)
{
this.Write("Outer(");
this.WriteLine(Indentation.Inner);
this.Visit(outer.Test);
this.Write(", ");
this.WriteLine(Indentation.Same);
this.Visit(outer.Expression);
this.WriteLine(Indentation.Outer);
this.Write(")");
return(outer);
}
public static ProjectionExpression AddOuterJoinTest(this ProjectionExpression proj, QueryLanguage language, Expression expression)
{
string colName = proj.Select.Columns.GetAvailableColumnName("Test");
var colType = language.TypeSystem.GetColumnType(expression.Type);
SelectExpression newSource = proj.Select.AddColumn(new ColumnDeclaration(colName, null, expression, colType));
Expression newProjector =
new OuterJoinedExpression(
new ColumnExpression(expression.Type, colType, newSource.Alias, colName, null),
proj.Projector
);
return(new ProjectionExpression(newSource, newProjector, proj.Aggregator));
}
protected Expression Compare(BinaryExpression bop)
{
var e1 = this.SkipConvert(bop.Left);
var e2 = this.SkipConvert(bop.Right);
OuterJoinedExpression oj1 = e1 as OuterJoinedExpression;
OuterJoinedExpression oj2 = e2 as OuterJoinedExpression;
EntityExpression entity1 = oj1 != null ? oj1.Expression as EntityExpression : e1 as EntityExpression;
EntityExpression entity2 = oj2 != null ? oj2.Expression as EntityExpression : e2 as EntityExpression;
bool negate = bop.NodeType == ExpressionType.NotEqual;
// check for outer-joined entity comparing against null. These are special because outer joins have
// a test expression specifically desgined to be tested against null to determine if the joined side exists.
if (oj1 != null && e2.NodeType == ExpressionType.Constant && ((ConstantExpression)e2).Value == null)
{
return(MakeIsNull(oj1.Test, negate));
}
else if (oj2 != null && e1.NodeType == ExpressionType.Constant && ((ConstantExpression)e1).Value == null)
{
return(MakeIsNull(oj2.Test, negate));
}
// if either side is an entity construction expression then compare using its primary key members
if (entity1 != null)
{
return(this.MakePredicate(e1, e2, this.mapping.GetPrimaryKeyMembers(entity1.Entity), negate));
}
else if (entity2 != null)
{
return(this.MakePredicate(e1, e2, this.mapping.GetPrimaryKeyMembers(entity2.Entity), negate));
}
// check for comparison of user constructed type projections
var dm1 = this.GetDefinedMembers(e1);
var dm2 = this.GetDefinedMembers(e2);
if (dm1 == null && dm2 == null)
{
// neither are constructed types
return(bop);
}
if (dm1 != null && dm2 != null)
{
// both are constructed types, so they'd better have the same members declared
HashSet <string> names1 = new HashSet <string>(dm1.Select(m => m.Name));
HashSet <string> names2 = new HashSet <string>(dm2.Select(m => m.Name));
if (names1.IsSubsetOf(names2) && names2.IsSubsetOf(names1))
{
return(MakePredicate(e1, e2, dm1, negate));
}
}
else if (dm1 != null)
{
return(MakePredicate(e1, e2, dm1, negate));
}
else if (dm2 != null)
{
return(MakePredicate(e1, e2, dm2, negate));
}
throw new InvalidOperationException("Cannot compare two constructed types with different sets of members assigned.");
}