title: How to use DbFunction translation in EF Core?
body: <p>I'm looking for something like <code>EF.Functions.FreeText</code> that was implemented in SQL Server but using the <code>MATCH...AGAINST</code> syntax of MySQL.</p>
  
  <p>This is my current workflow:<br>
  AspNetCore 2.1.1<br>
  EntityFrameworkCore 2.1.4<br>
  Pomelo.EntityFrameworkCore.MySql 2.1.4  </p>
  
  <p>The problem is that MySQL uses two functions and I don't know how to interpret that with <code>DbFunction</code> and separate the arguments for each one. Does anyone know how to implement this?</p>
  
  <p>This should be the Linq syntax:</p>
  
  <pre class="lang-cs prettyprint-override"><code>query.Where(x =&gt; DbContext.FullText(new[] { x.Col1, x.Col2, x.Col3 }, "keywords"));
  </code></pre>
  
  <p>And this should be the result generated in SQL:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT * FROM t WHERE MATCH(`Col1`, `Col2`, `Col3`) AGAINST('keywords');
  </code></pre>
  
  <p>I'm trying to follow the following examples using the <code>HasTranslation</code> function:
  <a href="https://github.com/aspnet/EntityFrameworkCore/issues/11295#issuecomment-511440395" rel="nofollow noreferrer">https://github.com/aspnet/EntityFrameworkCore/issues/11295#issuecomment-511440395</a>
  <a href="https://github.com/aspnet/EntityFrameworkCore/issues/10241#issuecomment-342989770" rel="nofollow noreferrer">https://github.com/aspnet/EntityFrameworkCore/issues/10241#issuecomment-342989770</a></p>
  
  <p><em>Note: I know it can be solved with <code>FromSql</code>, but it's not what I'm looking for.</em></p>