Dapper Tutorial - Knowledge Base (KB)

Dapper dynamic parameters throw a SQLException "must define scalar variable" when not using anonymous objects

(This code is using Dapper Dot Net in C#)...This code works:...var command = "UPDATE account SET priority_id = @Priority WHERE name = @Name"; connection_.Execute(command, new { Name = "myname", Priority = 10 } ); ...This code throws a SqlException:...clas...

Dapper and In Condition

Using Dapper, the following throws ...Incorrect syntax near ','.......const string sql = "select * from ZipToZipDistance z where z.NoRouteFound = 0" + " and z.OriginZip in (@zips) or z.DestZip in (@zips)"; var zipStrings = zips.Select(x => x.ToSt...