Return empty string using Linq to SQL - Related table with no rows - ASP.Net MVC

Question

I have 1 to many relationship with the following tables - Person and Email. When using linq to sql and ASP.Net MVC, I'd like to show the first email or an empty string in my Person view using code like this: ``` <%= Html.Encode(Model.Emails.FirstOrDefault().EmailAddress) %> ``` In cases where there are no email rows, I receive a NullReferenceException. I can return null safe values from SQL by using a view or sproc, but I'd like to just stick with generic linq to sql objects bound to tables.

Accepted Answer

```
Model.Emails.Select(x => x.EmailAddress).FirstOrDefault() ?? string.Empty
```

Return empty string using Linq to SQL - Related table with no rows - ASP.Net MVC

Solution

Problem