EnumToString not working in BatchUpdateAsync

[IeuanWalker]

Hi,

I have this table -

[Table("Settings")]
public class SettingsTbl
{
    [Key]
    public SettingsEnum Setting { get; set; }
    [Required]
    [MaxLength(20)]
    public string Value { get; set; }
}

and this in the database context -

modelBuilder
    .Entity<SettingsTbl>()
    .Property(e => e.Setting)
    .HasConversion<string>();

Calling this method -

public async Task UpdateSetting(SettingsEnum setting, object value)
{
    await dbSet
        .Where(x => x.Setting == setting)
        .BatchUpdateAsync(x => new SettingsTbl
        {
            Value = value.ToString()
        })
        .ConfigureAwait(false);
}

Throws the following error -

Using NuGet version - 3.2.3

[borisdj]

Conversion is not currently supported for Batch.

[IeuanWalker]

@borisdj thanks, is this being planned?

Not too familiar how this package works, but if I figure out how to add this feature ill create a PR for it.

[borisdj]

If you manage to do it, you can send PR.

[borisdj]

Solved with latest version.

When doing Batch with named parameter on table that has enum Conversion (Int to String) the name of parameter has to be same as Property name (Case-insensitive), example:
context.Settings.Where(x => x.Settings == settings).BatchUpdate(x => new Setting { Value = value.ToString() });

Explicit enum values will also work:
...Where(x => x.Settings == SettingsEnum.Sett1)...

[borisdj]

As of Now it works even with different named params.