Print Page | Close Window

Where IN query

Printed From: IdeaBlade
Category: DevForce
Forum Name: DevForce 2009
Forum Discription: For .NET 3.5
URL: http://www.ideablade.com/forum/forum_posts.asp?TID=1322
Printed Date: 06-Apr-2025 at 4:32am


Topic: Where IN query
Posted By: mbevins1
Subject: Where IN query
Date 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>)

 


Replies:
Posted By: GregD
Date Posted: 16-Jun-2009 at 5:32pm
See http://social.msdn.microsoft.com/Forums/en-US/adodotnetentityframework/thread/659ff6b9-3d4d-487e-9f1c-d3853ba49415

Posted By: GregD
Date 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));


Print Page | Close Window