LEFT / RIGHT JOINs are a vital part of any querying system, and therefore if you can not express these kind of queries, you are likely going to have a struggle writing efficient code, or you are forced to use another querying API than Linq which makes the whole point of using Linq in the first place rather moot.