I have a program that is used in commercial environments. NHibernate has been extremely useful for any number of reasons, but some things are still a manual process, which I'm trying to change.

One of them is when we update the product and the DB changes structure. I would like to have the SQL scripts run from within NHibernate. Now, I'm trying to use the session.CreateSQLQuery command, but it is proving difficult. I can make it work, but in ways that I'm not happy with.

Surely there is a way to simply run an SQL command through NHibernate? I don't expect it to understand the DB behind it or do anything else tricky, I just want it to run the SQL and that's that.

I have scoured the forum, the internet and in a fit of manic passion started asking random people on the street. No luck.

Any help would be greatly appreciated.