LINQ: Sequence contains no elements

LINQ to Entities doesn't support the Single() method. .First() needs to be used instead. By calling .First() an exception is generated if the sequence is empty. This blog post explains how you can still use the Single method on Entities!