RepoDB: [Bug] Enumeration: Property Int - Is not working

Hi

I’m using RepoDb.SqlServer version 1.1.1 and have the following problem/bug with enums. I want to save the enum as int in the database and according to the documentation this should work.

Setup

Database

CREATE TABLE dbo.Customer
(
  [Id] int NOT NULL IDENTITY(1,1) PRIMARY KEY CLUSTERED
  , [CustomerTypeId] int NOT NULL FOREIGN KEY REFERENCES dbo.CustomerType(Id)
  , [CustomerNumber] varchar(50) NULL
  , INDEX IX_Customer_CustomerNumber UNIQUE (CustomerNumber)
);

Model

public class Customer
{
	public int Id { get; init; }
	public CustomerType CustomerTypeId { get; set; }
	public string CustomerNumber { get; init; }
}

public enum CustomerType
{
	Private = 1,
	Organization = 2
}

Insert call

return await connection.ExecuteScalarAsync<int>(@"
	DECLARE @LastId TABLE (id int);

	INSERT INTO dbo.Customer
	OUTPUT INSERTED.[Id] INTO @LastId
	VALUES(@CustomerTypeId, @CustomerNumber);

	SELECT id FROM @LastId
", customer);

This gives me the following error:

Microsoft.Data.SqlClient.SqlException (0x80131904): Conversion failed when converting the nvarchar value 'Private' to data type int.

If I use the [TypeMap(DbType.Int32)] attribute it works.

If i use RepoDb.TypeMapper.Add<CustomerType>(DbType.Int32); just after call to RepoDb.SqlServerBootstrap.Initialize(); it gives me the same error so only the attribute seems to work.