Guid IDs not allowed

[ashes999]

Hi,

When I try to create a table with a GUID type for the ID, I get an exception that GUIDs are not allowed. (This is with the SQL Server provider.)

I'm sure there's a reason for this. The problem is, I'm creating a JSON API, so I need GUIDs for everything -- I don't want to manage a pair of IDs (integer for the DB and GUID for everything else).

Is there a way around this? SQL Server itself allows GUID primary keys.

Edit: This error doesn't appear to be coming from Migrator.NET. It's because I specified PrimaryKeyWithIdentity. Changing it to PrimaryKey works.