How to get a List if it is present in second List

Question

i have two list.i want featch that  data only what those comapare to same column(in both table)

Tapan Patel · Answer

You can use intersect as show below. Please mark it as answer if it resolves the issue.

Susanta Rout · Answer

I have a 3table 1)Customer-FK-1)Companytable different Customer accoding to company and another is 3)Product table. In 3)Product table CustomerID is foreign key. I will have 2 List1) is List 2)List List will store only those customer who is belong to a particular company if I use 3rd list its very easy but i want to store data in 2nd List if customer available in Customer customer list will fill according to company

Vinay Singh · Answer

Hi Try the below code List humans=_unitOfWork.GetHumans(); List anotherHumans=_unitofWork.GetAnotherHumans(); //GetallanotherHumanswheretherecorddoesnotexistinhumans varresult=anotherHumans .Where(ah=>!humans.Any(h=>h.LastName==ah.LastName &&h.Name==ah.Name &&h.Birthday==ah.Birthday &&(!h.PersonalId.HasValue||h.PersonalId==ah.PersonalId))) .ToList(); For detail check the link http://stackoverflow.com/questions/19539822/exclude-items-of-one-list-in-another-with-different-object-data-types-linq http://stackoverflow.com/questions/1202981/select-multiple-fields-from-list-in-linq http://stackoverflow.com/questions/14693578/compare-two-lists-and-save-matching-column-to-a-separate-list

Manas Mohapatra · Answer

Can you give an example what you want to achieve??

How to get a List<.> if it is present in second List<>