Linq Where inside a where
tom clack
I want to compare the values inside the ids array with the ItemID value in the ItemsOfCars table. ItemsOfCars is a table relationship to many to many.
As an example, I have values 1,2,3,4,5 in ItemsOfCars. I have values 1, 2 in the array named ids. I want to compare them and get the values 3, 4, 5 that are in the ItemsOfCars array but not in the ids array.
[HttpPost]
public IActionResult GetItems(int[] ids)
{
foreach (var item in items)
{
item.ItemsOfCars.Where(x => x.ItemId == ids)
}
}
Sergey
try this:
public IActionResult GetItems(int[] ids)
{
var items= ItemsOfCars.Where(i => !ids.Contains(i.ItemId));
}
この記事はインターネットから収集されたものであり、転載の際にはソースを示してください。
侵害の場合は、連絡してください[email protected]
編集
関連記事
Related 関連記事
- 1
LINQ Where ... AND NOT
- 2
Linq query（Filter、where、if）
- 3
Linq to SQL: WHERE IN statement
- 4
Linq to SQL: WHERE IN statement
- 5
Linq select where contains
- 6
linq where AND with multiple OR's
- 7
Creating LINQ with where clause
- 8
C＃LINQ DataTable "WHERE NOT IN"
- 9
Where to call .AsParallel() in a LINQ query
- 10
The WHERE IN clause with two parameters in linq
- 11
LINQ - optional/nullable where conditions
- 12
Use GetProperties() in LINQ Where clause
- 13
Linq GroupBy With Passed Where Predicate
- 14
動的句 where in Linq to Datatable
- 15
C＃linq include before-after where where
- 16
C＃Linq where list in list
- 17
Where to find translated Linq to Entity query to Sql
- 18
c＃linq crm select where contains
- 19
linQ内の条件Where条件
- 20
Why this optional parameters LINQ WHERE is not working?
- 21
Linq where clause using filter object
- 22
Linq group by in sum column from with where句
- 23
Narrowing down where LINQ expression error is occurring
- 24
LINQ Generic IQueryable <T> WHERE句
- 25
LINQ2つのWhere句
- 26
How to use OR operator in LINQ WHERE statement
- 27
LINQ to Entities does not recognize the method - Include + Where
- 28
LINQ to XML query Where() function not returning anything
- 29
Linq where'not like 'または！<>同等
コメントを追加