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