Delete or remove records in .net core (c#) using linq.

Delete one Record:

If you want to remove only one record, use Remove method.

 

var user = _context.Users.Where(u => u.UserId == item.UserId) .FirstOrDefault();

    if (user!= null) {

        _context.UserRoles.Remove(user);

        _context.SaveChanges();

      }

 

Delete records in bulk:

If you want to delete records in bulk, user RemoveRange method.

  var userRoles = _context.UserRoles.Where(u => u.UserId == item.UserId);

  if (userRoles!= null) {

      _context.UserRoles.RemoveRange(userRoles);

      _context.SaveChanges();

        }