<?xml version="1.0" encoding="utf-8" ?>
<?xml-stylesheet type="text/xsl" href="RSS_xslt_style.asp" version="1.0" ?>
<rss version="2.0" xmlns:WebWizForums="http://syndication.webwiz.co.uk/rss_namespace/">
 <channel>
  <title>DevForce Community Forum : ToString() lambda expression</title>
  <link>http://www.ideablade.com/forum/</link>
  <description>This is an XML content feed of; DevForce Community Forum : DevForce 2010 : ToString() lambda expression</description>
  <pubDate>Wed, 10 Jun 2026 19:10:38 -700</pubDate>
  <lastBuildDate>Thu, 09 Sep 2010 17:35:16 -700</lastBuildDate>
  <docs>http://blogs.law.harvard.edu/tech/rss</docs>
  <generator>Web Wiz Forums 9.69</generator>
  <ttl>360</ttl>
  <WebWizForums:feedURL>www.ideablade.com/forum/RSS_post_feed.asp?TID=2126</WebWizForums:feedURL>
  <image>
   <title>DevForce Community Forum</title>
   <url>http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png</url>
   <link>http://www.ideablade.com/forum/</link>
  </image>
  <item>
   <title>ToString() lambda expression : Hi,   Unfortunately, SqlFunctions...</title>
   <link>http://www.ideablade.com/forum/forum_posts.asp?TID=2126&amp;PID=8423#8423</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://www.ideablade.com/forum/member_profile.asp?PF=892" rel="nofollow">sbelini</a><br /><strong>Subject:</strong> 2126<br /><strong>Posted:</strong> 09-Sep-2010 at 5:35pm<br /><br />Hi, <DIV>&nbsp;</DIV><DIV>Unfortunately, SqlFunctions methods have no "LINQ to Objects" implementation, they are only defined within a query against an Entity Framework backend (i.e. "LINQ to Entities").</DIV><DIV>&nbsp;</DIV><DIV>As for using <strong>ToString()</strong> (in a lambda expression), since it is not supported&nbsp;by the Entity Framework, it can only be executed against the cache.</DIV>]]>
   </description>
   <pubDate>Thu, 09 Sep 2010 17:35:16 -700</pubDate>
   <guid isPermaLink="true">http://www.ideablade.com/forum/forum_posts.asp?TID=2126&amp;PID=8423#8423</guid>
  </item> 
  <item>
   <title>ToString() lambda expression : Finally I Figure out a solution...</title>
   <link>http://www.ideablade.com/forum/forum_posts.asp?TID=2126&amp;PID=8365#8365</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://www.ideablade.com/forum/member_profile.asp?PF=926" rel="nofollow">jcrada</a><br /><strong>Subject:</strong> 2126<br /><strong>Posted:</strong> 04-Sep-2010 at 12:52pm<br /><br />Finally I Figure out a solution for the problem , you have to use <br><br><title>Snippet</title><pre style="font-family: c&#111;nsolas;"><span style="color: rgb43, 145, 175;">SqlFunctions</span>.StringConvert((<span style="color: rgb43, 145, 175;">Double</span>)person.YearsOld).Contains(searchText)<br><br>this must work fine the problem is that when you execute que query  Ideablade throw an exception<br><br>"Execution of query against the server was successful but execution of query against the local cache failed"<br>Target Site {System.String StringConvert(System.Nullable`1&#091;System.Double&#093;)}<br>{"This function can only be invoked from LINQ to Entities."}<br><br>if I change the query strategy to datasource only, the query is fine, and there is No exception, is there Ideablade <br>support for SqlFunctions, because they work for <span style="color: rgb43, 145, 175;"></span>LINQ to Entities<br></pre>thanks<br>]]>
   </description>
   <pubDate>Sat, 04 Sep 2010 12:52:45 -700</pubDate>
   <guid isPermaLink="true">http://www.ideablade.com/forum/forum_posts.asp?TID=2126&amp;PID=8365#8365</guid>
  </item> 
  <item>
   <title>ToString() lambda expression :  HiIs there any way to use ToString()...</title>
   <link>http://www.ideablade.com/forum/forum_posts.asp?TID=2126&amp;PID=8362#8362</link>
   <description>
    <![CDATA[<strong>Author:</strong> <a href="http://www.ideablade.com/forum/member_profile.asp?PF=926" rel="nofollow">jcrada</a><br /><strong>Subject:</strong> 2126<br /><strong>Posted:</strong> 03-Sep-2010 at 5:23pm<br /><br />Hi<br><br>Is there any way to use ToString() methods in a lambda expression with ideablade?<br>I have something like this <br><pre style="font-family: c&#111;nsolas;"><span style="color: blue;">var</span>&nbsp;query&nbsp;=&nbsp;<span style="">Entities</span>.DefaultManager.GetQuery&lt;People&gt;().AsQueryable();<br><br>and I want to filter some integers and  doubles (for example person years old and Money ) with a textbox value<br><br><pre style="font-family: c&#111;nsolas;"><span style="">String</span>&nbsp;searchText&nbsp;= TextEdit.Text;<br></pre><br><pre style="font-family: c&#111;nsolas;">query&nbsp;=&nbsp;query.Where(person&nbsp;=&gt;&nbsp;&nbsp;person.YearsOld.ToString().Contains(searchText) || <pre style="font-family: c&#111;nsolas;">person.Money.ToString().Contains(searchText)</pre>);</pre><br></pre><br><span style="font-size:10px"><br /><br />Edited by jcrada - 04-Sep-2010 at 12:53pm</span>]]>
   </description>
   <pubDate>Fri, 03 Sep 2010 17:23:17 -700</pubDate>
   <guid isPermaLink="true">http://www.ideablade.com/forum/forum_posts.asp?TID=2126&amp;PID=8362#8362</guid>
  </item> 
 </channel>
</rss>