Проблема с EF Core 8, обрабатывающим бит MSSQL tinyint и nullable в Blazor

Ниже приведены выдержки из примера проекта Visual Studio 2022 Blazor, специально созданного для демонстрации проблемы.

Будем признательны за любые советы по исправлению ошибок, перечисленных внизу. Однако изменение типов данных MSSQL, к сожалению, невозможно. Заранее спасибо!

документ: BlazorApp1.proj

<Project Sdk = "Microsoft.NET.Sdk.Web">
  <PropertyGroup>
    <TargetFramework>net8.0</TargetFramework>
    <Nullable>enable</Nullable>
    <ImplicitUsings>enable</ImplicitUsings>
  </PropertyGroup>
  <ItemGroup>
    <PackageReference Include = "Microsoft.AspNetCore.Components.QuickGrid.EntityFrameworkAdapter" Version = "8.0.3" />
    <PackageReference Include = "Microsoft.EntityFrameworkCore" Version = "8.0.3" />
    <PackageReference Include = "Microsoft.EntityFrameworkCore.Design" Version = "8.0.3">
      <PrivateAssets>all</PrivateAssets>
      <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
    </PackageReference>
    <PackageReference Include = "Microsoft.EntityFrameworkCore.SqlServer" Version = "8.0.3" />
    <PackageReference Include = "Microsoft.EntityFrameworkCore.Tools" Version = "8.0.3">
      <PrivateAssets>all</PrivateAssets>
      <IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
    </PackageReference>
    <PackageReference Include = "Microsoft.VisualStudio.Web.CodeGeneration.Design" Version = "8.0.2" />
  </ItemGroup>
</Project>

документ: appsettings.json

{
  "Logging": {
    "LogLevel": {
      "Default": "Information",
      "Microsoft.AspNetCore": "Warning"
    }
  },
  "AllowedHosts": "*",
  "ConnectionStrings": {
    "connectionstring": "Server=(localdb)\\MSSQLLocalDB;Database=Test;Trusted_Connection=True"
  }
}

документ: Program.cs

using BlazorApp1.Components;

var builder = WebApplication.CreateBuilder(args);
// Add services to the container.
builder.Services.AddRazorComponents()
    .AddInteractiveServerComponents();
var app = builder.Build();
// Configure the HTTP request pipeline.
if (!app.Environment.IsDevelopment())
{
    app.UseExceptionHandler("/Error", createScopeForErrors: true);
    // The default HSTS value is 30 days. You may want to change this for production scenarios, see https://aka.ms/aspnetcore-hsts.
    app.UseHsts();
}
app.UseHttpsRedirection();
app.UseStaticFiles();
app.UseAntiforgery();
app.MapRazorComponents<App>()
    .AddInteractiveServerRenderMode();
app.Run();

база данных:

CREATE DATABASE Test
CREATE TABLE [dbo].[Sample] (
    [Id]              INT        NOT NULL,
    [NCharRequired]   NCHAR (10) NOT NULL,
    [NCharNullable]   NCHAR (10) NULL,
    [IntRequired]     INT        NOT NULL,
    [IntNullable]     INT        NULL,
    [TinyIntRequired] TINYINT    NOT NULL,
    [TinyIntNullable] TINYINT    NULL,
    [BitRequired]     BIT        NOT NULL,
    [BitNullable]     BIT        NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);

окно: Консоль управления пакетами

Scaffold-DbContext "Server=(localdb)\MSSQLLocalDB;Database=Test;Trusted_Connection=True" Microsoft.EntityFrameworkCore.SqlServer

документ: Sample.cs

namespace BlazorApp1.Models;
public partial class Sample
{
    public int Id { get; set; }
    public string NcharRequired { get; set; } = null!;
    public string? NcharNullable { get; set; }
    public int IntRequired { get; set; }
    public int? IntNullable { get; set; }
    public byte TinyIntRequired { get; set; }
    public byte? TinyIntNullable { get; set; }
    public bool BitRequired { get; set; }
    public bool? BitNullable { get; set; }
}

документ: TestContext.cs

using Microsoft.EntityFrameworkCore;
namespace BlazorApp1.Models;

public partial class TestContext : DbContext
{
    public TestContext()
    {
    }
    public TestContext(DbContextOptions<TestContext> options)
        : base(options)
    {
    }
    public virtual DbSet<Sample> Samples { get; set; }
    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
#warning To protect potentially sensitive information in your connection string, you should move it out of source code. You can avoid scaffolding the connection string by using the Name= syntax to read it from configuration - see https://go.microsoft.com/fwlink/?linkid=2131148. For more guidance on storing connection strings, see https://go.microsoft.com/fwlink/?LinkId=723263.
        => optionsBuilder.UseSqlServer("Server=(localdb)\\MSSQLLocalDB;Database=Test;Trusted_Connection=True");
    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Sample>(entity =>
        {
            entity.HasKey(e => e.Id).HasName("PK__Table__3214EC07F913B460");
            entity.ToTable("Sample");
            entity.Property(e => e.Id).ValueGeneratedNever();
            entity.Property(e => e.NcharNullable)
                .HasMaxLength(10)
                .IsFixedLength()
                .HasColumnName("NCharNullable");
            entity.Property(e => e.NcharRequired)
                .HasMaxLength(10)
                .IsFixedLength()
                .HasColumnName("NCharRequired");
        });
        OnModelCreatingPartial(modelBuilder);
    }
    partial void OnModelCreatingPartial(ModelBuilder modelBuilder);
}

контекстное меню: BlazorApp1

Add->
New Scaffolded Item->
Razor Components using Entity Framework (CRUD)->
Template:CRUD
Model class:Sample (BlazorApp1.Models)
DbContext class:TestContext (BlazorApp1.Models)

документ: Create.razor

@page "/samples/create"
@inject BlazorApp1.Models.TestContext DB
@using BlazorApp1.Models
@inject NavigationManager NavigationManager
<PageTitle>Create</PageTitle>
<h1>Create</h1>
<h4>Sample</h4>
<hr />
<div class = "row">
    <div class = "col-md-4">
        <EditForm method = "post" Model = "Sample" OnValidSubmit = "AddSample" FormName = "create" Enhance>
            <DataAnnotationsValidator />
            <ValidationSummary class = "text-danger" />
            <div class = "mb-3">
                <label for = "ncharrequired" class = "form-label">NcharRequired:</label>
                <InputText id = "ncharrequired" @bind-Value = "Sample.NcharRequired" class = "form-control" />
                <ValidationMessage For = "() => Sample.NcharRequired" class = "text-danger" />
            </div>
            <div class = "mb-3">
                <label for = "ncharnullable" class = "form-label">NcharNullable:</label>
                <InputText id = "ncharnullable" @bind-Value = "Sample.NcharNullable" class = "form-control" />
                <ValidationMessage For = "() => Sample.NcharNullable" class = "text-danger" />
            </div>
            <div class = "mb-3">
                <label for = "intrequired" class = "form-label">IntRequired:</label>
                <InputNumber id = "intrequired" @bind-Value = "Sample.IntRequired" class = "form-control" />
                <ValidationMessage For = "() => Sample.IntRequired" class = "text-danger" />
            </div>
            <div class = "mb-3">
                <label for = "intnullable" class = "form-label">IntNullable:</label>
                <InputNumber id = "intnullable" @bind-Value = "Sample.IntNullable" class = "form-control" />
                <ValidationMessage For = "() => Sample.IntNullable" class = "text-danger" />
            </div>
            <div class = "mb-3">
                <label for = "tinyintrequired" class = "form-label">TinyIntRequired:</label>
                <InputText id = "tinyintrequired" @bind-Value = "Sample.TinyIntRequired" class = "form-control" />
                <ValidationMessage For = "() => Sample.TinyIntRequired" class = "text-danger" />
            </div>
            <div class = "mb-3">
                <label for = "tinyintnullable" class = "form-label">TinyIntNullable:</label>
                <InputText id = "tinyintnullable" @bind-Value = "Sample.TinyIntNullable" class = "form-control" />
                <ValidationMessage For = "() => Sample.TinyIntNullable" class = "text-danger" />
            </div>
            <div class = "mb-3">
                <label for = "bitrequired" class = "form-label">BitRequired:</label>
                <InputCheckbox id = "bitrequired" @bind-Value = "Sample.BitRequired" class = "form-check-input" />
                <ValidationMessage For = "() => Sample.BitRequired" class = "text-danger" />
            </div>
            <div class = "mb-3">
                <label for = "bitnullable" class = "form-label">BitNullable:</label>
                <InputCheckbox id = "bitnullable" @bind-Value = "Sample.BitNullable" class = "form-check-input" />
                <ValidationMessage For = "() => Sample.BitNullable" class = "text-danger" />
            </div>
            <button type = "submit" class = "btn btn-primary">Create</button>
        </EditForm>
    </div>
</div>
<div>
    <a href = "/samples">Back to List</a>
</div>
@code {
    [SupplyParameterFromForm]
    public Sample Sample { get; set; } = new();
    // To protect from overposting attacks, see https://aka.ms/RazorPagesCRUD
    public async Task AddSample()
    {
        DB.Samples.Add(Sample);
        await DB.SaveChangesAsync();
        NavigationManager.NavigateTo("/samples");
    }
}

документ: Edit.razor

@page "/Samples/edit"
@inject BlazorApp1.Models.TestContext DB
@using BlazorApp1.Models
@inject NavigationManager NavigationManager
@using Microsoft.EntityFrameworkCore
<PageTitle>Edit</PageTitle>
<h1>Edit</h1>
<h4>Sample</h4>
<hr />
@if (Sample is null)
{
    <p><em>Loading...</em></p>
}
else
{
    <div class = "row">
        <div class = "col-md-4">
            <EditForm method = "post" Model = "Sample" OnValidSubmit = "UpdateSample" FormName = "edit" Enhance>
                <DataAnnotationsValidator />
                <ValidationSummary />
                <input type = "hidden" name = "Sample.Id" value = "@Sample.Id" />
                <div class = "mb-3">
                    <label for = "ncharrequired" class = "form-label">NcharRequired:</label>
                    <InputText id = "ncharrequired" @bind-Value = "Sample.NcharRequired" class = "form-control" />
                    <ValidationMessage For = "() => Sample.NcharRequired" class = "text-danger" />
                </div>
                <div class = "mb-3">
                    <label for = "ncharnullable" class = "form-label">NcharNullable:</label>
                    <InputText id = "ncharnullable" @bind-Value = "Sample.NcharNullable" class = "form-control" />
                    <ValidationMessage For = "() => Sample.NcharNullable" class = "text-danger" />
                </div>
                <div class = "mb-3">
                    <label for = "intrequired" class = "form-label">IntRequired:</label>
                    <InputNumber id = "intrequired" @bind-Value = "Sample.IntRequired" class = "form-control" />
                    <ValidationMessage For = "() => Sample.IntRequired" class = "text-danger" />
                </div>
                <div class = "mb-3">
                    <label for = "intnullable" class = "form-label">IntNullable:</label>
                    <InputNumber id = "intnullable" @bind-Value = "Sample.IntNullable" class = "form-control" />
                    <ValidationMessage For = "() => Sample.IntNullable" class = "text-danger" />
                </div>
                <div class = "mb-3">
                    <label for = "tinyintrequired" class = "form-label">TinyIntRequired:</label>
                    <InputText id = "tinyintrequired" @bind-Value = "Sample.TinyIntRequired" class = "form-control" />
                    <ValidationMessage For = "() => Sample.TinyIntRequired" class = "text-danger" />
                </div>
                <div class = "mb-3">
                    <label for = "tinyintnullable" class = "form-label">TinyIntNullable:</label>
                    <InputText id = "tinyintnullable" @bind-Value = "Sample.TinyIntNullable" class = "form-control" />
                    <ValidationMessage For = "() => Sample.TinyIntNullable" class = "text-danger" />
                </div>
                <div class = "mb-3">
                    <label for = "bitrequired" class = "form-label">BitRequired:</label>
                    <InputCheckbox id = "bitrequired" @bind-Value = "Sample.BitRequired" class = "form-check-input" />
                    <ValidationMessage For = "() => Sample.BitRequired" class = "text-danger" />
                </div>
                <div class = "mb-3">
                    <label for = "bitnullable" class = "form-label">BitNullable:</label>
                    <InputCheckbox id = "bitnullable" @bind-Value = "Sample.BitNullable" class = "form-check-input" />
                    <ValidationMessage For = "() => Sample.BitNullable" class = "text-danger" />
                </div>
                <button type = "submit" class = "btn btn-primary">Save</button>
            </EditForm>
        </div>
    </div>
}
<div>
    <a href = "/samples">Back to List</a>
</div>
@code {
    [SupplyParameterFromQuery]
    public int Id { get; set; }
    [SupplyParameterFromForm]
    public Sample? Sample { get; set; }
    protected override async Task OnInitializedAsync()
    {
        Sample ??= await DB.Samples.FirstOrDefaultAsync(m => m.Id == Id);
        if (Sample is null)
        {
            NavigationManager.NavigateTo("notfound");
        }
    }
    // To protect from overposting attacks, enable the specific properties you want to bind to.
    // For more details, see https://aka.ms/RazorPagesCRUD.
    public async Task UpdateSample()
    {
        DB.Attach(Sample!).State = EntityState.Modified;
        try
        {
            await DB.SaveChangesAsync();
        }
        catch (DbUpdateConcurrencyException)
        {
            if (!SampleExists(Sample!.Id))
            {
                NavigationManager.NavigateTo("notfound");
            }
            else
            {
                throw;
            }
        }
        NavigationManager.NavigateTo("/samples");
    }
    bool SampleExists(int id)
    {
        return DB.Samples.Any(e => e.Id == id);
    }
}

окно: Список ошибок

Error (active)  CS1662  Cannot convert lambda expression to intended delegate type because some of the return types in the block are not implicitly convertible to the delegate return type BlazorApp1  .\Create.razor  14
Error (active)  CS1503  Argument 1: cannot convert from 'byte' to 'string'  BlazorApp1  .\Create.razor  39
Error (active)  CS1503  Argument 2: cannot convert from 'Microsoft.AspNetCore.Components.EventCallback<byte>' to 'Microsoft.AspNetCore.Components.EventCallback'    BlazorApp1  .\Create.razor  39
Error (active)  CS0029  Cannot implicitly convert type 'byte' to 'string'   BlazorApp1  .\Create.razor  39
Error (active)  CS1662  Cannot convert lambda expression to intended delegate type because some of the return types in the block are not implicitly convertible to the delegate return type BlazorApp1  .\Create.razor  39
Error (active)  CS1503  Argument 1: cannot convert from 'byte?' to 'string' BlazorApp1  .\Create.razor  44
Error (active)  CS1503  Argument 2: cannot convert from 'Microsoft.AspNetCore.Components.EventCallback<byte?>' to 'Microsoft.AspNetCore.Components.EventCallback'   BlazorApp1  .\Create.razor  44
Error (active)  CS0029  Cannot implicitly convert type 'byte?' to 'string'  BlazorApp1  .\Create.razor  44
Error (active)  CS1662  Cannot convert lambda expression to intended delegate type because some of the return types in the block are not implicitly convertible to the delegate return type BlazorApp1  .\Create.razor  44
Error (active)  CS1503  Argument 1: cannot convert from 'bool?' to 'bool'   BlazorApp1  .\Create.razor  54
Error (active)  CS1503  Argument 2: cannot convert from 'Microsoft.AspNetCore.Components.EventCallback<bool?>' to 'Microsoft.AspNetCore.Components.EventCallback'   BlazorApp1  .\Create.razor  54
Error (active)  CS0266  Cannot implicitly convert type 'bool?' to 'bool'. An explicit conversion exists (are you missing a cast?)   BlazorApp1  .\Create.razor  54
Error (active)  CS1662  Cannot convert lambda expression to intended delegate type because some of the return types in the block are not implicitly convertible to the delegate return type BlazorApp1  .\Create.razor  54
Error (active)  CS1662  Cannot convert lambda expression to intended delegate type because some of the return types in the block are not implicitly convertible to the delegate return type BlazorApp1  .\Edit.razor    21
Error (active)  CS1503  Argument 1: cannot convert from 'byte' to 'string'  BlazorApp1  .\Edit.razor    47
Error (active)  CS1503  Argument 2: cannot convert from 'Microsoft.AspNetCore.Components.EventCallback<byte>' to 'Microsoft.AspNetCore.Components.EventCallback'    BlazorApp1  .\Edit.razor    47
Error (active)  CS0029  Cannot implicitly convert type 'byte' to 'string'   BlazorApp1  .\Edit.razor    47
Error (active)  CS1662  Cannot convert lambda expression to intended delegate type because some of the return types in the block are not implicitly convertible to the delegate return type BlazorApp1  .\Edit.razor    47
Error (active)  CS1503  Argument 1: cannot convert from 'byte?' to 'string' BlazorApp1  .\Edit.razor    52
Error (active)  CS1503  Argument 2: cannot convert from 'Microsoft.AspNetCore.Components.EventCallback<byte?>' to 'Microsoft.AspNetCore.Components.EventCallback'   BlazorApp1  .\Edit.razor    52
Error (active)  CS0029  Cannot implicitly convert type 'byte?' to 'string'  BlazorApp1  .\Edit.razor    52
Error (active)  CS1662  Cannot convert lambda expression to intended delegate type because some of the return types in the block are not implicitly convertible to the delegate return type BlazorApp1  .\Edit.razor    52
Error (active)  CS1503  Argument 1: cannot convert from 'bool?' to 'bool'   BlazorApp1  .\Edit.razor    62
Error (active)  CS1503  Argument 2: cannot convert from 'Microsoft.AspNetCore.Components.EventCallback<bool?>' to 'Microsoft.AspNetCore.Components.EventCallback'   BlazorApp1  .\Edit.razor    62
Error (active)  CS0266  Cannot implicitly convert type 'bool?' to 'bool'. An explicit conversion exists (are you missing a cast?)   BlazorApp1  .\Edit.razor    62
Error (active)  CS1662  Cannot convert lambda expression to intended delegate type because some of the return types in the block are not implicitly convertible to the delegate return type BlazorApp1  .\Edit.razor    62

Попробовал:

1. Активно искал в Интернете и просматривал множество связанных статей, но не нашел решения.

2. Добавление их в OnModelCreating, но ошибки не исчезли.

entity.Property(e => e.TinyIntRequired).HasColumnType("tinyint").IsRequired(true);
entity.Property(e => e.TinyIntNullable).HasColumnType("tinyint").IsRequired(false);
entity.Property(e => e.BitNullable).HasColumnType("bit").IsRequired(false);

3. Исследовательское изменение типов данных MSSQL с tinyint на int и бит null разрешено на запрещено. Ошибки устранены. Однако изменение типов данных, к сожалению, невозможно.