sql Limit A LINQ Left Join To One Row Here is an example of using LINQ to return a List of all active Employees and their most current Mobile Phone number (if they have one). Check it out: var query = (from emp