SQL server error in table RoleClaims

[MrGibran]

I set up Sql Server as database, but there is an error in table RoleClaims cause is not set Identity, if you dont change the table CREATE ```
CREATE TABLE [dbo].[Piranha_RoleClaims] ( [Id] INT IDENTITY (1, 1) NOT NULL, [ClaimType] NVARCHAR (MAX) NULL, [ClaimValue] NVARCHAR (MAX) NULL, [RoleId] UNIQUEIDENTIFIER NOT NULL, CONSTRAINT [PK_Piranha_RoleClaims] PRIMARY KEY CLUSTERED ([Id] ASC), CONSTRAINT [FK_Piranha_RoleClaims_Piranha_Roles_RoleId] FOREIGN KEY ([RoleId]) REFERENCES [dbo].[Piranha_Roles] ([Id]) ON DELETE CASCADE );
you cannot log in

[tidyui]

Can we just confirm that you’re running .NET9. As there’s no changes to the Identity package this would indicate a breaking change between 8 and 9 from Microsoft.

[MrGibran]

Sure a use .net 8

[tidyui]

However, the current migration indicates the column is created as identity. Did you encounter any other issues during that could’ve affected setup? https://github.com/PiranhaCMS/piranha.core/blob/master/identity/Piranha.AspNetCore.Identity.SQLServer/Migrations/20180516203540_InitialCreate.cs#L57

[MrGibran]

That's right, I thought that somebody forgot to create as identity... The first time I used SQL Lite I did not have any issues, then I switched to SQL server. At first time, everything worked with the seed and all that, but when I tried to log in, I Saw the error, my conclusion was that was trying to add a row but ID nut is not allowed, I verified in Azure Data Studio I see that the table id was not identity, I switch that and everything works... I will try to do the process again tomorrow, if I get any issues I will share.

[tidyui]

Did you remember to switch from Piranha.Data.SQLite to Piranha.Data.SQLServer. Also, you can't import the database from SQLite to SQLServer as migrations are provider dependent and the SQLite database will most likely be created without identity columns as SQLite doesn't support it.

[MrGibran]

I do not import from SQL lite to SQL Serve, I just switch those lines
var connectionString = builder.Configuration.GetConnectionString("piranha"); options.UseEF<SQLServerDb>(db => db.UseSqlServer(connectionString)); options.UseIdentityWithSeed<IdentitySQLiteDb>(db => db.UseSqlServer(connectionString));
but I think that IdentitySQLiteDb, because I didn't change, because I can't find something like Piranha.AspNetCore.Identity.SQLServer; just Piranha.AspNetCore.Identity.SQLite;

[tidyui]

Makes sense! You need to switch database package for Identity as well!

[MrGibran]

Thats right, I use
options.UseEF<SQLServerDb>(db => db.UseSqlServer(connectionString)); options.UseIdentityWithSeed<IdentitySQLServerDb>(db => db.UseSqlServer(connectionString)
and then works.
also before need to install dotnet add package Piranha.AspNetCore.Identity.SQLServer
Thank you 🙏