How I can use array.contains in entity framework by c#?

Question

I need to Use array.contains method with two parameter that one off them is int?. how can i use?

  string[] role = Roles.GetRolesForUser(Membership.GetUser().UserName)
                       .ToArray();
  int[] ProcessId = biz.Context.tblRoleProcess
                    .Where(x => (role.Contains(x.Role) || 
                            role.Contains("Administrators")) && 
                            x.Measure == true)
                    .Select(x => x.ProcessId).ToArray();

return GetQuery(filterExpression, Columns)
                    .Where(x => ProcessId.Contains(
                            {x.ProcessID,x.ParentProcessID}))
                     .OrderBy<Models.tblProcess>(sortExpression)
                     .Skip(startRowIndex)
                     .Take(maximumRows);

(Read and post error messages.)

user2864740
– user2864740

2014-04-13 09:28:04 +00:00
Commented Apr 13, 2014 at 9:28 — user2864740
– user2864740, Commented Apr 13, 2014 at 9:28

Hamlet Hakobyan · Accepted Answer · 2014-04-13 09:59:24Z

2

Try this:

return GetQuery(filterExpression, Columns)
            .Where(x => ProcessId.Contains(x.ProcessID)
                             || ProcessId.Contains(x.ParentProcessID))
            .OrderBy<Models.tblProcess>(sortExpression)
            .Skip(startRowIndex)
            .Take(maximumRows);

UPDATE

You can define the ProcessId as int?[] or more better as IEnumerable<int?>

IEnumerable<int?> ProcessId = biz.Context.tblRoleProcess
                                 ...
                               .Select(x => (int?)x.ProcessId);

or change where as:

.Where(x => ProcessId.Contains(x.ProcessID)
               || x.ParentProcessID.HasValue
               ? ProcessId.Contains(x.ParentProcessID)
               : false);

edited Apr 13, 2014 at 9:59

answered Apr 13, 2014 at 9:28

Hamlet Hakobyan

33.5k6 gold badges55 silver badges70 bronze badges

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

7 Comments

Hamlet Hakobyan Over a year ago

@asieh What you mean? What type of GetQuery returns?

Asieh hojatoleslami Over a year ago

this return an IQueryable<tblProcess> , i try your answer but i have compile error:"Instance argument: cannot convert from 'int[]' to 'System.Linq.ParallelQuery<int?>' "

Hamlet Hakobyan Over a year ago

@asieh I mean how defined the tblProcess?

Hamlet Hakobyan Over a year ago

@asieh Try define the ProcessId as int?[].

Asieh hojatoleslami Over a year ago

that is a tree. each process maybe has a parent then "ParentProcessID" is not null. if one process hasn't parent ParentProcessID is null

|

Tomas Pastircak · Accepted Answer · 2014-04-13 09:35:23Z

Contains is not a method defined above array, but above IEnumerable<T>. It has two overloads and is well documented on MSDN.

First overload (the one you are using) accepts Integer and uses default comparer, that means, two equal integers are

The other overload is with adding a IEqualityComparer instance, which is not really useful in this case.

The most optimal way to use here is not via contains, but via Any - you may use Contains as suggested in other answers, but that will be less effective:

return GetQuery(filterExpression, Columns)
   .Where(x => ProcessId.Any(processIdItem => processIdItem == x.ProcessID || processIdItem == x.ParentProcessId ))
   .OrderBy<Models.tblProcess>(sortExpression)
   .Skip(startRowIndex)
   .Take(maximumRows);

Collectives™ on Stack Overflow

How I can use array.contains in entity framework by c#?

2 Answers 2

7 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

7 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related