title: Passing a full-text search parameter using Dapper.net
body: <p>Consider this simple query which use full text searching on the <code>Keywords</code> field:</p>
  
  <pre><code>DECLARE @searchTerm VARCHAR(500) = 'painted'
  SELECT * FROM StockCatalogueItems
  WHERE (CONTAINS(KeyWords, @searchTerm))
  </code></pre>
  
  <p>This works as expected, but I need to do the same using a Dapper.net parameterised query.  When using stored procedures, I create the full text parameter like this: <code>"\"painted*\""</code></p>
  
  <p>But using the same approach this doesn't work using dapper. No results are returned.  This is the line in the query where I use the parameter:</p>
  
  <pre><code>AND (CONTAINS(KeyWords, @search)) 
  </code></pre>
  
  <p>and it's passed to the query like so:</p>
  
  <pre><code>return _context.Database.Connection.Query&lt;StockProfileMatrix&gt;(basequery, new
  {
      search = searchTerm
  }
  </code></pre>
  
  <p>I can only assume that dapper is sanitising the string somehow, removing quotes perhaps? </p>
  
  <p>Any ideas?</p>