Allow automatic schema generation to work against Azure SQL Database

[peternavr]

It appears that Sql Azure requires a clustered primary key for every table. I'm using NHibernate Fluent with this driver. The join tables don't have a primary key though.

[robdmoore]

Are you using NHibernate to generate the schema?

[peternavr]

Yeah

[robdmoore]

Any chance you can provide a bit of sample code so I can replicate it and try and see a way to fix it?

[peternavr]

Sorry to leave this hanging, I forgot to update here.

It turns out that it's not an NHibernate issue, it's the way SQLAzure just works. They require each table to have a PK. It shouldn't be NHibernate that creates them.

[robdmoore]

I'm still interested in investigating if it's possible to fix this - while I would never use NHibernate's schema generation in a production environment it's useful for rapid prototyping and it sucks that you can't use it in SQL Azure.

Are you able to provide some sample code so I can look into it still?

Thanks