Query<T> Invalid attempt to read from column ordinal about dapper

[derekgreer]

It seems there's something peculiar about the [TableNumber] column on my database. The following throws a similar error:

const string sql = @"select TOP(1) [TableNumber] from tgoOrder                  
                order by TimeOfOrderUtc desc";

If I alias [TableNumber] as something else then the query succeeds:

const string sql = @"select TOP(1) [TableNumber] as [TableId] from tgoOrder                 
                order by TimeOfOrderUtc desc";

[derekgreer]

This turned out to be an issue with the TableNumber field on the object. It was defined as an int, but it was a varchar in the db with an empty string. That took some time to track down, as the error message was really misleading.

[mgravell]

Agreed - that error message needs improving. I'll work on that.
On 22 Aug 2014 19:00, "Derek Greer" [email protected] wrote:

This turned out to be an issue with the TableNumber field on the object.
It was defined as an int, but it was a varchar in the db with an empty
string. That took some time to track down, as the error message was really
misleading.

—
Reply to this email directly or view it on GitHub
#148 (comment)
.

[mgravell]

Have working fix, but need to resolve a side-effect with invalid IL; not ignoring - just not quite trivial

[mgravell]

Fixed r1.31; thanks for reporting