public IEnumerable <TSqlObject> GetObjects(IEnumerable <string> databaseSchemas, bool includeObjectOutsideSchemas = true)
{
return(SqlModel
.GetObjects(DacQueryScopes.UserDefined)
.Where(o => !o.IsDatabaseOptions() &&
(includeObjectOutsideSchemas &&
o.SchemaName().NullOrEmpty() ||
databaseSchemas.Contains(o.SchemaName(), StringComparer.InvariantCultureIgnoreCase))));
}
public TSqlObject GetUser(string user)
{
foreach (var obj in SqlModel.GetObjects(DacQueryScopes.UserDefined).Where(o => o.IsUser()))
{
if (obj.TryGetScript(out var script))
{
if (script.ToUpperInvariant().Contains($"[{user.ToUpperInvariant()}]"))
{
return(obj);
}
}
}
return(null);
}
