Fetech single record in a table having duplicate values using Linq : I am stuck with below issue. Kindly help
[Table structure][1]

I want to fetch records as below
[ExpectedResults][2]
So the address should follow this order 
Mail
Home
Work

If Mail is present pick the record else if  check if Home is present then pick the record and else if  check if Work is present then pick that record.


  [1]: http://i.stack.imgur.com/1MGm6.jpg
  [2]: http://i.stack.imgur.com/b46Pd.jpg