Problem with Entity Framework extensions .BulkSaveChanges - Saving Guid

I was able to make things work and able to live with this situation considering:

1. That SQLite does not support GUIDs and it gives BLOB data type to data that it can't recognize.
2. That BulkSaveChanges converts or should I say corrects the data before it's persisted, in this case converts it to TEXT.

The problem however is that the data type remains BLOB, then when retrieved through EFCore, converting back to GUID implicitly, wouldn't work.

Upon analyzing the situation, I realized why can't I just define the data type of the GUIDs to TEXT? since BulkSaveChanges does a conversion to TEXT anyway. And in that way, EFCore would be able to see that the GUIDs are saved as TEXT and not BLOB so it can know how to convert it back to GUID implicitly. Turned out, it's possible!

Here's what I did, I added these lines when we build the model through Fluent API for entities that contain GUIDs:

entityTypeBuilder
    .Property(l => l.GUID)
    .HasConversion<string>();

Building the model looks something like this:

public override void Build(ModelBuilder modelBuilder)
{
    EntityTypeBuilder<Person> entityTypeBuilder =
        modelBuilder.Entity<Person>();

    entityTypeBuilder
        .Property(l => l.GUID)
        .HasConversion<string>();
}

Data type of GUIDs before:

Then after added these lines: