How to get related data from entity framework in ASP.NET MVC

See more:

ASP.NET

LINQ

MVC5

hi
I have an listing that have multiple listingmessages. I want to show which listingmessages the current user have written on a specific listing.

In sql I will have written this :

SELECT * FROM Listings INNER JOIN ListingMessages on Listings.ListingId = ListingMessages.ListingId WHERE ListingMessages.UserId = userID

But how do I do this in the entitiy framework.

Model for Listing :

public class Listing
   {

       public int ListingId { get; set; }

       [Required(ErrorMessage = "Angiv venligst en titel og udgave")]
       [Display(Name = "Titel & udgave")]
       public string TitleEdition { get; set; }

       public virtual ICollection<ListingMessage> listMessage { get; set; }

   }

Model for ListingMessages :

public class ListingMessage
 {
     public int ListingMessageId { get; set; }

     [Display(Name = "Send besked")]
     [Required(ErrorMessage = "Angiv venligst en besked")]
     public string Message { get; set; }

     public string UserId { get; set; }

     public virtual Listing Listing { get; set; }
     public int ListingId { get; set; }


 }

What I have tried in the controller :

What I have tried:

public ActionResult ProfileMessageListing()
        {
            var user = User.Identity.GetUserId();

            //var list = (from l in db.Listings
            //            join lm in db.ListingMessages on l.ListingId equals lm.ListingId
            //            where lm.UserId == user
            //            select l);

            //var list = db.Listings.Include(x => x.listMessage).Where(d => d.listMessage.Count > 0).ToList();

            var listmsg = db.ListingMessages.Where(d => d.UserId == user).ToList();


            var list = db.Listings.Where(s => s.ListingId == listmsg.);
            

            return View(list);
        }

Hope someone could give me a hint, I am really stucked!!