How to use joins in MVC 5 using EF

Question

Hi

How can i use Inner join in MVC 5 and display in View i had put Query

var q = (from pd in db.tblRegistration
join od in db.tblCountry on pd.FkCountryId equals od.CountryId
orderby od.CountryId
select new
{
od.CountryName,
pd.FirstName,
pd.LastName,
pd.PhoneNo,
pd.PostalCode

}).ToList();

but in View how can i display plz help me?? i am new in mvc-5

thanks

Manas Mohapatra · Answer

Please add below code in view page: @model dynamic @{ ViewBag.Title = My View; } Index Not Stongly Typed @foreach (var blog in Model) { @ blog .Country Name @ blog .FirstName @ blog .LastName @ blog .PhoneNo @ blog .PostalCode }