Case insensitive comparison in DapperExtensions predicate
<p>I'm trying to do a case insenstive match against a MySQL table while using Dapper Extensions, but I'm getting a null exception on the field name when trying to make it UpperCase within the linq expression:</p>

<p>Here's the code:</p>

<pre><code>            var predicateGroup = new PredicateGroup { Operator = GroupOperator.Or, Predicates = new List&lt;IPredicate&gt;() };

            var term = "term";
            if (term.IsNotNullOrEmpty())
            {
                predicateGroup.Predicates.Add(Predicates.Field&lt;Company&gt;(p =&gt; p.company_code, Operator.Like, string.Format("%{0}%", term)));
                predicateGroup.Predicates.Add(Predicates.Field&lt;Company&gt;(p =&gt; p.company_name.ToUpper(), Operator.Like, string.Format("%{0}%", term)));
            }

            return Count&lt;Company&gt;(predicateGroup, TdsAuthConnectionString);
</code></pre>

<p>Does anybody know how I can use DapperExtensions predicates to do a case insensitive match?</p>

<p>Thank you for any help,
codenewbie</p>