David Smith

David Smith

  • NA
  • 2k
  • 0

LINQ HELP

Jul 22 2012 3:39 AM
I am trying to create a dataset base upon the filters below. I am trying to come up a good linq that will return the dataset below. Ok let me explain
whats going on below. Can someone write a good linq to return the logic below

Below I am trying to determine the volunteer driver that will take neighbor to preferred zip codes.

Below is  list of volunteers, Each volunteers has there preferred zipcodes to drive to.
The output or return dataset should only contain the volunteers that will drive to preferred zipcodes they will driver
the neighbor to. If a neighbor choose a zipcode that a volunteer do not prefer, that volunteer will not be in the return dataset.


Volunteer Preferred Zipcodes to drive to
Mike Sam David Kelvin
11111 11111 11111 11111
22222 22222 22222  
33333 33333 33333 33333

44444   44444
  55555 55555 55555


Contacts wants only the volunteers that will take them to the zipcodes below
Neighbor- Jordan 
55555
44444
666666



The turn result set should only return Sam and Kelvin
































Answers (4)