Bug: Cannot insert explicit value for identity column in table 'TableName' when IDENTITY_INSERT is set to OFF

[motycak]

Library name and version

• Kros.KORM 4.1.0

Description

It is not enough to define in the DatabaseConfiguration for the entity:
.AutoIncrement (autoIncrementType: AutoIncrementMethodType.Identity).
When adding an item. It falls: Cannot insert explicit value for identity column in table 'TableName' when IDENTITY_INSERT is set to OFF

Steps To Reproduce

1. Initialization script:

IF NOT EXISTS (SELECT 1 FROM sysobjects WHERE NAME='Users' and xtype='U')
BEGIN
    CREATE TABLE [dbo].[Users](
        [Id] [bigint] IDENTITY(1,1) NOT NULL,
        [Email] [nvarchar](255) NOT NULL,

        CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED ([Id] ASC)
        WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
    ) ON [PRIMARY]
END

2. DatabaseConfiguration:

public override void OnModelCreating(ModelConfigurationBuilder modelBuilder)
{
     modelBuilder.Entity<User>()
     .HasTableName(UsersTableName)
     .HasPrimaryKey(f => f.Id)
     .AutoIncrement(autoIncrementType:AutoIncrementMethodType.Identity);
}

3. Entity:

[Alias("Users")]
    public class User
    {
        /// <summary>
        /// Id.
        /// </summary>
        public long Id { get; set; }

        /// <summary>
        /// Email.
        /// </summary>
        public string Email { get; set; }
    }

4.Used:

var users = _database.Query<User>().AsDbSet();
users.Add( new User() { Email = "[email protected]" });
users.CommitChanges();

Actual behavior:

When I add an annotation to an id, it adds an item.

[Alias("Users")]
public class User
{
    /// <summary>
    /// Id.
    /// </summary>
   [Key(autoIncrementMethodType: AutoIncrementMethodType.Identity)]
    public long Id { get; set; }

    /// <summary>
    /// Email.
    /// </summary>
    public string Email { get; set; }
}

[Burgyn]

Hi @motycak,

(un)fortunately this is not a general mistake. Because I couldn't reproduce it in example. (see my demo project)

Maybe it depends on some of your other settings, or you have a problem elsewhere. Are you sure you are using the correct instance of IDatabase to which DatabaseConfigurations is configured?