How does Linqpad know what type a column in Sqlite is ?
I have a c# script which no longer compiles in the beta as it thinks it is a column is a string and I was expecting it to be numeric.
I am currently using LinqPad 9.10.8 which thinks it is a string but is reported as a double? with 9.9.10 and 8.10.4 versions of LinqPad.
The sql pragma_table_info command shows the same results for all three LP versions which is
type decimal(3,2)
notnull 0
I know sqlite doesn't really enforce type checking, but that should not be the case here and to check I ran a SELECT distinct TYPEOF(columnName) from tableName statement which showed just
null
real
integer
EF version was the same with the two LP 9 versions, so I think this is a change of behaviour with the beta.
Answers
-
How many rows are in that table?
-
1,885,116
