title: How to use the @> 'contains' operator with Dapper ORM
body: <p>Using the Dapper ORM I'm constructing the following query to get a specific order from my PostgreSQL datastore:</p>
  <pre><code>string.Format(&quot;SELECT * FROM OrderTable WHERE orderjson @&gt; {0}&quot;,
      &quot;'{\&quot;Lines\&quot;:[{\&quot;SKUID\&quot;:\&quot;@SkuId\&quot;}]}'&quot;);
  </code></pre>
  <p>Passing <code>123456-0</code> into the paramater <code>@SkuId</code> this construction should result into the following query</p>
  <pre><code>SELECT * FROM ordertable WHERE orderjson @&gt; '{&quot;Lines&quot;:[{&quot;SKUID&quot;:&quot;123456-0&quot;}]}'
  </code></pre>
  <p>However Dapper seems to have some trouble with the <code>@&gt;</code> contains operator, as the query always returns no results.</p>
  <p>How do I use this <code>@&gt;</code> operator with Dapper?</p>
  <h2>Update</h2>
  <p>I updated my construction to the following:</p>
  <pre><code>$@&quot;
      SELECT * FROM ordertable
      WHERE orderjson @&gt; '{{&quot;&quot;Lines&quot;&quot;:[{{&quot;&quot;SKUID&quot;&quot;: &quot;&quot;@SkuId&quot;&quot; }}]}}'
  &quot;;
  </code></pre>
  <p>Dapper seems to ignore the paramter <code>@SkuId</code> as my query looks like</p>
  <pre><code>SELECT * FROM ordertable
  WHERE orderjson @&gt; '{&quot;Lines&quot;:[{&quot;SKUID&quot;: &quot;@SkuId&quot; }]}'
  </code></pre>