Dapper Tutorial - Knowledge Base (KB)

Dapper not adding parameters

I am trying to use Dapper for our complex queries to remove any lost overhead that was previously existing with NH....I have the following query (note this has been considerably shrunk):...SELECT DISTINCT * FROM tasks t WHERE t.initials = @UserInits ...

Adding parameters to a query with Informix and Dapper fails with syntax exception

I'm attempting to use parameterized queries with Informix over ODBC, but any attempt to add parameters fails with this exception:...$exception {"ERROR [42000] [Informix .NET provider][Informix]A syntax error has occurred."} System.Exception {IBM.Data.I...

Illegal attempt to use Text/Byte host variable - Inserting into TEXT column

Trying to insert into a table (Text Column) via Dapper, and getting the error from Informix:...Illegal attempt to use Text/Byte host variable...I have written a small program to simulate this, and I am still up against problems....We cannot currently use ...