(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...
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...