private void LoadTables(Database d, IDatabaseDictionary databaseDictionary)
{
foreach (Table t in d.Tables)
{
try
{
if (!t.IsSystemObject)
{
databaseDictionary.Add(d, t, connectionInfo);
}
}
catch (Exception ex)
{
log.Error("Error loading table " + t.Name + " from db " + d.Name, ex);
}
}
}
private void LoadViews(Database d, IDatabaseDictionary databaseDictionary)
{
foreach (View v in d.Views)
{
try
{
if (!v.IsSystemObject)
{
databaseDictionary.Add(d, v, connectionInfo);
}
}
catch (Exception ex)
{
log.Error("Error loading view " + v.Name + " from db " + d.Name, ex);
}
}
}
private void LoadStoredProcs(Database d, IDatabaseDictionary databaseDictionary)
{
foreach (StoredProcedure p in d.StoredProcedures)
{
try
{
if (!p.IsSystemObject)
{
databaseDictionary.Add(d, p, connectionInfo);
}
}
catch (Exception ex)
{
log.Error("Error loading procedure " + p.Name + " from db " + d.Name, ex);
}
}
}
private void LoadFunctions(Database d, IDatabaseDictionary databaseDictionary)
{
foreach (UserDefinedFunction f in d.UserDefinedFunctions)
{
try
{
if (!f.IsSystemObject)
{
databaseDictionary.Add(d, f, connectionInfo);
}
}
catch (Exception ex)
{
log.Error("Error loading view " + f.Name + " from db " + d.Name, ex);
}
}
}