How to persist SmartFlagEnum in EF Core

[zyofeng]

Currently im using the following syntax in CodeFirst but EF Core complains about AccountRoles not having a primary key (I assume this was due to the missing convertor)

Is there a guide on how to use SmartFlagEnum with EFCore?

public virtual ICollection Roles { get; internal set; } = new HashSet();

public sealed class AccountRoles : SmartFlagEnum {
public static readonly AccountRoles Primary = new AccountRoles("Primary", 1 << 0);
public static readonly AccountRoles Secondary = new AccountRoles("Secondary", 1 << 1);
}

[zyofeng]

Tagging @AFM-Horizon

[cuneytatik84]

Same problem, any improvement

[FairlieAgile]

Most of the functions that come with SmartFlagEnum return an IEnumerable (e.g. .FromValue). So there are 2 options:

1. Use IEnumberable in your entity e.g.
   public IEnumerable<EnvironmentEnum> Environments { get; private set; } = default!;

And then convert it when you configure the Entity:

builder.Property(x => x.Environments)
    .HasConversion(v => ConvertToDatabaseValue(v), v => ConvertFromDatabaseValue(v))

  private int ConvertToDatabaseValue(IEnumerable<EnvironmentEnum> value)
  {
    int intValue = value.Sum(x => x.Value);
    // Log the conversion value
    Console.WriteLine($"Converting {value} to {intValue}");
    return intValue;
  }
  private IEnumerable<EnvironmentEnum> ConvertFromDatabaseValue(int value)
  {
    return EnvironmentEnum.FromValue(value);
  }

2. Use an INT to store the value and convert as you save/retrieve. This option suited me best:

 public int Environments { get; private set; } = default!; 

  public void UpdateEnvironment(string environments)
  {
    Environments = EnvironmentEnum.FromName(environments).Sum(x => x);
}