To automatically results from a stored procedure, simply create a class to place the results.  Alternatively a dictionary can be returned.

 

IDataHelper db = DataHelper.SessionFactory();

List<Person> records = db.LoadFromSproc<Person>("TopTenPeople");