public static IEnumerable <DatabaseViewModel> FromDataReader(IDataReader rdr)
{
while (rdr.Read())
{
var rv = new DatabaseViewModel
{
db_name = rdr["db_name"].ToString(),
IsSelected = true,
owner_name = rdr["owner_name"].ToString(),
quote_name = rdr["quote_name"].ToString(),
state_desc = rdr["state_desc"].ToString()
};
yield return(rv);
}
}
public static async Task <IEnumerable <DatabaseViewModel> > GetDatabases(SqlConnectionViewModel vm)
{
using (var cn = new SqlConnection(vm.ConnectionString()))
{
await cn.OpenAsync();
using (var cmd = cn.CreateCommand())
{
cmd.CommandText = getDBsQuery;
cmd.CommandType = CommandType.Text;
using (var rdr = await cmd.ExecuteReaderAsync())
{
return(DatabaseViewModel.FromDataReader(rdr).ToArray());
}
}
}
}
