How to execute a multi-table query in code-first approach of Entity Framework?
===

If I want to execute a query that is based on joins between multiple tables, then how would this be coded in a code-first approach using Entity Framework 4.1? For example, I want to execute the following query:

    SELECT p.ProductId
	 , p.Name AS ProductName
	 , c.Name AS CategoryName
    FROM
	Products p
	INNER JOIN Categories c
		ON c.CategoryId = p.CategoryId