How to join between two table in CE?

there are many type like Inner , Outer , full and cross join , you can find more here : http://asp-dotnet-mvc-tutorials.blogspot.in/

var result= from p in DbContext.Person join c in DbContext.Customers on p.PersonId equals c.PersonId where c.CountryName.ToLower() == "india" select p;