In query in Entity Framework

Question

I am working on Entity frame work, i have created a method which is returning List of my Table, I am retrieving data on base of grpID(which is foreign key, so i can have multiple records) I have saved these grpID's in an array so I want to run IN command on Entity framework so that i can get records in single List, How can i apply In command,my code is below

 public List<tblResource> GetResources(long[] grpid)
        {
            try
            {               
                return dataContext.tblResource.Where(c => c.GroupId == grpid && c.IsActive == true).ToList();//This code is not working as i am having array of groupIds

            }
            catch (Exception ex)
            {                
                return ex;
            }
        }

Habib · Accepted Answer · 2012-10-31 11:03:35Z

1

You may use Contains to mimic something like Select IN query

dataContext.tblResource.Where(c=> gripid.Contains(c.GroupId) 
                                  && c.IsActive == true)
                       .ToList();

where grpid is your array of IDs.

You may consider the following example. Suppose you have Product class with two properties ID and Name, and array of ProductList containing the IDs. The Select IN Query should be something like:

int[] productList = new int[] { 1, 2, 3, 4 };
List<Product> products = new List<Product>();
products.Add(new Product { ID = 1, Name = "Test" });
products.Add(new Product { ID = 2, Name = "Test" });
products.Add(new Product { ID = 6, Name = "Test" });
var myProducts = from p in products
                 where productList.Contains(p.ID)
                 select p;
var methodChainingQuery = products.Where(c => productList.Contains(c.ID));

edited Oct 31, 2012 at 11:03

answered Oct 31, 2012 at 10:50

Habib

224k30 gold badges420 silver badges446 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Syed Salman Raza Zaidi Over a year ago

thanks for reply,but i am having long array, so i can't apply Contains :(

Habib Over a year ago

you can apply Contains with long data type. :) it is not just for strings.

Adil · Accepted Answer · 2012-10-31 10:58:23Z

0

Use IEnumerable.Contains with group id array.

List<tblResource> GetResources(long grpid)
{
     try
     {               
         return dataContext.tblResource.Where(c => grpIDArray.Contains(c.GroupId)
         && c.IsActive == true).ToList();    
     }
     catch (Exception ex)
     {                
          return ex;
     }
 }

edited Oct 31, 2012 at 10:58

answered Oct 31, 2012 at 10:51

Adil

148k25 gold badges217 silver badges207 bronze badges

2 Comments

Syed Salman Raza Zaidi Over a year ago

thanks for reply,but i am having long array, so i can't apply Contains :(

Adil Over a year ago

Did you try?, You can apply to long as well.

Pranay Rana · Accepted Answer · 2012-10-31 11:20:09Z

0

How about...

dataContext.tblResource.Where(c=> gripid.Any(GroupId) 
                                && c.IsActive == true).ToList();

edited Oct 31, 2012 at 11:20

Pranay Rana

177k37 gold badges244 silver badges267 bronze badges

answered Oct 31, 2012 at 10:53

Justin Harvey

14.7k2 gold badges30 silver badges30 bronze badges

Collectives™ on Stack Overflow

In query in Entity Framework

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related