System.Data.SQLite

Hi SQLite Team,
BACKGROUND:
SQLITE for EntityFrameworkCore supports "DateTimeOffset" values.
SQLITE for EntityFramework6 DOES NOT support "DateTimeOffset" values.

CAUSE:
This seems to be a coding defect in:
System.Data.SQLite.EF6.SQLiteProviderManifest.GetStoreType

For many types, there is code such as:

case PrimitiveTypeKind.DateTime:
return TypeUsage.CreateDefaultTypeUsage(base.StoreTypeNameToStorePrimitiveType["datetime"]);

There does not appear to be one for DateTimeOffset.

I believe that in SQLITE for EFCore, DateTimeOffsets are persisted as strings.

Thanks for your help in fixing this.  We're working to make a library support EFCore and EF6 and this seems to be all that remains.