Enhanced Delete Support in .NET 4.5

Introduction

Today, in this article let's play around with one of the interesting and most useful concepts in .NET 4.5.

Question: What is enhanced delete support?

In simple terms "It provides enhanced deleting support with various methods invocation as per the usage".

Step 1: Create a new "ASP.Net Web Forms Application", as in:

New-project-in-asp.net.jpg

Step 2: Create an Entity Data Model Framework and set it up with an appropriate database.

Step 3: The complete code of webform1.aspx looks like this:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="EnhancedDeleteSupportApp.WebForm1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">

<head id="Head1" runat="server">

    <title></title>

</head>

<body>

    <form id="form1" runat="server">

    <center>

        <div>

            <asp:GridView ID="GridView1" runat="server" BackColor="LightGoldenrodYellow" ItemType="EnhancedDeleteSupportApp.Employee"

                BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="None"

                AutoGenerateColumns="false" SelectMethod="GetData" UpdateMethod="UpdateData"

                AutoGenerateEditButton="true" AutoGenerateDeleteButton="true" DeleteMethod="DeleteData">

                <AlternatingRowStyle BackColor="PaleGoldenrod"></AlternatingRowStyle>

                <FooterStyle BackColor="Tan"></FooterStyle>

                <HeaderStyle BackColor="Tan" Font-Bold="True"></HeaderStyle>

                <PagerStyle HorizontalAlign="Center" BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue">

                </PagerStyle>

                <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite"></SelectedRowStyle>

                <SortedAscendingCellStyle BackColor="#FAFAE7"></SortedAscendingCellStyle>

                <SortedAscendingHeaderStyle BackColor="#DAC09E"></SortedAscendingHeaderStyle>

                <SortedDescendingCellStyle BackColor="#E1DB9C"></SortedDescendingCellStyle>

                <SortedDescendingHeaderStyle BackColor="#C2A47B"></SortedDescendingHeaderStyle>

                <Columns>

                    <asp:BoundField DataField="Id" HeaderText="ID" ReadOnly="true" />

                    <asp:BoundField DataField="FirstName" HeaderText="FirstName" SortExpression="FirstName" />

                    <asp:BoundField DataField="LastName" HeaderText="LastName" SortExpression="LastName" />

                    <asp:BoundField DataField="Age" HeaderText="Age" SortExpression="Age" />

                </Columns>

            </asp:GridView>

        </div>

    </center>

    </form>

</body>

</html>


Step 4: The complete code of webform1.aspx.cs looks like this:
 

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace EnhancedDeleteSupportApp

{

    public partial class WebForm1 : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

        }

        public IQueryable GetData()

        {

            return objEntities.Employee;

        }

        public void UpdateData(Employee employee)

        {

            if (ModelState.IsValid)

            {

                objEntities.Entry(employee).State = System.Data.EntityState.Modified;

                objEntities.SaveChanges();

            }

        }

        public void DeleteData(int id)

        {

            Employee obj_Employee = objEntities.Employee.Find(id);

            objEntities.Employee.Remove(obj_Employee);

            objEntities.SaveChanges();

        }

        #region Instance VariablesCompanyEntities objEntities = new CompanyEntities();#endregion

    }

}


Step 5: The output of the application looks like this:


Output-of-the-application-in-asp.net.jpg

Step 6: The data deleted output of the application looks like this:


Age-with-Output-of-the-application-in-asp.net.jpg

Step 7: The deleted data showing in database output of the application looks like this:


Delete-data-showing-in-DataBase.jpg


MVC Corporation
MVC Corporation is consulting and IT services based company.