Monday, September 29, 2014

Help changing all PK and FK datatypes from uniqueidentifier to nvarchar(128)

To answer the constructive questions asked. I was wanting to change them so they could work with Identity Framework 2.0. It uses GUIDs in code and automatically saves them as nvarchar(128)s in the Identity tables. I was going to change all of the PKs and FKs just to be consistent with Identity FW but I might just drop the Identity table PKs and recreate them as nvarchar(128)s. I could also alter Identity to save as uniqueidentifiers but I do not have the time to do that at the moment. I'm under a strict deadline to launch an MVP version of a site and see if people bite. Right now the main objective is rapid development. Ahem Mr. Celko.

No comments:

Post a Comment