This error is happening out of the box (without any customizations)
I created a new WebAssembly application using dotnet 3.1, I added a datasource for a PostgreSQL database with a couple tables defining "FakeItems"
I run the application without security and the application works great.
Then I add Default security, and choose to auto-generate pages for user and role management.
When i run the application again it tries to apply the migration to add the security tables but is using "nvarchar" in the CREATE TABLE scripts. WHich is giving an error since PostgreSQl doesn't use nvarchar.
I've checked the Startup.cs file and it is correctly setting the "UseNpgsql" option:
> services.AddDbContext<ApplicationIdentityDbContext>(options =>
> {
> options.UseNpgsql(Configuration.GetConnectionString("TestConnection"));
> });
This is the error copied:
>
> dotnet: fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
> Failed executing DbCommand (64ms) [Parameters=[], CommandType='Text', CommandTimeout='30']
> CREATE TABLE "DeviceCodes" (
> "UserCode" nvarchar(200) NOT NULL,
> "DeviceCode" nvarchar(200) NOT NULL,
> "SubjectId" nvarchar(200) NULL,
> "SessionId" nvarchar(100) NULL,
> "ClientId" nvarchar(200) NOT NULL,
> "Description" nvarchar(200) NULL,
> "CreationTime" datetime2 NOT NULL,
> "Expiration" datetime2 NOT NULL,
> "Data" nvarchar(max) NOT NULL,
> CONSTRAINT "PK_DeviceCodes" PRIMARY KEY ("UserCode")
> );
>
> dotnet: crit: Microsoft.AspNetCore.Hosting.Diagnostics[6]
> Application startup exception
> Npgsql.PostgresException (0x80004005): 42704: type "nvarchar" does not exist
> at Npgsql.NpgsqlConnector.<>c__DisplayClass160_0.<<DoReadMessage>g__ReadMessageLong|0>d.MoveNext()
> --- End of stack trace from previous location where exception was thrown ---
> at Npgsql.NpgsqlConnector.<>c__DisplayClass160_0.<<DoReadMessage>g__ReadMessageLong|0>d.MoveNext()
> --- End of stack trace from previous location where exception was thrown ---
> at Npgsql.NpgsqlDataReader.NextResult(Boolean async, Boolean isConsuming)
> at Npgsql.NpgsqlDataReader.NextResult()
> at Npgsql.NpgsqlCommand.ExecuteReaderAsync(CommandBehavior behavior, Boolean async, CancellationToken cancellationToken)
> at Npgsql.NpgsqlCommand.ExecuteNonQuery(Boolean async, CancellationToken cancellationToken)
> at Npgsql.NpgsqlCommand.ExecuteNonQuery()
> at Microsoft.EntityFrameworkCore.Storage.RelationalCommand.ExecuteNonQuery(RelationalCommandParameterObject parameterObject)
> at Microsoft.EntityFrameworkCore.Migrations.MigrationCommand.ExecuteNonQuery(IRelationalConnection connection, IReadOnlyDictionary`2 parameterValues)
> at Microsoft.EntityFrameworkCore.Migrations.Internal.MigrationCommandExecutor.ExecuteNonQuery(IEnumerable`1 migrationCommands, IRelationalConnection connection)
> at Microsoft.EntityFrameworkCore.Migrations.Internal.Migrator.Migrate(String targetMigration)
> at Microsoft.EntityFrameworkCore.RelationalDatabaseFacadeExtensions.Migrate(DatabaseFacade databaseFacade)
> at BaseprojectApp.Startup.Configure(IApplicationBuilder app, IWebHostEnvironment env, ApplicationIdentityDbContext identityDbContext) in /Users/me/Repositories/BaseProjects/server/Startup.cs:line 154