ADO.NET

How to save data in database using entity framework before check if a record is exists?

How to save data in database using entity framework before check if a record is exists?, someone asked me to explain?

In this article, I will show you how to check if a record exists before insert in to the database using entity framework in c#.

You can use Any() because it will check soon as matches in records.

Entity framework-exists record:

    if (ModelState.IsValid)
            {
                if (db.UserLogins.Any(r => r.Name == userlogin.Name))
                {
                    TempData["message"] = "User name already exists";
                    return View(userlogin);
                }
                db.UserLogins.Add(userlogin);
                db.SaveChanges();
                return RedirectToAction("Index");
            }                        

You can also achieve using Count(), but it will check each row of the record before returning. So above one is best to check exists record.

if (db.UserLogins.Where(d => d.Name ==userlogin.Name).Count() > 0)
      {
      TempData["message"] = "User name alreadyexists";
       return View(userlogin);
          }
else{
          // save  record }

 record exists before insert in to the database using entity framework

Post your comments / questions