Hi,
This is my code :
public List 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 = nd.IsRead });
return query.ToList();
context.SaveChanges();
}
{
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 = nd.IsRead });
return query.ToList();
context.SaveChanges();
}
This execution is done but the updated result is not saving to database table
Please give me a correct code for that.
Thank you.

Bhushan BhasmePosted Oct 6, 2015, 12:51 AM
return query.ToList();
SivakumarPosted Oct 5, 2015, 10:17 AM
{
using (KiwiDbContext context = new KiwiDbContext(_ConnectionString))
{
NotificationData nd = new NotificationData();
nd = context.Notifications.Where(m => m.NotificationID == NotificationId).ToList();
nd.IsRead = true;
context.SaveChanges();
}
}
SivakumarPosted Oct 5, 2015, 9:23 AM
Bhushan BhasmePosted Oct 5, 2015, 8:47 AM
{
using (KiwiDbContext context=new KiwiDbContext(_ConnectionString))
{
NotificationData nd = new NotificationData();
nd.IsRead = true;
context.SaveChanges();
SivakumarPosted Oct 5, 2015, 8:39 AM
Bhushan BhasmePosted Oct 5, 2015, 8:19 AM
SivakumarPosted Oct 5, 2015, 8:02 AM
Bhushan BhasmePosted Oct 5, 2015, 7:19 AM
SivakumarPosted Oct 5, 2015, 6:32 AM
Bhushan BhasmePosted Oct 5, 2015, 1:32 AM
{
using (KiwiDbContext context=new KiwiDbContext(_ConnectionString))
{
NotificationData nd = new NotificationData();
nd.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 = nd.IsRead });
return query.ToList();