How to store 'blob' type in MySQL with Entity Framework Core using byte[]?

Question

I have code first model that looks like this:

public class Document
{
    [Key]   
    public int DocumentId {get;set;}

    [Required]
    public byte[] Blob {get; set;}
}

I want that to map to blob data type in MySQL but I keep getting varbinary(255)

How do I get it to map to "blob"?

Answer 1

I used Pomelo.EntityFrameworkCore.MySql to fix my problem.

Answer 2

In your OnModelCreating do:

modelBuilder.Entity<Document>(entity =>
{
  entity.Property(x => x.Blob ).HasColumnType("blob");
}