Delete Stored Proc With Raw SQL Query Via EDF Framework

Introduction

 

Today, in this article let's play around with one of the interesting and most useful concept in EDM Framework.

 

Question: What is deleting Stored Procedure data with raw SQL query via EDM framework?

 

In simple terms "It provides flexibility to delete data using raw SQL queries via the EDM framework".

 

Step 1: Create a new web application

 

Output1.jpg
 

Step 2: Set up a new EDM framework with reverse engineering for the project

Output2.jpg

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

 

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

 

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

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

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

    <style type="text/css">

        .grid

        {

            margin-top: 50px;

        }

    </style>

    <title></title>

</head>

<body>

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

    <center>

        <div>

            <table>

                <tr>

                    <td colspan="2" align="center">

                        <asp:Label ID="Label1" runat="server" Text="Delete Stored Proc with Raw SQL Query via Entity Framework"

                            Font-Bold="true" Font-Size="Large" Font-Names="Verdana" ForeColor="Maroon"></asp:Label>

                    </td>

                </tr>

                <tr>

                    <td>

                        <asp:Label ID="Label2" runat="server" Text="Please Enter Employee Id" ForeColor="Brown"

                            Font-Bold="true" Font-Size="Medium" Font-Names="Verdana"></asp:Label>

                    </td>

                    <td>

                        <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

                    </td>

                </tr>

                <tr>

                    <td colspan="2" align="center">

                        <asp:Button ID="Button1" runat="server" Text="Delete Data" Font-Names="Verdana" Width="213px"

                            BackColor="Orange" Font-Bold="True" OnClick="Button1_Click" />

                    </td>

                </tr>

                <tr>

                    <td colspan="2" align="center">

                        <asp:Label ID="Label3" runat="server" Font-Bold="true" Font-Size="Medium" Font-Names="Verdana"></asp:Label>

                    </td>

                </tr>

            </table>

        </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;

using DeleteSPSQLQueryEntityApp.Models;

using System.Data.SqlClient;

using System.Data;namespace DeleteSPSQLQueryEntityApp

{

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

    {

        protected void Page_Load(object sender, EventArgs e)

        {

        }

        protected void Button1_Click(object sender, EventArgs e)

        {

            if (string.IsNullOrEmpty(TextBox1.Text))

            {

                Label3.Text = "Please Enter Some Values";

                Label3.ForeColor = System.Drawing.Color.Red;

            }

            else

            {

                int a = int.Parse(TextBox1.Text);

                objContext.Database.ExecuteSqlCommand("EXEC [dbo].[DeleteData] " + int.Parse(TextBox1.Text) + "");

                Label3.Text = "Data Deleted Successfully";

                Label3.ForeColor = System.Drawing.Color.Green;

                TextBox1.Text = string.Empty;

            }

        }

        #region Instance MembersCompanyContext objContext = new CompanyContext();

        #endregion

    }

}

 

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

Output3.png

 

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

Output4.png
 

I hope this article was useful for you.

 


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