DevForce Community Forum : Where IN query http://www.ideablade.com/forum/ This is an XML content feed of; DevForce Community Forum : DevForce 2009 : Where IN query Sat, 11 Apr 2026 23:38:56 -700 Tue, 16 Jun 2009 17:35:11 -700 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 9.69 360 www.ideablade.com/forum/RSS_post_feed.asp?TID=1322 DevForce Community Forum http://www.ideablade.com/forum/forum_images/IdeaBlade_logo_tm.png http://www.ideablade.com/forum/ Where IN query : ...and FYI, this is, I believe,... http://www.ideablade.com/forum/forum_posts.asp?TID=1322&PID=4781#4781 Author: GregD
Subject: 1322
Posted: 16-Jun-2009 at 5:35pm

...and FYI, this is, I believe, what it would look like if supported in LINQ to Entities (which it isn't):

      string[] names = { "QUICK-Stop", "Chop-suey Chinese", "Simons bistro" };
      var query = _entityManager.Customers.Where(c => names.Contains(c.CompanyName));

]]> Tue, 16 Jun 2009 17:35:11 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1322&PID=4781#4781 Where IN query : See http://social.msdn.microso... http://www.ideablade.com/forum/forum_posts.asp?TID=1322&PID=4780#4780 Author: GregD
Subject: 1322
Posted: 16-Jun-2009 at 5:32pm

See http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/659ff6b9-3d4d-487e-9f1c-d3853ba49415

]]> Tue, 16 Jun 2009 17:32:27 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1322&PID=4780#4780 Where IN query : Hello, I am trying to figure out... http://www.ideablade.com/forum/forum_posts.asp?TID=1322&PID=4764#4764 Author: mbevins1
Subject: 1322
Posted: 15-Jun-2009 at 12:06pm

Hello, I am trying to figure out IN clauses.  For example, I have an entity called Vehicles, with in the Vehicles, I have an operation ID.  I want to return all vehicles where operationID in (1,2,3).
 
Also, the 1,2 3 operations are actually in a collection (

ObservableCollection<Operation>)

 
]]> Mon, 15 Jun 2009 12:06:36 -700 http://www.ideablade.com/forum/forum_posts.asp?TID=1322&PID=4764#4764