Data not updated to database

Sivakumar

Hi,

This is my code :

public NotificationData ReadNotification(int memberId, int NotificationId)
{
using (KiwiDbContext context=new KiwiDbContext(_ConnectionString))
{
NotificationData nd=new NotificationData();

nd.IsRead = true;

var query = (from n in context.Notifications where n.MemberID == memberId && n.NotificationID == NotificationId && n.IsRead == false select new NotificationData { NotificationID=n.NotificationID, Message=n.Message, CreatedTime=n.NotificationTime, IsRead=n.IsRead });
return nd;

}
}

When I execute the data will be displayed but not saving to database

Please give me correct code for that

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Mukesh Kumar11y ago
Hi,

Here you are trying to get the data from database and return an id. But you don't have written any code for inserting the data. Write the code for inserting.

Hope this will help you.
thanks
0
Ravi Patel11y ago
public NotificationData ReadNotification(int memberId, int NotificationId)
{
using (KiwiDbContext context=new KiwiDbContext(_ConnectionString))
{
var notification = context.NotificationData.Find(NotificationId) ;
notification.IsRead = true;
context.SaveChanges();

var query = (from n in context.Notifications where n.MemberID == memberId && n.NotificationID == NotificationId && n.IsRead == false select new NotificationData { NotificationID=n.NotificationID, Message=n.Message, CreatedTime=n.NotificationTime, IsRead=n.IsRead });

NotificationId should primary key in databse table
0