Problem with Entity Framework extensions .BulkSaveChanges - Saving Guid

I was able to make things work and deal with this circumstance taking into account:

1. That SQLite does not handle GUIDs and that it classifies unknown data as a BLOB.
2. That BulkSaveChanges changes the data—or should I say corrects the data—to TEXT before it is saved.

The issue is that the data type is still BLOB, therefore implicit conversion to GUID when fetched using EFCore wouldn't function.

After doing some analysis, I understood why I couldn't simply set the GUIDs' data type to TEXT. sinceBulkSaveChanges performs a TEXT conversion nevertheless. And in doing so, EFCore would be able to determine that the GUIDs are stored as TEXT rather than BLOB so that it would understand how to implicitly convert them back to GUID. It turned out to be doable!

As we construct the model using the Fluent API for entities that include GUIDs, I added the following lines.

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

The process of building the model looks like this:

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

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

prior data type of GUIDs:

then added the following lines: