For some reason, no matter what configuration I use for Id generation I get an
exception when using a HSQL DB:
Exception Description: SEQ_GEN_SEQUENCE: platform HSQLPlatform doesn't support
It's the exact same exception with IDENTITY and SEQUENCE. (Which is strange, as
really it should at least LOOK different with Identity).
HSQL supports Sequence, and has done so since HSQL 1.7 (I believe).
In big projects HSQL is a popular DB to use for unit tests, as it doesn't
require much set up. It means that it isn't a prduction issue, but is seriously
slows down the developers efficiency.