Check if Record Exists in Entity Framework [duplicate]

Question

Could somebody please tell me how I check to see if a record exists, if it does exists then do nothing and if it doesn't then add the record to the database?

Please see my code below:

if (isIpnValidated == true)
{
    using (WebApplication1Entities db = new WebApplication1Entities())
    {
        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();
    }
}

I just want to ensure no possible duplication in the database.

Apologies, I want to ensure the txnId does not already exist. — iggyweb
– iggyweb, Commented May 14, 2014 at 12:00
Your question is entirely unrelated to ASP.NET MVC. Your code looks like you were using Entity Framework though. Did you mean EF 5? — chiccodoro
– chiccodoro, Commented May 14, 2014 at 12:01
I cannot use Any with this function, I can use Find, Add, AddRange, etc... but not Any unfortunately. — iggyweb
– iggyweb, Commented May 14, 2014 at 12:05
@iggyweb Then you're missing a reference to System.Linq. Add it to the top of your file, or get Resharper ;) — CodingIntrigue
– CodingIntrigue, Commented May 14, 2014 at 12:07

crucifery · Accepted Answer · 2021-06-07 22:08:16Z

76

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();
    }
}

edited Jun 7, 2021 at 22:08

crucifery

4885 silver badges12 bronze badges

answered May 14, 2014 at 12:05

sroes

15.1k1 gold badge58 silver badges75 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Maess Over a year ago

This assumes he doesn't want to update an existing record...

sroes Over a year ago

Yes, see his question: "if it does exists then do nothing"

iggyweb Over a year ago

I definitely don't want to update, only add if the txnId does not exist.

iggyweb Over a year ago

Can I please ask one more thing, how do I check to see if a order actually exists for a user and todays date, I've tried if (db.Orderss.Any(o => o.UserId == userId && o.Date == System.DateTime.Now)) return; but it doesn't appear to work.

sroes Over a year ago

What about if (db.Orderss.Any(o => o.UserId == userId && o.Date.Date == System.DateTime.Today)) return;?

|

Maess · Accepted Answer · 2019-10-31 16:07:19Z

3

using (WebApplication1Entities db = new WebApplication1Entities())
{
   var order = db.Orders.GetAll().Where(x=> x.Transaction == txnId).FirstOrDefault();
   if(order != null) // update
   {
      //.....
      db.SaveChanges();
    }
   else
   {
      // new
   }
}

edited Oct 31, 2019 at 16:07

answered May 14, 2014 at 12:05

Maess

4,16623 silver badges29 bronze badges

3 Comments

Maess Over a year ago

No, since he is going to work with order, no need to run the statement twice.

makinyelure Over a year ago

Do you realize you just queried all the orders in the table when you only need one? There is no need for the GetAll()

Vaheed01 Over a year ago

Besides he is getting all columns , There is no need to FirstOrDefault either , just use count()

Collectives™ on Stack Overflow

Check if Record Exists in Entity Framework [duplicate]

2 Answers 2

6 Comments

3 Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

3 Comments

Linked

Related