Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: C# LINQ RIA
hi every om
whis the in , any operators in linq or Lambda
i want select all job id where job_id in (1,2,3)
or how i can send condition
 
public IQueryable GetJob_Allowance()
{
 
return this.ObjectContext.Job_Allowance.Where(ds => ds.Job_ID ---- {1,2,3});
}
thanks for anyhelp
Posted 1-Jul-12 2:50am
Comments
Oleksandr Kulchytskyi at 1-Jul-12 8:26am
   
public IQueryable GetJob_Allowance()
{

return this.ObjectContext.Job_Allowance.Where(ds => ds.Job_ID>=1 && ds.Job_ID<=3);
}

1 solution

Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

public IQueryable GetJob_Allowance()
{   var ListOfIdsA = new List<int>(){1,2,3};
    return this.ObjectContext.Job_Allowance.Where(ds => ListOfIdsA.Contains(ds.Job_ID));
}
 
If you get job ids from some other table create job id list as below and use that.
 
  var ListOfIdsA = this.ObjectContext.Jobs.Select(j=>j.Job_id).ToList();
  Permalink  
v3
Comments
Mostafa Elsadany at 1-Jul-12 9:03am
   
i find thath
return this.ObjectContext.Job_Allowance.Where("it.Job_id in {1,3}");
how i can replace {1,3} to sql as select job_id from tablejobe where
thanks for help

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 George Jonsson 175
1 Kornfeld Eliyahu Peter 169
2 Zoltán Zörgő 139
3 PIEBALDconsult 130
4 OriginalGriff 120
0 OriginalGriff 6,165
1 DamithSL 4,658
2 Maciej Los 4,107
3 Kornfeld Eliyahu Peter 3,649
4 Sergey Alexandrovich Kryukov 3,342


Advertise | Privacy | Mobile
Web02 | 2.8.141220.1 | Last Updated 1 Jul 2012
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100