search

akarzazi / SSMSPlus

SSMS Plus is a productivity extension for SQL Server Management Studio 18 /19
76 stars 22 forks source link

SSMSPlusSearch: Fixed Error parsing column 5 (Scale=0 - Int64) #9

Closed patelriki13 closed 4 years ago

patelriki13 commented 4 years ago

Fixed details:

Ref: https://github.com/StackExchange/Dapper/issues/1285

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).

akarzazi commented 4 years ago

Thankx for the fix, SQLite is tricky indeed