System.Data.SQLite

Question on stackoverflow
https://stackoverflow.com/questions/49608629/an-empty-string-in-a-column-of-type-timestamp-caused-unreadable
Maybe should need some elegant solutions - this error is not common, but it may cause great trouble
1. Add some overloads for Fill method, add a argument to set ignore or not the convert error / ignore error data row
2. Add some convert controler, can let user set the custome convert way
3. …

You mark this issue as WAD. So, can you provide a feasible solution, please?

There are several possible solutions.  One is to change the type of the column
so that the System.Data.SQLite type conversion subsystem does not try to see it
as a DateTime.

Another is to disable all type conversions for the associated connection using
the "GetAllAsText" connection flag, e.g.:

          using (SQLiteConnection connection = new SQLiteConnection(
              "Data Source=test.db;Flags=GetAllAsText"))
          {
            connection.Open();

            // ...
          }

Alternatively, you could use the "UseConnectionReadValueCallbacks" connection
flag and implement a custom SQLiteReadValueCallback to change the value into
something that is a DateTime.

Finally, you could modify the type mappings for the connection to map the
"TIMESTAMP" type to a string instead of a DateTime.  See "AddTypeMapping" in
the help file.

Example of a read value callback:

https://stackoverflow.com/questions/40003272