Get distinct values from list

Question

    public List<MAS_EMPLOYEE_TRANSFER> GetEmployeeTransferListForHR(TimecardDataContext TimecardDC)
    {
        List<MAS_EMPLOYEE_TRANSFER> objEmployeeTransferList = null;
        try
        {
            objEmployeeTransferList = new List<MAS_EMPLOYEE_TRANSFER>();
            objEmployeeTransferList = TimecardDC.MAS_EMPLOYEE_TRANSFER.Where(
                employee =>
                    employee.HR_ADMIN_IND=="Y").ToList();                
        }
        finally
        {
        }
        return objEmployeeTransferList;
    }

It shows all list of values where hr admin indicator=yes. But I have to get hr admin=yes and distinct(empid) from the table MAS_EMPLOYEE_TRANSFER. How to get distinct empId from the the objEmployeeTransferList.

Try doing groupbyempId and then selecting. have a look LINQ Select distinct from a List? will help you — huMpty duMpty
– huMpty duMpty, Commented Feb 26, 2013 at 10:18
Check out this question: stackoverflow.com/questions/912188/… — default locale
– default locale, Commented Feb 26, 2013 at 10:20

Community · Accepted Answer · 2017-05-23 10:28:14Z

6

Have try making it

.Distinct().ToList();

You can refer here LINQ: Distinct values

edited May 23, 2017 at 10:28

CommunityBot

11 silver badge

answered Feb 26, 2013 at 10:19

c0dem0nkey

7065 silver badges14 bronze badges

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

1 Comment

Vivek Shukla Over a year ago

it is not working for me . i want do same in C# object list .

Sergey Berezovskiy · Accepted Answer · 2013-02-26 10:18:31Z

4

List<int> ids = objEmployeeTransferList
                   .Select(e => e.empId)
                   .Distinct()
                   .ToList();

Also you can make this on server side without creating in-memory employee list with all admin records:

List<int> ids = TimecardDC.MAS_EMPLOYEE_TRANSFER
                   .Where(e => e.HR_ADMIN_IND == "Y")
                   .Select(e => e.empId)
                   .Distinct()
                   .ToList();

answered Feb 26, 2013 at 10:18

Sergey Berezovskiy

237k44 gold badges441 silver badges468 bronze badges

2 Comments

Ayyappan Sekaran Over a year ago

After getting that list from objEmployeeTransferList. And then only i have to filter by distict(empid). how i have to do that.

Sergey Berezovskiy Over a year ago

@SaiAyyappsSekaran first sample gets unique ids from objEmployeeTransferList

Kiran Solkar · Accepted Answer · 2019-11-05 12:06:20Z

3

Get Distinct using GroupBy

objEmployeeTransferList.GroupBy(x => x.empId).Select(g => g.First()).ToList();

answered Nov 5, 2019 at 12:06

Kiran Solkar

1,2304 gold badges18 silver badges29 bronze badges

Comments

Habibillah · Accepted Answer · 2013-02-26 10:19:06Z

0

Have you try:

objEmployeeTransferList = TimecardDC.MAS_EMPLOYEE_TRANSFER.Where(
   employee => employee.HR_ADMIN_IND=="Y").Distinct().ToList();

answered Feb 26, 2013 at 10:19

Habibillah

28.8k5 gold badges40 silver badges59 bronze badges

Comments

lparry · Accepted Answer · 2013-02-26 10:20:30Z

0

There is a distinct method in linq which should do the trick.

http://msdn.microsoft.com/en-gb/library/bb348436.aspx

answered Feb 26, 2013 at 10:20

lparry

863 bronze badges

Collectives™ on Stack Overflow

Get distinct values from list

5 Answers 5

1 Comment

2 Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

1 Comment

2 Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related