New to NHibernate and evaluting at the same time.

Working of Legacy Database and wondering about suitability.
We would like to give many of our stored procedure the "chop",but also there will be cases when we want to use them.

Can somebody give a quick overview of what they cannot do?

Can they handle stored Procedures with Temporary Table and Dinamic sql inside them?

etc.....

Thanks in advance

It doesn't matter what the Stored Procedure does, NHibernate will just execute it for you.

You're not really using NHibernate when you're running stored procedures. You just use the connection that NHibernate has got. All I do is this (where 'Session' is a property to get my ISession object)

IDbConnection connection = Session.Connection;
IDbCommand command = connection.CreateCommand();
Session.Transaction.Enlist(command);
command.CommandType = CommandType.StoredProcedure;
command.CommandText = "spDeleteSomething";
command.ExecuteNonQuery();

thank you very much that is what I wanted to know

Is there a database neutral way to get a dataset back like this?