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.Personjoin c in DbContext.Customers on p.PersonId equals c.PersonIdwhere c.CountryName.ToLower() == "india"select p;