one table is Users and another table is Property Details Builders. i want to join thus tables according to username.here is my controller code:
var query = from u in db.Users
join s in db.PropertyDetailsBuilders on u.UserName equals s.UserName
where u.UserName == s.UserName
select new
{
u.UserName,
u.FirstName,
u.LastName,
u.Role,
s.SubscriptionName,
s.Subscriptions,
s.PropertySubTypeName
};
return View(query.ToList());
how to design my view?iam using viewmodel