Dapper mapping bool/bit to true

I am using dapper to map the result of query to a strongly typed class(Query<T>). However, dapper always map bit(in mssql)/boolean(postgre) to true. After testing, if I map false the bit/bool value to string, i get 'False', but when i map to bool, it becomes true.
In class T, I have a member like public bool mybool { get; set; } then the query is somthing like this:

        public T SelectByID<T>(string tableName, int id, string fields = "*")
        {
            string sql = $"SELECT {fields} FROM {tableName} WHERE ID = {id}";
            return _connection.QueryFirstOrDefault<T>(sql, null, _transaction);
        }

Start by reproducing the issue with QueryFirstOrDefault, a class containing the bool property, and a false bit/boolean result from SQL Server or PostgreSQL. Trace the mapping path for boolean values and compare it with the string result shown in the report. Done means a false database value maps to false in the strongly typed class, with regression coverage for the reported case.