Mac Geekery

The two database articles are very interesting, but they seem to indicate that CodeData can only be used for ‘class referencing’; that is, where the code treats each record as a class instance. This is fine, and works for a large number of cases.

I am having some difficulty determining how I can use this in a different project: a baseball season schedule. I have a list of teams, a schedule of games with game number, date and time, location, home and visiting team, game status, and scores. Game status may be one of Scheduled, Played (scores are in), Rain-Out, or Re-Scheduled. So far this it is not significantly different from the samples discussed, but there are some issues:

1. How do I force the games to be listed in a specific order?
2. How can I filter the list to show only the games where a specific team is at home?
3. How can I filter the list to show games where a specific team is involved?
4. I want to create another table, Standings, that counts the number of games played and awards points for wins, ties and losses; how can I do that and display the results?
5. I want to make a pass through the data and generate an HTML page that displays the schedule and the current results; how can I do that?
6. I also want to create a page (or a table on the same page) for the standings.

Can CodeData be used to execute generic queries and manipulate the contents of database tables without instantiating them as objects? I ahve been working with C#//ADO.Net for my “food on the table” work, and I have been very impressed with the DataSet/DataTable/DataColumn/DataRow classes )and of course the providers) — can CoreData do anythinf like that?