Entity Framework / SQL Server: Enums are saving in database as numeric values rather than strings despite using HasConversion<string>()

Question

I have configured various entities in my DbContext class to convert the enum value to a string when saving to the database eg.

modelBuilder.Entity<TestObject>(builder =>
{
   builder.ToTable("TestObject", "test");
   builder.Property(x => x.MyEnum).HasConversion<string>();
}

However all of these enum values are being saved as the numeric value behind the enum.

I've tried checking the strings aren't being truncated by the max lengths on the columns in the database but the enum string values are definitely all valid lengths.

At this point I'm not sure where else to check, any help is appreciated!

Did you check this solution: stackoverflow.com/questions/32542356/… — Azzy Elvul
– Azzy Elvul, Commented Aug 3, 2022 at 13:12
@Rafalon it's varchar(20) and the longest string value in the enum is 8 characters long — mb1231
– mb1231, Commented Aug 3, 2022 at 13:48

mb1231 · Accepted Answer · 2022-08-03 14:29:00Z

0

The issue was I was using a stored procedure for the insert and didn't realise I was passing the enum value to the SQL parameter in as MyTestEnum.TestValue.

Passing in MyTestEnum.TestValue.ToString() as the SQL parameter fixed the issue.

answered Aug 3, 2022 at 14:29

mb1231

3861 gold badge4 silver badges20 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Entity Framework / SQL Server: Enums are saving in database as numeric values rather than strings despite using HasConversion<string>()

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related