Dapper - like operator using DynamicParameters

.net c# dapper

Question

This works:

var list = conn.Query<int>(
  "select Id from Person where Id in @ids", 
  new { ids = new int[] { 1, 2, 3 } }
);

This throws "No mapping exists from object type System.Int32[] to a known managed provider native type.":

DynamicParameters parameters = new DynamicParameters(
  new { ids = new int[] { 1, 2, 3 } }
);
var list2 = conn.Query<int>(
  "select Id from Person where Id in @ids", 
  parameters
);

Any ideas?

Accepted Answer

Just fixed this issue in the latest dapper (grab from hg), the code used to diverge around the DynamicParameters value extraction. Now the code being run is the same.




Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Is this KB legal? Yes, learn why