http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Chitty, You could, but then you are doing sharding on your own. http://ayende.com/4177/nhibernate-on-the-cloud-sql-azure#comment6http://ayende.com/4177/nhibernate-on-the-cloud-sql-azure#comment6Sat, 05 Sep 2009 22:45:51 GMTCowgar, Agreed, see my next post about NHibernate Shards http://ayende.com/4177/nhibernate-on-the-cloud-sql-azure#comment5http://ayende.com/4177/nhibernate-on-the-cloud-sql-azure#comment5Sat, 05 Sep 2009 22:45:42 GMTApologies if what I propose is deemed either a) naive, or b) ridiculous. I've only just starting looking into nHibernate so my comments come from those of a beginner. Anyway with that out of the way ... presumably you could have multiple nHibernate sessions configured and pick the relevant on at the start of the request. Of course it's not that simple and it would depend on the requirements of the site, but could be useful until M$ get their act together. Just a thought ... http://ayende.com/4177/nhibernate-on-the-cloud-sql-azure#comment4http://ayende.com/4177/nhibernate-on-the-cloud-sql-azure#comment4Sat, 05 Sep 2009 21:12:44 GMTwell Azure still is flawed with 10GB database limit, and any question how they want to solve that remains unanswered (in MS terms: "very easy to scale, just make another 10 or 20 databases following our amazing patterns&practices (unreleased) you'll be in paradise in a moment")... simply put, the whole world is waiting for a genius from MS to come and show Azure folks what to do when they reach the limit, or how to __simply design an application to use twenty databases at once, gosh... watching and listnening the interviews you'll get the picture of scalability (well, that was/is with the table storage thing, but this is not _real_ relational database) but your 10GB database won't scale... "your" DB will still run on one (and only one) server... enough of rant http://ayende.com/4177/nhibernate-on-the-cloud-sql-azure#comment3http://ayende.com/4177/nhibernate-on-the-cloud-sql-azure#comment3Sat, 05 Sep 2009 16:54:12 GMTFrans, To be completely honest, I would have been shocked if that weren't the case. The reason that I posted this is to make sure that people are aware that this is available, and not dismiss it out of hand. I got a few questions about "when will you port NHibernate to SQL Azure", this is meant to solve them. http://ayende.com/4177/nhibernate-on-the-cloud-sql-azure#comment2http://ayende.com/4177/nhibernate-on-the-cloud-sql-azure#comment2Sat, 05 Sep 2009 13:04:58 GMTIt's a modified sqlserver 2008 DB, so any DML statements will work, as long as there are no catalog names in the query + the schema names mentioned have to be owned by the user executing the queries. So any o/r mapper who can do that, (which IMHO is pretty much all) will work on Azure. http://ayende.com/4177/nhibernate-on-the-cloud-sql-azure#comment1http://ayende.com/4177/nhibernate-on-the-cloud-sql-azure#comment1Sat, 05 Sep 2009 13:03:09 GMT