title: Linq Query two table with like on condition
body: <p>I am trying to join two tables to know if the first table data has a like value from the second table. I tried to use it in <code>SQL</code> and it worked perfectly.</p>
  
  <p>Please see sample below</p>
  
  <pre><code>select  * from Table_1 t1 left outer join
      Table_2 t2 on t1.a like '% ' + t2.a + ' %' or t1.a like '' + t2.a + ' %' or t1.a like '% ' + t2.a + '' 
  </code></pre>