Data not updated to database

Question

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

Mukesh Kumar · Answer

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

Ravi Patel · Answer

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;

}
}

Data not updated to database

Insert Link

Embed YouTube Video

Table Options

Insert Image

Answers (2)