Delete List of Item to Database using Entity Framework

Vijay Prativadi
9y
10.4k
0
0

Blog

Introduction

In this blog we will see how to delete list of items from database using entity framework.

Step 1: Create asp.net web application

WebForm1.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="DeleteList_EntityFramework.WebForm1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title></title>
</head>
<body>
<form id="form1" runat="server">
<div>
<asp:Button ID="Button1" runat="server" Text="Delete Data" OnClick="Button1_Click" />
</div>
</form>
</body>
</html>

WebForm1.aspx.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
namespace DeleteList_EntityFramework
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
EmployeeDBEntities context = new EmployeeDBEntities();
List<Employee> employees = new List<Employee>()
{
new Employee{EmpId=1},
new Employee{EmpId=2},
new Employee{EmpId=3}
};
foreach (Employee employee in employees)
{
context.Employees.Remove(employee);
}
context.SaveChanges();
}
}
}

Output of the application looks like this

Summary

In this blog we have seen how we can delete list of items to database using entity framework. Happy Coding!

Delete List of Item to Database using Entity Framework

Up Next

Disabling Automatic Validation on Save Changes Method in Entity Framework 6.0

Ebook Download

View all

C# Corner Ebook

First Example of java

Read by 2 people

Download Now!

Learn

View all

Learn Image

MVC Corporation

MVC Corporation is consulting and IT services based company.