Migration error



Question

What to do if the following error occurs during migration?(Column 'AspNetUsers.Id' is not of same collation as referencing column 'VisitedDetails.UserId' in foreign key 'FK_VisitedDetails_AspNetUsers_UserId'.Could not create constraint or index. See previous errors.)

Answer

Make sure that the database table and the database itself have the same collation.