Вход на сайт
Как лучше хранить GUID в базе (тип данных)?
1748 просмотров
Перейти к просмотру всей ветки
в ответ Murr 29.04.23 14:30, Последний раз изменено 29.04.23 23:16 (AlexNek)
На вот попробуй
CREATE TABLE [dbo].[AspNetRoles] ( [Id] NVARCHAR(128) NOT NULL, [Name] NVARCHAR(256) NULL, [NormalizedName] NVARCHAR(256) NULL, [ConcurrencyStamp] NVARCHAR(MAX) NULL, CONSTRAINT [PK_AspNetRoles] PRIMARY KEY ([Id]) ); CREATE UNIQUE INDEX [RoleNameIndex] ON [dbo].[AspNetRoles] ( [NormalizedName] ASC ); INSERT INTO [dbo].[AspNetRoles] ([Id], [Name], [NormalizedName], [ConcurrencyStamp]) VALUES ('27163748-00f8-4725-8d4e-9dce62923f2c', 'TestAdmin', 'TESTADMIN', 'af32e894-1def-4665-b7be-dff048774f1a'); INSERT INTO [dbo].[AspNetRoles] ([Id], [Name], [NormalizedName], [ConcurrencyStamp]) VALUES ('274e474d-a20d-48a6-ab9a-f260a88fec43', 'TestStudents', 'TESTSTUDENTS', 'e8d8fa37-89b5-4f9d-bdc4-476111593ce9'); INSERT INTO [dbo].[AspNetRoles] ([Id], [Name], [NormalizedName], [ConcurrencyStamp]) VALUES ('274e474d-a20d-48a6-ab9a-f260a88fec43','abs','abs','e8d8fa37-89b5-4f9d-bdc4-476111593ce8');
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Violation of PRIMARY KEY constraint 'PK_AspNetRoles'. Cannot insert duplicate key in object 'dbo.AspNetRoles'. The duplicate key value is (274e474d-a20d-48a6-ab9a-f260a88fec43).