protected void GenerateOwnershipJoinExpression(List <Field> related, StringBuilder sb, FieldEntityAliasDictionary aliases)
{
Field previous = null;
string prevAlias = null;
// skip the first item when building the join expression for the security policy because the type we are building the policy for
// will be automatically included as a set of items to filter, and explicitly including it in the policy causes an indefinitely recursive
// security policy to be created (which doesn't work)
foreach (var field in related.Skip(1))
{
var alias = aliases.CreateAliasForTypeByField(field);
if (previous == null)
{
sb.AppendLine($"\t{field.Type.Name} as {alias}");
}
else
{
sb.AppendLine($"\tINNER JOIN {field.Type.Name} as {alias} on {prevAlias}.{previous.Name} = {alias}.{previous.ReferencesTypeField.Name}");
}
prevAlias = alias;
previous = field;
}
}
protected void GenerateOwnershipJoinExpression(List <Field> related, StringBuilder sb, FieldEntityAliasDictionary aliases)
{
Field previous = null;
string prevAlias = null;
foreach (var field in related)
{
var alias = aliases.CreateAliasForTypeByField(field);
if (previous == null)
{
sb.AppendLine($"\t{field.Type.Name} as {alias}");
}
else
{
sb.AppendLine($"\tINNER JOIN {field.Type.Name} as {alias} on {prevAlias}.{previous.Name} = {alias}.{previous.ReferencesTypeField.Name}");
}
prevAlias = alias;
previous = field;
}
}