Dapper模糊查询Like

if (string.IsNullOrEmpty(para.NickName) == false)
{
  sqlBuilder.Append(" AND NickName LIKE @NickName");
  para.NickName = $"%{para.NickName}%";
}