Wrong EntityFramewordCore command with Asp.Net Core Identity
------------------------------------------------------------
Key: DNET-816
URL: http://tracker.firebirdsql.org/browse/DNET-816
Project: .NET Data provider
Issue Type: Bug
Components: Entity Framework Core
Environment: <PackageReference
Include="FirebirdSql.Data.FirebirdClient" Version="6.0.0-*" />
<PackageReference Include="FirebirdSql.EntityFrameworkCore.Firebird"
Version="6.0.0-*" />
Reporter: Adriano dos Santos Fernandes
Assignee: Jiri Cincura
OnModelCreating has:
builder.Entity<IdentityUser>().ToTable("IDENTITY_USER")
.Ignore(u => u.LockoutEnd);
builder.Entity<IdentityUser>()
.Property(p => p.Id).HasColumnName("ID");
builder.Entity<IdentityUser>()
.Property(p =>
p.AccessFailedCount).HasColumnName("ACCESS_FAILED_COUNT");
builder.Entity<IdentityUser>()
.Property(p => p.ConcurrencyStamp).HasColumnName("CONCURRENCY_STAMP");
builder.Entity<IdentityUser>()
.Property("Discriminator").HasColumnName("DISCRIMINATOR");
builder.Entity<IdentityUser>()
.Property(p => p.Email).HasColumnName("EMAIL");
builder.Entity<IdentityUser>()
.Property(p => p.EmailConfirmed).HasColumnName("EMAIL_CONFIRMED");
builder.Entity<IdentityUser>()
.Property(p => p.LockoutEnabled).HasColumnName("LOCKOUT_ENABLED");
builder.Entity<IdentityUser>()
.Property(p => p.NormalizedEmail).HasColumnName("NORMALIZED_EMAIL");
builder.Entity<IdentityUser>()
.Property(p =>
p.NormalizedUserName).HasColumnName("NORMALIZED_USER_NAME");
builder.Entity<IdentityUser>()
.Property(p => p.PasswordHash).HasColumnName("PASSWORD_HASH");
builder.Entity<IdentityUser>()
.Property(p => p.PhoneNumber).HasColumnName("PHONE_NUMBER");
builder.Entity<IdentityUser>()
.Property(p =>
p.PhoneNumberConfirmed).HasColumnName("PHONE_NUMBER_CONFIRMED");
builder.Entity<IdentityUser>()
.Property(p => p.SecurityStamp).HasColumnName("SECURITY_STAMP");
builder.Entity<IdentityUser>()
.Property(p => p.TwoFactorEnabled).HasColumnName("TWO_FACTOR_ENABLED");
builder.Entity<IdentityUser>()
.Property(p => p.UserName).HasColumnName("USER_NAME");
Error:
fail: Microsoft.EntityFrameworkCore.Database.Command[20102]
Failed executing DbCommand (55ms) [Parameters=[@p0='?' (Size = 256),
@p1='?', @p14='?' (Size = 8191), @p2='?' (Size = 8191), @p3='?' (Size = 256),
@p4='?', @p5='?', @p6='?' (Size = 256), @p7='?' (Size = 256), @p8='?' (Size =
8191), @p9='?' (Size = 8191), @p10='?', @p11='?' (Size = 8191), @p12='?',
@p13='?' (Size = 256)], CommandType='Text', CommandTimeout='30']
EXECUTE BLOCK (p0 VARCHAR(256) = ?, p1 INTEGER = ?, p2 VARCHAR(8191) = ?,
p3 VARCHAR(256) = ?, p4 BOOLEAN = ?, p5 BOOLEAN = ?, p6 VARCHAR(256) = ?, p7
VARCHAR(256) = ?, p8 VARCHAR(8191) = ?, p9 VARCHAR(8191) = ?, p10 BOOLEAN = ?,
p11 VARCHAR(8191) = ?, p12 BOOLEAN = ?, p13 VARCHAR(256) = ?)
RETURNS (ROWS_AFFECTED INT)
AS
BEGIN
UPDATE "IDENTITY_USER" SET "ACCESS_FAILED_COUNT" = :p1,
"CONCURRENCY_STAMP" = :p14, "EMAIL" = :p3, "EMAIL_CONFIRMED" = :p4,
"LOCKOUT_ENABLED" = :p5, "NORMALIZED_EMAIL" = :p6, "NORMALIZED_USER_NAME" =
:p7, "PASSWORD_HASH" = :p8, "PHONE_NUMBER" = :p9, "PHONE_NUMBER_CONFIRMED" =
:p10, "SECURITY_STAMP" = :p11, "TWO_FACTOR_ENABLED" = :p12, "USER_NAME" = :p13
WHERE "ID" = :p0 AND "CONCURRENCY_STAMP" = :p2;
ROWS_AFFECTED = ROW_COUNT;
SUSPEND;
END
;
FirebirdSql.Data.FirebirdClient.FbException (0x80004005): Dynamic SQL Error
SQL error code = -206
Column unknown
P14
At line 5, column 79 ---> Dynamic SQL Error
SQL error code = -206
Column unknown
P14
At line 5, column 79
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
