System.Data.SQLite

To add compatibility with "DateTimeFormat", "DateTimeFormatString" and "DateTimeKind" options and to reflect the actual time precision supported by SQLite.

Any chance to see this fixed?

It seems like simply treating datetime2 as if it was datetime would save a lot of headaches. Is there a concern that this kind of change would break something else?

I've looked into adding this support before.  If I remember correctly, it would
be very difficult to maintain backward compatibility with existing databases and
their data types.

Further, DateTime2 appears to be SQL Server specific.

It should be noted that it is possible to customize the data type mappings used
by System.Data.SQLite on a per-connection basis.  That way, if a database schema
includes the type name DATETIME2, you should be able to map it to the DateTime2
DbType.  I'll try to add some tests to verify this is possible.

Confirmed.  Using the latest version of System.Data.SQLite, you can add a custom
type mapping for DATETIME2 that maps to the DbType DateTime using code similar to
the following:

  SQLiteConnection cnn = new SQLiteConnection("Data Source=:memory:;");
  cnn.Open();
  cnn.AddTypeMapping("DATETIME2", DbType.DateTime, false);