Stored Procedure Support?

Does the NHibernate Designer provide Stored Procedure Support? It would appear not, but i just wanted to double check. I use LightSpeed most of the time, but have one specific need where I may have to go with NHibernate based on a client's specific request. Stored Procedure support in the designer would be most helpful. Thanks!

Hi,

It does not at present, however we can look at adding it in the new year if this is a blocker for you. We already understand the infrastructure for getting details of stored procs since we have built that for LightSpeed, it would be making sure we generated the correct mapping content for those stored procedures.

What type of stored procedure support for you need?

• Run queries through sprocs (e.g. update, delete, etc)
• Just one-off style queries, for example for a report being generated
• Support for dragging on a stored procedure and having the designer generate the associated entity for the result OR connect to an existing entity that already matches the result type

Thanks,

John-Daniel

Thanks for the quick turnaround. Actually, all of the above. I use all of those features in LightSpeed, so similar implementations would be great. I think that I'll pick up a copy as it stands to support the effort of adding the features. :)

If i had to prioritize, I'd put them in this order, with 1 and 2 being equal.

1) Run queries through sprocs (e.g. update, delete, etc)

2) Support for dragging on a stored procedure and having the designer generate the associated entity for the result OR connect to an existing entity that already matches the result type

3) Just one-off style queries, for example for a report being generated

Thanks, I've put it on our backlog and we'll have a look at adding the support early in the new year.

Please poke us however if it's getting critical for you and we haven't yet added it though!

Cheers,

John-Daniel

If you'll implement support for stored procedures we'll most certainly buy the designer ;)

// Magnus