i have been working away at configuring my DB for a project and i have set up default security on the project.
this has executed an EF migration to the database and set up the ASP NET user management tables.
i note on these tables that the ID field contians a GUID however the actual field type in the DB is a NVARCHAR(450)
i have no idea why this is set to NVARCHAR(450) instead of a UNIQUEIDENTIFIER but for all my table references where i have records which have a related "CreatdById" i.e. the user ID who created the record i simply want to do a FK relationship to the ASPNETUsers.ID field
so question... what's the best way to change the ID's in the ASPNET user management tables (all of them) to be a UNIQUEIDENTIFIER type to hold the GUID ?