[sqlite]Error parsing column 8 (X=0 - Int64)

[rustbomber]

I have query,the result is :

use dapper 1.60.1 and microsoft.data.sqlite.core 2.2.3, my application report :

---- System.Data.DataException : Error parsing column 8 (IS_SEARCH=0 - Int64)
-------- System.InvalidCastException : Unable to cast object of type 'System.Int64' to type 'System.Int32'.

these filed is interger in sqlite, my class like this:

public class T
{

        public int IsList { get; set; }
        public int IsAdd { get; set; }
        public int IsEdit { get; set; }
        public int IsSearch { get; set; }
        public int IsMany { get; set; }
}

when change int to int? or int to long? still not working 。

If change the provider to System.Data.SQLite.Core is working fine.

[kelvindules]

Unable to cast object of type 'System.Int64' to type 'System.Int32'

Sqlite is weird with INTEGER.
From what I can see, when your column value is null, Sqlite returns it as a long/Int64 (8 bytes) so you should have a long property to map to, not an int/Int32 (4 bytes).

public long IsSearch { get; set; }

Theres is no need to make it nullable unless you need nulls.
When querying a null column value to a non-nullable type, you'll get it's default, in this case 0.

You may also try using ifnull to see if it casts to Int32 properly.

select ifnull(Is_Search, 0) from table

[rustbomber]

@kelvindules long property also test, but still not working, exception info:

---- System.Data.DataException : Error parsing column 8 (IS_SEARCH=0 - Int64)
-------- System.InvalidCastException : Unable to cast object of type 'System.Int64' to type 'System.Int32'.

from the message ,long property still present as 'System.Int32'.

[kelvindules]

@akaylh This looks like #524 . Try casting it as bigint

select cast(Is_Search as bigint) from table

Not sure if that is already addressed.

[rustbomber]

@kelvindules thank you very much.