How to convert enum to string in .Net? [duplicate]

Question

I have a class User as below with an enum field Type. How can I store string value of enum in SQL instead of numeric value?

 public class Student
 {
     public int Id { get; set; }
     public string FullName { get; set; }
     public UserTypeEnum Type { get; set; }
     public List<int> CourseIds { get; set; }
 }

 public enum UserTypeEnum
 {
     Bachelor = 10,
     Master = 11,
     PhD = 12
 }

I have tried to do it using EF Core but it doesn't work.

Behzad Dara · Accepted Answer · 2024-02-18 13:52:11Z

0

You can convert your enum to string and retrieve it as enum with code below in your modelbuilder:

 modelBuilder.Entity<Student>().Property(e => e.Type)
            .HasConversion(
                v => v.ToString(),
                v => (UserTypeEnum)Enum.Parse(typeof(UserTypeEnum), v
            ));

answered Feb 18, 2024 at 13:52

Behzad Dara

1759 bronze badges

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

Collectives™ on Stack Overflow

How to convert enum to string in .Net? [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related