private static string GetFilter(SingleCrossReferenceFieldMetadata field, TableAliasCollection aliasCollection)
{
return string.Format(
CultureInfo.InvariantCulture,
"{0}.[Id] = @{1}Id",
aliasCollection.GetTableAlias(string.Empty, field.ReferencedProcess),
field.Name);
}
private static IEnumerable<IParameterBuilder> GetParameterBuilders(SingleCrossReferenceFieldMetadata field)
{
yield return new SingleCrossReferenceParameterBuilder(field.Name, string.Format("@{0}Id", field.Name));
}
private static IEnumerable<string> GetReferenceFieldJoins(string path, SingleCrossReferenceFieldMetadata field, TableAliasCollection aliasCollection)
{
yield return
string.Format(
CultureInfo.InvariantCulture,
@"INNER JOIN [dbo].[{0}] {1} ON {1}.[Id] = {2}.[{3}] AND {1}.[IsRemoved] = 0",
field.ReferencedProcess.Name,
aliasCollection.GetTableAlias(path + field.Name + ".", field.ReferencedProcess),
aliasCollection.GetTableAlias(path, field.DeclaringProcess),
field.Name);
}
