Models.cs

// auto-generated by sqlc - do not edit
using System;
using System.Collections.Generic;
using System.Linq;

namespace QuickStartMySqlDalGen;
public readonly record struct Author(long Id, string Name, string? Bio);
public readonly record struct Book(long Id, string Name, long AuthorId, string? Description);
public readonly record struct ExtendedBio(string? AuthorName, string? Name, BiosBioType? BioType, HashSet<BiosAuthorType>? AuthorType);
public enum BiosBioType
{
    Invalid = 0, // reserved for invalid enum value
    Autobiography = 1,
    Biography = 2,
    Memoir = 3
}

public static class BiosBioTypeExtensions
{
    private static readonly Dictionary<string, BiosBioType> StringToEnum = new Dictionary<string, BiosBioType>()
    {
        [string.Empty] = BiosBioType.Invalid,
        ["Autobiography"] = BiosBioType.Autobiography,
        ["Biography"] = BiosBioType.Biography,
        ["Memoir"] = BiosBioType.Memoir
    };
    public static BiosBioType ToBiosBioType(this string me)
    {
        return StringToEnum[me];
    }

    public static HashSet<BiosBioType> ToBiosBioTypeSet(this string me)
    {
        return new HashSet<BiosBioType>(me.Split(',').ToList().Select(v => StringToEnum[v]));
    }
}

public enum BiosAuthorType
{
    Invalid = 0, // reserved for invalid enum value
    Author = 1,
    Editor = 2,
    Translator = 3
}

public static class BiosAuthorTypeExtensions
{
    private static readonly Dictionary<string, BiosAuthorType> StringToEnum = new Dictionary<string, BiosAuthorType>()
    {
        [string.Empty] = BiosAuthorType.Invalid,
        ["Author"] = BiosAuthorType.Author,
        ["Editor"] = BiosAuthorType.Editor,
        ["Translator"] = BiosAuthorType.Translator
    };
    public static BiosAuthorType ToBiosAuthorType(this string me)
    {
        return StringToEnum[me];
    }

    public static HashSet<BiosAuthorType> ToBiosAuthorTypeSet(this string me)
    {
        return new HashSet<BiosAuthorType>(me.Split(',').ToList().Select(v => StringToEnum[v]));
    }
}