How to specify table mappings with Subsonic

I don't think SimpleRepository will work well in this situation. You might find the LinqTemplates work well to query the data. Subsonic also does a good job handling sprocs and makes it easy to return datasets, or typed results if you have classes that match the structure of your sproc resultsets.

For example, you can map the results of a sproc to a List like this:

StoredProcedure sproc = _db.GetProductList();
List<Product> products = sproc.ExecuteTypedList<Product>();

All matching columns that can be populated will be.

You can use CodingHorror as Adam mentions and from that you can also use ToList or ExecuteTypedList() to get your typed list back.