I finally came around to implement the IHydratable interface for this problem. I thought to have solved the problem as suggested but immediately hit a new obstacle.

When implementing IHydratable you must implement the Fill method and the KeyID property. I found it hard to find any documentation on what the KeyID exactly meant. In the examples that I could find it returned the primary key value of the current record as an integer. I found this hard to believe as by far all tables have a single primary key of type integer. I found a blog on dotnetnuke saying indeed the KeyID is the primary key of the current record. I'm sorry to say but I think this is a mayor design flaw. By far all tables have a single primary key column of type integer. Any suggestion to work around this limitation is greatly appreciated as I can only come up with ugly solutions like, concatenate multiple integers. But even this ugly workaround does not solve the problem of non integer primary keys.