Dapper
Dapper copied to clipboard
Error when 'in' query parameter is an empty array
MySQL 5.6 does not seem to support 'select * from students (id in (select null where 1=0))'
//file:SqlMapper.cs
//line:2340
var multiExec = GetMultiExec(value);
if (multiExec != null)
{
StringBuilder sb = null;
bool first = true;
foreach (object subval in multiExec)
{
if (first)
{
sb = GetStringBuilder().Append('(');
first = false;
}
else
{
sb.Append(',');
}
sb.Append(Format(subval));
}
if (first)
{
return "(select null where 1=0)";
}
else
{
return sb.Append(')').ToStringRecycle();
}
}
Please allow configuration of '(select null where 1=0)'
help me!
Duplicate of https://github.com/DapperLib/Dapper/issues/565