Check if Record Exists in Entity Framework
Use Any
:
if (isIpnValidated)
{
using (WebApplication1Entities db = new WebApplication1Entities())
{
if (db.Orderss.Any(o => o.Transaction == txnId)) return;
Orders order = new Orders();
order.UserId = userId;
order.Date = System.DateTime.Now;
order.Transaction = txnId;
order.Amount = Convert.ToDecimal(mcGross);
order.Email = payerEmail;
order.Country = residenceCountry;
db.Orderss.Add(order);
db.SaveChanges();
}
}
using (WebApplication1Entities db = new WebApplication1Entities())
{
var order = db.Orders.GetAll().Where(x=> x.Transaction == txnId).FirstOrDefault();
if(order != null) // update
{
//.....
db.SaveChanges();
}
else
{
// new
}
}