Delete multiple records using Entity Framework in ASP.Net using C# and VB.Net

Hi Destinykid,

Use Contains function.

Check this example. Now please take its reference and correct your code.

HTML

<asp:TextBox runat="server" ID="txtName" />
<asp:Button ID="btnDelete" Text="Delete" runat="server" OnClick="OnDelete" />
<asp:GridView runat="server" ID="gvCustomers"></asp:GridView>

Code

C#

protected void Page_Load(object sender, EventArgs e)
{
    if (!this.IsPostBack)
    {
        CustomerEntities entity = new CustomerEntities();
        gvCustomers.DataSource = entity.Customers.ToList();
        gvCustomers.DataBind();
    }
}

protected void OnDelete(object sender, EventArgs e)
{
    CustomerEntities entity = new CustomerEntities();
    List<Customer> customers = entity.Customers.Where(c => c.Name.Contains(txtName.Text.Trim())).ToList();
    entity.Customers.RemoveRange(customers);
    entity.SaveChanges();
    gvCustomers.DataSource = entity.Customers.ToList();
    gvCustomers.DataBind();
}

VB.Net

Protected Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs) Handles Me.Load
    If Not Me.IsPostBack Then
        Dim entity As CustomerEntities = New CustomerEntities()
        gvCustomers.DataSource = entity.Customers.ToList()
        gvCustomers.DataBind()
    End If
End Sub

Protected Sub OnDelete(ByVal sender As Object, ByVal e As EventArgs)
    Dim entity As CustomerEntities = New CustomerEntities()
    Dim customers As List(Of Customer) = entity.Customers.Where(Function(c) c.Name.Contains(txtName.Text.Trim())).ToList()
    entity.Customers.RemoveRange(customers)
    entity.SaveChanges()
    gvCustomers.DataSource = entity.Customers.ToList()
    gvCustomers.DataBind()
End Sub