NHibernate on Azure?

Question

Has anyone tried NHibernate on Azure? Is there conflicts with the medium trust or SQL integration?

Answer 1

The NHibernate test suite fully works on SQL Azure. You should be able to simply change your connection string to your SQL Azure connection string.

There shouldn't be any hangups in running using NHibernate from a Web or Worker role.

Answer 2

I have tried NHibernate 3 inside Azure Web Role which talks to Azure SQL. I did not have any problems, runs pretty fine.

I am using NFluent for configuration. I can create the database directly from the mapping configuration.

There was only one issue with the HiLo generator. If you are interested in details, I have post it on my blog.

This issue comes from the fact that Azure SQL is not completely compatible with SQL Server. The limitations of Azure SQL are described here. But that was just a minor issue.

Answer 3

Not sure about NHibernate, but Azure now allows full trust applications.

Hosting Web and Worker Roles Under Full Trust