LINQ weak relation between tables

Question

I have two tables with a weak relation. I need get a text value from one table using a key from another. I am using the following C# LINQ code:

City = rea.tRealEstateContact.tPostnumre != null ? rea.tRealEstateContact.tPostnumre.Bynavn : string.Empty

But when the key cannot be found in the table 1(tPostnumre), an exception is thrown.

How should I do this?

Answer 1

Isn't there a tPostnumreID in the RealEstateContact table that's used to link to tPostnumre?

 City = rea.tRealEstateContact.tPostnumreID != null ?
          rea.tRealEstateContact.tPostnumre.Bynavn : string.Empty