Dapper Tutorial - Knowledge Base (KB)

Using Dapper with BLOBs and SQL Server CE

When using BLOBs with more than 8000 bytes of data, you need to specifically set ...Parameter.SqlDbType = SqlDbType.Image... to make it work (...as explained here...)....Dapper, when it sees a ...byte[]... field, defaults to a ...SqlDbType.Binary..., whic...

Sql CE Inconsistent with Multiple Statements

It has long been true that you can ...execute multiple statements with SQL CE.... And in fact I'm using ...SQL Server Compact Toolbox... to do exactly that. But when I take the same multiple-statement commands and execute them from Dapper... ...public c...

Attempting to Modify Dapper to Support SQL Server CE's ntext type

I have a need to support SQL Server CE's ...ntext... type in Dapper. There is a thread here describing the issue: ...https://code.google.com/p/dapper-dot-net/issues/detail?can=2&start=0&num=100&q=&colspec=ID%20Type%20Status%20Priority%20Milestone%20Owner%...