Convert Dapper TinyInt

Question

I am trying to write my own DatabaseStorageBase for a mini profiler and I am having problems in my

private List<T> LoadFor<T>(DbConnection conn, object idParameter)

method. Dapper keeps yelling at me with

Error parsing column 5 (level=0 - SByte)

I save the level as tinyint(4), so I assume that dapper cannot do the conversion from Tiny Int to what looks like Enum ( ProfileLevel)? Can someone suggest how I should save the level in mysql so that I can solve my conversion problems?

Answer 1

Wow. what a cool insident, I also implement my own mysqlstorage for miniprofiler and get a similar error with you.

miniprofiler enum MiniProfiler.Level SqlTiming.ExecuteType tinyint datatype , , , Sbyte . mysql , tinyint, as sqlserver :

http://forums.mysql.com/read.php?38,5524,5581#msg-5581

http://social.msdn.microsoft.com/Forums/br/adonetefx/thread/8b0949ba-03e8-4637-baa1-d2b4ff0771f0

, tinyint executeType unsigned tinyint ( ). mysqlstorage , . , sam:)