Fill business object from database by calling stored procedures?

Question

Hello, I have several stored procedures in my database, some of them have params, some have no params. I tried to fill a business object by calling the stored procedures, but failed so far. How could I do that dynamically? Later, I want to use this object as a datasource for a report...but thats the next step. The important facts are:

• different stored procs return different amount of columns
• stored procs can have params, but its not required

How could I achieve that?

Thanks :)

Answer 1

Your best bet is to scrap the business object code from that article on MSDN, download NHibernate, go through the Getting Started guide, and then walk through this blog post from Ayende.

The objects you create from NHibernate then can be used to bind to the Report Viewer on the MSDN article you referenced in your comment.

Good luck! :)