private string GetAllTableRefernce(string istrdbName, string istrSchemaName)
{
var RefernceHTML = "";
var tableReference = new List <TableFKDependency>();
if (istrSchemaName.IsNullOrEmpty())
{
using (var dbSqldocContext = new MsSqlDiaryContext(istrdbName))
{
tableReference = dbSqldocContext.GetTableFkReferences();
}
}
else
{
using (var dbSqldocContext = new MsSqlDiaryContext(istrdbName))
{
tableReference = dbSqldocContext.GetTableFkReferences(istrSchemaName);
}
}
tableReference.ForEach(x =>
{
RefernceHTML += x.fk_refe_table_name + "\t" + "[fontcolor=block, label=<" + "" +
">, color =block]";
});
return(RefernceHTML);
}
private string GetAllTableRefernce(string istrdbName, string istrSchemaName, List <string> alstOfSelectedTables)
{
var RefernceHTML = "";
var tableReference = new List <TableFKDependency>();
if (istrSchemaName.IsNullOrEmpty())
{
using (var dbSqldocContext = new MsSqlDiaryContext(istrdbName))
{
dbSqldocContext.GetTableFkReferences()
.ForEach(x =>
{
var result = x.fk_refe_table_name.IsNull() ? x.current_table_name : x.fk_refe_table_name;
if (alstOfSelectedTables.Any(argtable => result.Contains(argtable)))
{
//aTablePropertyInfo.fk_refe_table_name=aTablePropertyInfo.fk_refe_table_name ??"";
//aTablePropertyInfo.fk_refe_table_name = aTablePropertyInfo.fk_refe_table_name.Replace(".", "_");
//aTablePropertyInfo.current_table_name = aTablePropertyInfo.current_table_name ?? "";
//aTablePropertyInfo.current_table_name = aTablePropertyInfo.current_table_name.Replace(".", "_");
tableReference.Add(x);
}
}
);
}
}
else
{
using (var dbSqldocContext = new MsSqlDiaryContext(istrdbName))
{
dbSqldocContext.GetTableFkReferences(istrSchemaName).Where(x => x.fk_refe_table_name.IsNotNull())
.ForEach(x =>
{
var result = x.fk_refe_table_name.IsNull() ? x.current_table_name : x.fk_refe_table_name;
if (alstOfSelectedTables.Any(argtable => result.Contains(argtable)))
{
//aTablePropertyInfo.fk_refe_table_name = aTablePropertyInfo.fk_refe_table_name ?? "";
//aTablePropertyInfo.fk_refe_table_name = aTablePropertyInfo.fk_refe_table_name.Replace(".", "_");
//aTablePropertyInfo.current_table_name = aTablePropertyInfo.current_table_name ?? "";
//aTablePropertyInfo.current_table_name = aTablePropertyInfo.current_table_name.Replace(".", "_");
tableReference.Add(x);
}
}
);
}
}
tableReference.ForEach(x =>
{
RefernceHTML += x.fk_refe_table_name + "\t" + "[fontcolor=block, label=<" + "" +
">, color =block]";
});
return(RefernceHTML);
}
