Validation rule using LINQ

Question

It can select operators for each user and I want to check whether the input is valid or not

Here is my expected result:

level | user | operator
1 | A | -
2 | B | AND
2 | C | AND
2 | D | -
3 | E | -

Validation rule

1. the operator must be "-" when there is 1 record in the same level
2. If there is more than 1 record in the same level, the operator must be "-" on the last record and it must select "AND"/ "OR" on other records

How to validate it using LINQ and C#?

Answer 1

Hi Tony-6084,
Please refer to following code:

bool b= list.GroupBy(x => x.level).All(g => g.Last().operators == "-" && g.Count(x => x.operators== "-") == 1);  

If it does not meet the requirements, please provide your code snippets and more details.
Best Regards,
Daniel Zhang

---

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.