Click here to Skip to main content
11,715,160 members (65,651 online)
Rate this: bad
good
Please Sign up or sign in to vote.
I'm new to using LINQ. Basically I have a Employee Collection Object, which contains a number of employees. Each employee then has a Contact Collection as each employee could have a number of contact numbers/email. The link between the two is a ContactID. How would I go about using LINQ to retrieve some data from the Employee Collection and the rest of the data from the Contact Collection.
Not sure if how I have explains that will make sense to anybody else, but any feedback would be great.
Thanks
Posted 15-Apr-13 6:23am
RMB26254
Comments
Sergey Alexandrovich Kryukov at 15-Apr-13 14:39pm
   
What is the problem? Duplicates? Something else?
—SA
BillWoodruff at 17-Apr-13 4:00am
   
Are you saying each item in the Contact Collection within every instance of the Employee Class: is a ContactID ?

What exactly is the form, structure, type, etc. of the ContactID ?

1 solution

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

Solution 1

Hi,
This is an attempt to code your scenario.

class Program
   {
       static void Main(string[] args)
       {
           IEnumerable<Employee> empCollection = null;
 
           // populate the employee collection
           // now if you want to get primary contact of each employee

           var result = from e in empCollection
                        select new
                        {
                            EmployeeName = e.Name,
                            PrimaryContact = e.Contacts.Select(c => c.IsPrimaryContact).First()
                        };
           // result will be the IEnumerable<anonymoustype>, which contains EmployeeName and the associated primary contacts
       }
   }
 
   public class Employee
   {
       public string Name { get; set; }
 
       public IEnumerable<Contact> Contacts { get; set; }
   }
 
   public class Contact
   {
       public int ContactID { get; set; }
 
       public string EmailId { get; set; }
 
       public string Telephone { get; set; }
 
       public bool IsPrimaryContact { get; set; }
   }

Hope it helps Smile | :)
  Permalink  
v3

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

  Print Answers RSS
0 Sergey Alexandrovich Kryukov 495
1 Richard MacCutchan 275
2 Maciej Los 259
3 ManasKumarM 155
4 Frankie-C 125
0 Sergey Alexandrovich Kryukov 775
1 CHill60 415
2 Richard MacCutchan 405
3 Maciej Los 389
4 OriginalGriff 320


Advertise | Privacy | Mobile
Web04 | 2.8.150901.1 | Last Updated 17 Apr 2013
Copyright © CodeProject, 1999-2015
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