Hi

from what I understand is that in NHibernate you cannot return a dataset
from a stored procedure. I have a stored proc that does not have a mapping file associated, (its just for populating a treeview) and i just want to get the data back and populate my treeview.

whats the best way to do this ?

i can use an IDBcommand but I need a table back

thanks
Mox.

I don't understand why your title is: "ASP.net 2.0 get connection string" and why you choose the "ASP.NET" section...

NHibernate doesn't deal with Dataset and doesn't really support stored procedures. So you can either bind your entities to your controls (after converting them to a dataset if you want) or use a classic ADO.NET approach.

I'm using NHibernate for a lot of my objects and i understand you can call a stored procedure using part of the framework to create a command object for you but this only brings back a data reader. I am using this to populate the table as a temporary solution.

One of the solutions i thought of was to use ADO but get the NHibernate to create a connection for you using its configuration, but this returns a IDBConnection and you cant use that with ADO style calls (requires an SQLConnection)

I would like to get the NHibernate connection string back without opening a connection preferably using the nhibernate framework. If I cant has anyone got an example using the webConfigurationManager in asp.net 2.0 to read the nhibernate section as it sits outside of the appsettings and connection strings section.

Thanks
Mox.

Maybe I am mistaken, but i think that Microsoft Enterprise Library supports IDBConnection interface, give it a try...

Thanks Dalt,

I'll have a gander at that. :D