views:

39

answers:

1

I can add a stored procedure to a dataset and handle the data manipulation.

Wanted to know if there are any other ways through which on the basis of stored procedure result sets, I can handle data in the BAL, like dynamically generating business objects or something else?

+3  A: 

You're looking for an ORM (Object-relational mapping) engine, such as Entity Framework or NHibernate.

SLaks
^^ but doesn't an ORM engine directly interacts with the data, I mean ain't it creates the queries on its own?
Dienekes
@Dienekes: Most ORMs, including both EF and NHibernate, can be configured to use stored procedures instead.
SLaks
^^ Cool, will try these then, thanks..
Dienekes