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); }