When using the Generate Schema and Evolve Schema with Windows SQL Azure all tables must have a clustered index.
Luckily this is standard in ECO maintained databases – with one exception – the table that helps ECO to remember what tables there are – the TablesTable. This is usually named ECO_TABLES (name can be overridden).
There is a new PersistenceMapper Configuration setting that tells eco that the even the TablesTable should have Clustered index:
The setting is called TablesTableHasIndex. Set it to true when using SQL Azure.
It had to be a setting to stay compatible with all the other database options.