assoc property

@override List<Map<String, String?>> get assoc

Returns all rows as a list of associative arrays. This is the most common way to access query results, providing column names as map keys for easy data access. Example:

var rows = result.assoc;
for (var row in rows) {
  print('Name: ${row['name']}, Email: ${row['email']}');
}

Implementation

@override
List<Map<String, String?>> get assoc {
  var list = <Map<String, String?>>[];

  for (var row in rows) {
    var map = <String, String?>{};
    for (var i = 0; i < numFields; i++) {
      map[resultSet.columnNames[i]] = row[i]?.toString();
    }
    list.add(map);
  }

  return list;
}