EF6 + SQLite3 database type conversion failure (the specified conversion is invalid), ef6sqlite3

EF6 + SQLite3 database type conversion failure (the specified conversion is invalid), ef6sqlite3

 

The reason for this problem is that all columns of this model in the database are null, so the conversion fails here.

However, I set the value of null in the database (otherwise, the value of null cannot be set), and then generate a model based on the database in VS, Nullable <long>, the value type can also be null like the reference type.

As a result, I found that I was cheated. After a long time, I set all the values in this column to the correct value.

This is the only solution for the moment.