NHibernate: Is MySql dialect mature and stable enough for use for large web app?

We are in the process of defining the architecture for new web app:

• ASP.NET MVC
• MySQL
• about 0.5 M unique visitors a day.
• .NET FW 4.0
• C# 4.0
• Search engine will开发者_运维知识库 probably be Sphinx (another option is Solr)
• Around 100 MB of new data in DB daily.

Is MySQL dialect for NH mature and stable enough for something like this ? Some things to be aware of when using NH with MySQL ?

I got the feeling that MSSQL is best supported with others little behind ? Do you have some references or personal experiences ? What are other options for .NET <-----> MySql integration ?

EDIT: I added a bounty on this question. I would like some real world examples/experiences of MySQL + NHibernate, open source projects, fallacies, etc.

---

Sure it is.

If something of MySQL dialect (or even nhibernate) doesnt fit right for you (that's rare, IMHO) you still can use hql to get more control about the generated queries, or even native sql

Also, NHibernate gives you another benefits, its stable and being used in a lot of big projects.