JOS.Enumeration.Database.EntityFrameworkCore 1.2.9

There is a newer version of this package available.
See the version list below for details.
dotnet add package JOS.Enumeration.Database.EntityFrameworkCore --version 1.2.9                
NuGet\Install-Package JOS.Enumeration.Database.EntityFrameworkCore -Version 1.2.9                
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="JOS.Enumeration.Database.EntityFrameworkCore" Version="1.2.9" />                
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add JOS.Enumeration.Database.EntityFrameworkCore --version 1.2.9                
#r "nuget: JOS.Enumeration.Database.EntityFrameworkCore, 1.2.9"                
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
// Install JOS.Enumeration.Database.EntityFrameworkCore as a Cake Addin
#addin nuget:?package=JOS.Enumeration.Database.EntityFrameworkCore&version=1.2.9

// Install JOS.Enumeration.Database.EntityFrameworkCore as a Cake Tool
#tool nuget:?package=JOS.Enumeration.Database.EntityFrameworkCore&version=1.2.9                

JOS.Enumeration

Enumeration implementation with source generation support.

Installation

JOS.Enumeration

Contains the IEnumeration interface and a System.Text.Json JsonConverter. The JOS.Enumeration.SourceGenerator package contains the actual source generator.

Don't forget to install that one as well. 😃

dotnet add package JOS.Enumeration
dotnet add package JOS.Enumeration.SourceGenerator

JOS.Enumeration.Database.Dapper

Contains a custom TypeHandler to use with Dapper.

dotnet add package JOS.Enumeration.Database.Dapper

JOS.Enumeration.Database.EntityFrameworkCore

Contains ConfigureEnumeration extension method to allow usage with EntityFramework Core.

dotnet add package JOS.Enumeration.Database.EntityFrameworkCore

Usage

  • Create a new partial record or class
  • Implement the IEnumeration<T> interface
  • Add your Enumeration items
public partial record Hamburger : IEnumeration<Hamburger>
{
    public static readonly Hamburger Cheeseburger = new (1, "Cheeseburger");
    public static readonly Hamburger BigMac = new(2, "Big Mac");
    public static readonly Hamburger BigTasty = new(3, "Big Tasty");
}

The source generator will implement the following interface:

// Default implementation -> int as Value
public interface IEnumeration<T> : IEnumeration<int, T> where T : IEnumeration<T>
{
}

public interface IEnumeration<TValue, TType> where TValue : IConvertible
{
    TValue Value { get; }
    string Description { get; }
    static abstract IReadOnlySet<TType> GetAll();
    static abstract IEnumerable<TType> GetEnumerable();
    static abstract TType FromValue(TValue value);
    static abstract TType FromDescription(string description);
    static abstract TType FromDescription(ReadOnlySpan<char> description);
    static abstract Type ValueType { get; }
}

The following code will be generated:

[System.Diagnostics.DebuggerDisplay("{Description}")]
public partial record Hamburger : IComparable<JOS.Enumerations.Hamburger>
{
    private static readonly IReadOnlySet<JOS.Enumerations.Hamburger> AllItems;
    
    static Hamburger()
    {
        AllItems = new HashSet<JOS.Enumerations.Hamburger>(3)
        {
            Cheeseburger,
            BigMac,
            BigTasty
        }.ToFrozenSet(optimizeForReading: true);
    }

    private Hamburger(int value, string description)
    {
        Value = value;
        Description = description ?? throw new ArgumentNullException(nameof(description));
    }

    public int Value { get; }

    public string Description { get; }

    public static IReadOnlySet<JOS.Enumerations.Hamburger> GetAll()
    {
        return AllItems;
    }

    public static IEnumerable<JOS.Enumerations.Hamburger> GetEnumerable()
    {
        yield return Cheeseburger;
        yield return BigMac;
        yield return BigTasty;
    }

    public static JOS.Enumerations.Hamburger FromValue(int value)
    {
        return value switch
        {
            1 => Cheeseburger,
            2 => BigMac,
            3 => BigTasty,
            _ => throw new InvalidOperationException($"'{value}' is not a valid value in 'JOS.Enumerations.Hamburger'")
        };
    }

    public static JOS.Enumerations.Hamburger FromDescription(string description)
    {
        return description switch
        {
            "Cheeseburger" => Cheeseburger,
            "Big Mac" => BigMac,
            "Big Tasty" => BigTasty,
            _ => throw new InvalidOperationException($"'{description}' is not a valid description in 'JOS.Enumerations.Hamburger'")
        };
    }

    public static JOS.Enumerations.Hamburger FromDescription(ReadOnlySpan<char> description)
    {
        return description switch
        {
            "Cheeseburger" => Cheeseburger,
            "Big Mac" => BigMac,
            "Big Tasty" => BigTasty,
            _ => throw new InvalidOperationException($"'{description}' is not a valid description in 'JOS.Enumerations.Hamburger'")
        };
    }

    public static Type ValueType => typeof(int);
    public int CompareTo(JOS.Enumerations.Hamburger? other) => Value.CompareTo(other!.Value);
    public static implicit operator int (JOS.Enumerations.Hamburger item) => item.Value;
    public static implicit operator JOS.Enumerations.Hamburger(int value) => FromValue(value);
}

Features

  • Generic value
  • Generated IComparable<T> method.
  • Generated implicit operators (convert to/from int).
  • Generated optimized GetAll, FromValue and FromDescription methods.
  • System.Text.Json support
  • Database support (Dapper and EF Core).

Generic value

It's possible to use a generic value instead of the default int value by implementing the IEnumeration<TValue, TEnumeration> interface.

public partial record Car : IEnumeration<string, Car>
{
    public static readonly Car FerrariSpider = new("ferrari-spider", "Ferrari Spider");
    public static readonly Car TeslaModelY = new("tesla-model-y", "Tesla Model Y");
}

TValue has a IConvertible constraint.

The following types has been tested and are guaranteed to work:

  • int (default)
  • bool
  • decimal
  • long
  • string
  • uint
  • ulong

JSON

The package comes with a generic JsonConverter. You'll need to register a custom converter for each enumeration. Example:

var jsonSerializerOptions = new JsonSerializerOptions
{
    Converters = { new EnumerationJsonConverter<Hamburger>() }
};

If you're using a custom value, you need to register the converter like this:

var jsonSerializerOptions = new JsonSerializerOptions
{
    Converters = { new EnumerationJsonConverter<string, Car>() }
};

It supports the following scenarios:

  • Serializing to TValue
  • Deserializing from TValue

If you want any other behaviour, just create your own converter and register it.

Database

public class MyEntity
{
    public MyEntity(Guid id, Hamburger hamburger)
    {
        Id = id;
        Hamburger = hamburger;
    }

    public Guid Id { get; }
    public Hamburger Hamburger { get; }
}
Dapper
  • Register the TypeHandler: SqlMapper.AddTypeHandler(new EnumerationTypeHandler<Hamburger>())
  • Query like this:
var results = (await actConnection.QueryAsync<MyEntity>(
            "SELECT id, hamburger from my_entities WHERE id = @id", new {id = myEntity.Id})).ToList(); 
EF Core
  • Configure your DB Context
public DbSet<MyEntity> MyEntities { get; set; } = null!;

protected override void OnModelCreating(ModelBuilder modelBuilder)
{
    modelBuilder.ApplyConfigurationsFromAssembly(typeof(JosEnumerationDbContext).Assembly);
} 
public class MyEntityEntityTypeConfiguration : IEntityTypeConfiguration<MyEntity>
{
    public void Configure(EntityTypeBuilder<MyEntity> builder)
    {
        builder.HasKey(x => x.Id);
        builder.Property(x => x.Hamburger).ConfigureEnumeration().IsRequired();
    }
}
  • Query:
var result = await myDbContext.MyEntities.FirstAsync(x => x.Id == myEntity.Id); 

Primitive Collections

Support for primitive collections in net8.0 can be configured like this:

EF Core
public void Configure(EntityTypeBuilder<MyEntity> builder)
{
    builder.ConfigureEnumeration<MyEntity, string, Car>(x => x.Cars);
}
#endif
Dapper
SqlMapper.AddTypeHandler(new EnumerationArrayTypeHandler<string, Car>());
Product Compatible and additional computed target framework versions.
.NET net7.0 is compatible.  net7.0-android was computed.  net7.0-ios was computed.  net7.0-maccatalyst was computed.  net7.0-macos was computed.  net7.0-tvos was computed.  net7.0-windows was computed.  net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last updated
2.0.5-beta-g4df623a3fd 45 9/17/2024
2.0.4-beta-g41a385195d 33 9/17/2024
2.0.3-beta-g1b3ff0345c 37 9/17/2024
1.3.5-beta-ga3591d0784 145 1/8/2024
1.3.4-beta-g0f657b5945 154 12/15/2023
1.3.3-beta-g86c57c88de 118 12/6/2023
1.3.2-beta-g44904a2c86 114 12/6/2023
1.2.10 220 1/8/2024
1.2.9 191 12/6/2023
1.2.8-beta-g7f4afbc7bc 113 12/6/2023
1.2.7-beta-g8c3c1bea8d 114 12/5/2023
1.2.6-beta-gaceb5947a0 121 12/3/2023
1.2.5-beta-gd88393f87f 134 11/21/2023
1.2.4-beta-gcf63299055 127 11/14/2023
1.2.3-beta-g17d841819f 114 11/14/2023
1.2.2-beta-g48b6b63682 91 11/14/2023
1.1.37 159 11/14/2023
1.1.36-beta-g300cca1b1c 95 11/14/2023
1.1.34-beta-gbd8240dec5 77 11/4/2023
1.1.19-beta-g0616c54bd7 99 7/14/2023
1.1.18-beta-g196c9ec97b 78 7/14/2023
1.1.16-beta-g9ebac3a201 80 7/14/2023
1.1.15-beta-g6aa862b5fa 80 7/14/2023
1.1.14-beta-gd3f3eff596 84 7/14/2023
1.1.13-beta-gaae338e581 84 7/14/2023
1.1.11-beta-gedc10e9f0b 82 7/11/2023
1.1.10-beta-g15d758679f 83 7/11/2023
1.1.9-beta-ga8f5b4d09c 82 7/11/2023
1.1.8-beta-gbe35470ba8 82 7/11/2023
1.1.7-beta-g4edda95a99 80 6/20/2023
1.1.6-beta-gad8ab8816a 79 6/20/2023
1.1.5-beta-g02ae57f212 75 6/19/2023
1.1.4-beta-g2b6e2e274f 84 6/18/2023
1.1.3-beta-gfef378b783 81 6/18/2023
1.1.2-beta-gb3750f4659 75 6/17/2023
1.0.13-beta-g4bac5970df 87 6/17/2023
1.0.12-beta-g5e554e74de 79 6/17/2023
1.0.11-beta-ge0c0ac2086 105 6/17/2023 1.0.11-beta-ge0c0ac2086 is deprecated.
1.0.10-beta-gcbaa073338 108 6/17/2023 1.0.10-beta-gcbaa073338 is deprecated.
1.0.9-beta-g9bac00482d 105 6/17/2023 1.0.9-beta-g9bac00482d is deprecated.
1.0.8-beta-gec072ace6a 111 6/17/2023 1.0.8-beta-gec072ace6a is deprecated.
1.0.6-beta-g3f377c1cfc 106 6/17/2023 1.0.6-beta-g3f377c1cfc is deprecated.
1.0.4-beta-g35471cdafc 104 6/17/2023 1.0.4-beta-g35471cdafc is deprecated.