Please has anyone come across the above situation with Dapper and MySQL. In all my tables in MySQL (5.1), where the data type is BIT(1) or BIT, Dapper simply return such field as ulong (UInt64). I am using MySql.Data.MySqlClient and I have no such issue with EF which is what I am trying to convert from.
Thanks for any help.
In MySQL, the type
Boolean is mapped to
Tinyint(1) with MySQL. Perhaps you will have to cast it to
Convert.toBoolean(UInt64) may help you (see http://msdn.microsoft.com/en-us/library/33f2zy48.aspx).
@Christian Droulers: The behaviour of SQLite is similar.