Join table and take name into model MVC , LINQ, C#, Models : <p>Here is my Office model</p>

<pre><code>public class Office 
    {
        public int ID { get; set; }
        public string Color { get; set; }
    }
</code></pre>

<p>And here is my Worker model</p>

<pre><code>public class Worker 
    {
        public int ID { get; set; }
        public int OfficeID { get; set; }
        public string FullName { get; set; }
        [NotMapped]
        public string OfficeColor { get; set; }
    }
</code></pre>

<p>what I want is to get all workers with LINQ with OfficeColor the Color of the specified OfficeID color</p>
