public MetaSprocSqlDependency GetMetaSprocSqlDependencyForOneSproc(List <MetaSqlDependency> dependenciesForSproc,
string sprocName)
{
PredicateFunctions predicateFunctions = new PredicateFunctions();
string sprocTypeString = Constants.MetaSqlOrSprocDependencyConstants.STORED_PROCEDURE_TYPE;
string userTableTypeString = Constants.MetaSqlOrSprocDependencyConstants.USER_TABLE_TYPE;
List.MetaSqlDependency sprocTypeDependencies = new List.MetaSqlDependency();
List.MetaSqlDependency userTableTypeDependencies = new List.MetaSqlDependency();
Dictionary <string, List <MetaSqlDependency> > listOfUserTableToColumnsReferenced =
new Dictionary <string, List <MetaSqlDependency> >();
List <string> distinctUserTablesList = new List <string>();
predicateFunctions.ReferencedTypeHolder = sprocTypeString;
sprocTypeDependencies.AddRange(dependenciesForSproc.FindAll(predicateFunctions.FindMetaSqlDependenciesByReferencedType));
predicateFunctions.ReferencedTypeHolder = userTableTypeString;
userTableTypeDependencies.AddRange(dependenciesForSproc.FindAll(predicateFunctions.FindMetaSqlDependenciesByReferencedType));
if (userTableTypeDependencies.Count > 0)
{
distinctUserTablesList = GetDistinctUserTableList(userTableTypeDependencies);
foreach (string distinctUserTableName in distinctUserTablesList)
{
List <MetaSqlDependency> columnsReferenced = new List <MetaSqlDependency>();
predicateFunctions.ReferencedObjectHolder = distinctUserTableName;
columnsReferenced.AddRange(userTableTypeDependencies.FindAll(predicateFunctions.FindMetaSqlDependenciesByReferencedObject));
if (columnsReferenced.Count > 0)
{
listOfUserTableToColumnsReferenced.Add(distinctUserTableName, columnsReferenced);
}
}
}
MetaSprocSqlDependency metaSprocSqlDependency =
new MetaSprocSqlDependency(sprocName,
sprocTypeDependencies,
userTableTypeDependencies,
listOfUserTableToColumnsReferenced,
distinctUserTablesList);
return(metaSprocSqlDependency);
}
