Converting Query<MyObject> to QueryFirstOrDefault<MyObject> breaks query

[dooferorg]

At the suggestion of the Dapper.AOT system I converted SELECT query type calls from Query("SELECT * FROM my_object_table WHERE id=@foo") style calls to the QueryFirstOrDefault() syntax

What happens is for the same SQL, the query returns an empty object so it breaks things.

**Where are you seeing this?

Dapper 2.1.35
Dapper.AOT 2.0.78

MariaDB 10.11.6

To Reproduce

Try a query with Dapper before and after converting to the QueryFirstOrDefault() style

Expected behavior

I expected my queries to work as before