Guid IDs not allowed
Closed this issue · 0 comments
ashes999 commented
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.