Category.cs

internal class Category:Entity
{
    public string CategoryName { get; set; }

    public string Description { get; set; }

    public byte[] Picture { get; set; }

    public IList<Product> Products { get; set; }
}

CategoryMap.cs

internal class CategoryMap : IEntityTypeConfiguration<Category>
{
    public void Configure(EntityTypeBuilder<Category> builder)
    {
        builder.ToTable("Categories")
            .Property(x => x.Id).HasColumnName("CategoryID");
    }
}

CategoryReadModel.cs

public record CategoryReadModel
{
    internal CategoryReadModel()
    {

    }

    public CategoryReadModel(int id, string categoryName, string description)
 => (Id, CategoryName, Description) = (id, categoryName, description);

    public int Id { get; init; }

    public string CategoryName { get; init; }

    public string Description { get; init; }
}

CategoryReadModeldMap.cs

internal class CategoryReadModeldMap : IEntityTypeConfiguration<CategoryReadModel>
{
    public void Configure(EntityTypeBuilder<CategoryReadModel> builder)
    {
        builder.ToTable("Categories")
            .Property(x => x.Id).HasColumnName("CategoryID");
    }
}