title: converting int to string in linq to entites
body: <p>My Code is :</p>
  
  <pre><code>        var currency = (from ac in db.shop
            join cur in db.books
            on ac.CODE equals cur.CODE.ToString()  //here is the Error
            // because "ac.code is type strig" &amp; "cur.code is type long 
            where ac.ID == merchantId
            select new Currency()
            {
                   ShopCode = ac.CODE,
                   PosCode = ac.POSCODE,
             }).ToList();
  </code></pre>
  
  <p>I found that .ToString(), SqlFunctions.StringConvert(long) are not working in the join query conditions but working in 'select' area in the query.
  However Devart.Data.Oracle.Entity.OracleFunctions.ToChar((long)cur.CODE) is working fine. Since I am using entity framework it shouldn't have problems with particular DB types (i.e. oracle or sql server). It should work even I change from oracle to sql in future.</p>
  
  <p>Please give me a solution for this.</p>