Hi, I am working on a local runners site. That means I record a lot of race details. I think the best way to convert the old style of a flat file with a separate row for every single result is to create an umbraco doctype instance for each race and then hang a list of results off that. I'm sure you'll agree. So at first I created a PetaPoco table of results with ids of race event, member runner and so on. This is unsatisfactory for various reasons:

1) Sooner or later, when querying the data you get a ysod telling you that you have more than one DataReader open. I solved that with the rather evil MultipleResultsetsActive as I didn't manage to cure it by programmatic means. 2) It will be easier for my users (I think) if I can use an Umbraco doctype for result. I can make it faster with Examine Indexes and I can make a nice dashboard for entered results.

In the middle of shifting over my data to the new doctype, I suddenly realise that a race result doesn't have a name. It is connected to a runner and a race but it makes very little sense for what is essentially just a table row to have a name of its own.

Any suggestions how I could either make better use of the PetaPoco thing when querying the database and also make a nice dashboard Or if I can create a doctype instance with no name?