ryankirkman / DapperLite

A Dapper compatible library that works on .NET Compact Framework
30 stars 18 forks source link

Issues with mapping Byte[] and Blob #5

Closed RefractedPaladin closed 10 years ago

RefractedPaladin commented 10 years ago

I have a very simple class and table. In my class I have a Property of type Byte[]. In my table I have a field of type BLOB.

DapperLite 'SEEMS' to not be able to evaluate this? Any ideas? Is BLOB not right, should I be using varchar? Is the issue on my class, should I use string instead?

Thanks

For reference, I am trying to get the data like so: Connection.Query<Employee>("Select Id, CDB_PK, FpTemplate");

That line errors out with a "SQL logic error or missing database\r\nno such column: Id"