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