title: How to implement "Firebird" "Similar to" with linq nhibernate in c#
body: <p>How to implement "Firebird" "Similar to" keyword with LINQ to NHibernate. I need it to do search with Regular expression.
  Thanks.</p>
  
  <p>In fact I want to do this kind of things</p>
  
  <pre><code>from entity in Session.Query&lt;Entity&gt;()
  where entity.field.SimilarTo("[0-9]*")
  </code></pre>
  
  <p>to find for example numeric rows.
  SQL generated :</p>
  
  <pre><code>select ....
  from entity e0
  where e0.field similar to '[0-9]*'
  </code></pre>