Delete multiple database elements

Question

I have a action [GET] delete on my Webapi.

She removes one element, but would like it to remove all the elements that have a particular code.

How can I change my code to remove all?

My Code:

[HttpGet]
[Route("delete/{Con_codigo}")]
public HttpResponseMessage delete(int Con_codigo)
{
    try
    {
        var condel = bdprincipalEntities.Contatos
                         .FirstOrDefault(x => x.Con_codigo == Con_codigo);

        bdprincipalEntities.Contatos.Remove(condel);
        bdprincipalEntities.SaveChanges();

        var result = new HttpResponseMessage(HttpStatusCode.OK);
        return result;
    }
    catch (Exception)
    {
        return new HttpResponseMessage(HttpStatusCode.BadRequest);
    }
}

I know that my search returns only the first. I thought of changing from FirstOrDefault for Select, but he gives me the following error message:

Unable to convert from "System.linq.Iqueryable to Softluxapi.Models.

Updating:

The above method ends up removing all contacts, as I was asking, so I’m changing the question to, because even with the FirstOrDefault it removes various elements from the database?

Answer 1

Before anything I need to say have a GET endpoint to remove a resource doesn’t make the slightest sense semantically.

---

If you are using EF 6.0 or a newer version, you can use the method RemoveRange and simplify the code.

bdprincipalEntities.Contatos.RemoveRange(
    bdprincipalEntities.Contatos.Where(x => x.Con_codigo == Con_codigo));

If you use an older version, you will need to fetch all entities and then delete them one by one.

var contatos = bdprincipalEntities.Contatos.Where(x => x.Con_codigo == Con_codigo);

foreach(var contato in contatos)
    bdprincipalEntities.Contatos.Remove(contato);

bdprincipalEntities.SaveChanges();