retrieving data with stored procedure

Posts   
 
    
costab
User
Posts: 36
Joined: 21-Aug-2010
# Posted on: 20-Apr-2011 07:16:01   

I am using nhibernate as the target framework.

I am curious why doesn't llblgenpro support retrieving data using stored procedures? In the end stored procedure that return resultsets seem no different than views returning data.

Thank you

Walaa avatar
Walaa
Support Team
Posts: 14995
Joined: 21-Aug-2005
# Posted on: 20-Apr-2011 08:20:12   
costab
User
Posts: 36
Joined: 21-Aug-2010
# Posted on: 20-Apr-2011 09:03:25   

In the thread you posted your colleague said:

We didn't add the stored proc calls to NHibernate as we couldn't find proper constructs for NHibernate which make calling procs easy, i.e.: it looks like they're not natively supported in nhibernate land.

What does qualify as a "proper construct"?

Otis avatar
Otis
LLBLGen Pro Team
Posts: 39908
Joined: 17-Aug-2003
# Posted on: 20-Apr-2011 10:01:47   

code structure, solid patterns etc. I.o.w.: it was unclear, undocumented, what to do to call procs in a variety of ways. It is likely possible somehow, but we need a solid, documented way to do so. As support for procs across the various dialects is not really consistent in Nhibernate, we left it out for now.

Frans Bouma | Lead developer LLBLGen Pro