/// <summary>
/// Gets the users (specifically for Oracle)
/// </summary>
public IList <DatabaseUser> AllUsers()
{
var list = new List <DatabaseUser>();
DataTable dt = _sr.Users();
//sql
string key = "user_name";
//oracle
if (!dt.Columns.Contains(key))
{
key = "name";
}
//mysql
if (!dt.Columns.Contains(key))
{
key = "username";
}
foreach (DataRow row in dt.Rows)
{
var u = new DatabaseUser();
u.Name = row[key].ToString();
list.Add(u);
}
DatabaseSchema.Users.Clear();
DatabaseSchema.Users.AddRange(list);
return(list);
}
/// <summary>
/// Gets the users (specifically for Oracle)
/// </summary>
public IList <DatabaseUser> AllUsers()
{
RaiseReadingProgress(SchemaObjectType.Users);
DataTable dt = _schemaReader.Users();
ReaderEventArgs.RaiseEvent(ReaderProgress, this, ProgressType.Processing, SchemaObjectType.Users);
var list = UserConverter.Convert(dt);
DatabaseSchema.Users.Clear();
DatabaseSchema.Users.AddRange(list);
return(list);
}
