Display the data of parent table using data of child table

Subject : How to display the data of the parent table using the data in the child table in asp.net MVC 4

Hello,

I am trying to make a web application in C # Asp.net mcv 4.

I'm at the level where I would have to show data of a table "Notifications" based on the data in a table "ReadNotifs".

To illustrate the problem, here are more details:

I have two tables in my database: Notifications and ReadNotifs.

Table : Notifications

Table : ReadNotifs

- These are the related models :

public class Notification

{

public Notification()

{

this.ReplyNotifs = new HashSet();

}

[Key]

public int NotificationID { get; set; }

[Display(Name = "Comment")]

public string description { get; set; }

public int UserId { get; set; }

public virtual UserProfile UserProfile { get; set; }

public virtual ICollection ReadNotifs { get; set; }

}

public class ReadNotif

{

[Key]

public int ReadNotifID { get; set; }

public int userid { get; set; }

public int NotificationID { get; set; }

public virtual Notification Notification { get; set; }

}

Notifications and ReadNotifs tables are linked by the relationship One to many. So 1 Notification can be read (ReadNotif) several times.

I wish I could have this result :

Table : Notifications

Table : ReadNotifs

Result that i want to display in my view:

Table : Notifications

Remember : I would have to show data in a table "Notifications" based on the data in a table "ReadNotifs".

So, i want to display a Notification when NotificationID(of Notifications) != NotificationID (ReadNotifs).

Any idea how I should proceed?

Thank you very much.