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
| NotificationID | int |
| description | string |
| UserId | int |
Table : ReadNotifs
| ReadNotifID | int |
| userid | int |
| NotificationID | int |
- These are the related models :
public class Notification
{
public Notification()
{
this.ReplyNotifs = new HashSet<ReplyNotif>();
}
[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<ReadNotif> 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
| NotificationID | description | UserId |
| 1 | Post 1 | 50 |
| 2 | Post 2 | 51 |
| 3 | Post 3 | 52 |
| 4 | Post 4 | 53 |
Table : ReadNotifs
| ReadNotifID | userid | NotificationID |
| 1 | 50 | 3 |
| 2 | 50 | 1 |
Result that i want to display in my view:
Table : Notifications
| NotificationID | description | UserId |
| 2 | Post 2 | 51 |
| 4 | Post 4 | 53 |
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.