DevForce Community Forum : Silverlight: Using the Any() method http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2010 : Silverlight: Using the Any() method Mon, 13 Apr 2026 09:56:32 -700 Tue, 05 Apr 2011 05:30:17 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=2579 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Silverlight: Using the Any() method : Got it - I was simply missing... http://www.ideablade.com/forum/forum_posts.asp?TID=2579&PID=10386#10386 Author: jipock
Subject: 2579
Posted: 05-Apr-2011 at 5:30am

Got it -
 
I was simply missing "using System.Linq;" as a declaration....
 
Gotta love overloaded functions in different namespaces..
]]> Tue, 05 Apr 2011 05:30:17 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2579&PID=10386#10386 Silverlight: Using the Any() method : You will only need System.Linq... http://www.ideablade.com/forum/forum_posts.asp?TID=2579&PID=10314#10314 Author: sbelini
Subject: 2579
Posted: 29-Mar-2011 at 3:08pm

You will only need System.Linq and IdeaBlade.EntityModel.
 
I have attached is a simple Silverlight sample against NorthwindIB running a similar query as provided before.
 
uploads/892/Any.zip
 
Silvio.
]]> Tue, 29 Mar 2011 15:08:37 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2579&PID=10314#10314 Silverlight: Using the Any() method : I just tried the code you... http://www.ideablade.com/forum/forum_posts.asp?TID=2579&PID=10310#10310 Author: jipock
Subject: 2579
Posted: 29-Mar-2011 at 12:47pm

I just tried the code you mentioned, however, the code does not compile. It says there was no method of .Any that accepts one argument.
 
Is this an Extension method in another DLL?
 
 
]]> Tue, 29 Mar 2011 12:47:15 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2579&PID=10310#10310 Silverlight: Using the Any() method : Hi Jipock, Unfortunately, theEntity... http://www.ideablade.com/forum/forum_posts.asp?TID=2579&PID=10259#10259 Author: sbelini
Subject: 2579
Posted: 23-Mar-2011 at 10:32am

Hi Jipock,

 

Unfortunately, the Entity Framework does not support Any(Func<T, int, bool>) so you can only execute it against the cache (in either in SL and/or WPF).  

However, your query doesn't really need Any(Func<T, int, bool>), and you could simply use Any(Func<T, bool>) as it is supported by EF and you can run against the query.

So, you query slightly modified:

 

var query = objEntityManager.Classes

                .Include("Sections")

                .OrderBy(op => op.ClassName)

                .Where(op => (this.IsFilterByBeginDate != true || op.Sections.Any(cs => cs.BeginClassDateTime.Date == DateTime.Now.Date)));

 

would execute properly.

We will add a note in our documentation explaining this.

 

Regards,

    Silvio.

 

]]> Wed, 23 Mar 2011 10:32:21 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2579&PID=10259#10259 Silverlight: Using the Any() method : Quick Note - the &#034; ||... http://www.ideablade.com/forum/forum_posts.asp?TID=2579&PID=10248#10248 Author: jipock
Subject: 2579
Posted: 22-Mar-2011 at 9:44am

Quick Note - the " || false " in the where clause is in there by accident. (It was left over scaffolding from debugging).
 
It should read:
 
.Where(op => (this.IsFilterByBeginDate != true || op.Sections.Any((cs,i) => (cs.BeginClassDateTime.Date == DateTime.Now.Date))));
 
Sorry about confusion.
]]> Tue, 22 Mar 2011 09:44:08 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2579&PID=10248#10248 Silverlight: Using the Any() method : Good Afternoon, I&#039;m wondering... http://www.ideablade.com/forum/forum_posts.asp?TID=2579&PID=10246#10246 Author: jipock
Subject: 2579
Posted: 22-Mar-2011 at 9:33am

Good Afternoon,
 
I'm wondering whether or not IdeaBlade supports (with the latest version) the Any() method in Silverlight, and if so, what's wrong with this statement. What I'm trying to do is to return a list of objects (Classes) that that a Section that begins on a certain day.
Some of the documentation with DevForce says that .Any wasn't supported because it returns a scalar value, but this really is part of a sub-query.
 
Query:
 

var query = objEntityManager.Classes

               .Include("Sections")

               .OrderBy(op => op.ClassName)

               .Where(op => (this.IsFilterByBeginDate != true || false||op.Sections.Any((cs,i) => (cs.BeginClassDateTime.Date == DateTime.Now.Date))));

 
The Error returned is:
LINQ to Entities does not recognize the method "Boolean Any[Sections]..... method cannot be translated into a store expression."
 
 
Any thoughts?

 

]]> Tue, 22 Mar 2011 09:33:26 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=2579&PID=10246#10246