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

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



          }