Delete Data Using EDMF to Cloud Database With Azure

Vijay Prativadi
12y
4.7k
0
0

Article

Introduction

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

Question: What is delete data from cloud database using Azure?

In simple terms "It enables to delete data from cloud database and maintain with help of azure".

Step 1: Create a cloud database named "Company"

Step 2: With the help of manage URL navigate to specific server page

Manage URL: etc6zpqnyc.database.windows.net

Step 3: Company database showing up in the database server page

Step 4: Create an employee table. The design mode of employee table looks like this

Step 5: Insert some data into the table

Step 6: Open visual studio 2010 and create an "ASP.NET Web Forms Application", as in:

Step 7: Add an EDMF item to the project.

Step 8: Choose "Generate from database" and click the "Next" button, as in:

Step 9: Add a new connection.

Step 10: Give the necessary server details for the connection and click on ok.

server-details-for-connection-in-visual-studio-2010.jpg

Step 11: The Connection is established; click the "Next" button.

Step 12: Choose the required table and click the "Finish" button.

Step 13: The created EDMF and design of data looks like this:

Step 14: The complete code of default.aspx looks like this:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="Default.aspx.cs" Inherits="DeleteDataEFAzureApp._Default" %>
<!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">
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <center>
        <div>
            <table>
                <tr>
                    <td colspan="2">
                        <asp:Label ID="Label1" runat="server" Text="Delete Data from Cloud Database with Azure"
                            Font-Bold="true" Font-Size="Large" Font-Names="Verdana" ForeColor="Maroon"></asp:Label>
                    </td>
                </tr>
                <tr>
                    <td>

                        <asp:Label ID="Label6" runat="server" Text="Please Enter Id" Font-Size="Large" Font-Names="Verdana"
                            Font-Italic="true"></asp:Label>
                    </td>

                    <td>
                        <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox>
                    </td>
                </tr>
                <tr>
                    <td colspan="2" align="center">
                        <asp:Button ID="Button2" runat="server" Text="Delete Data from Cloud Database" Font-Names="Verdana"
                            Width="301px" BackColor="Orange" Font-Bold="True" OnClick="Button2_Click" />
                    </td>
                </tr>
                <tr>
                    <td colspan="2" align="center">
                        <asp:Label ID="Label5" runat="server" Font-Bold="true" Font-Names="Verdana" ForeColor="Maroon"></asp:Label>
                    </td>
                </tr>
            </table>
        </div>
    </center>
    </form>
</body>
</html>

Step 15: The complete code of default.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 DeleteDataEFAzureApp
{
    public partial class _Default : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            TextBox4.Focus();
        }
        protected void Button2_Click(object sender, EventArgs e)
        {
            if (string.IsNullOrEmpty(TextBox4.Text))
            { Label5.Text = "Please Enter Some Values";
                Label5.ForeColor = System.Drawing.Color.Red;
            }
            else
            {
                CompanyEntities objCompany = new CompanyEntities();
                Employee deleteQuery; var id = int.Parse(TextBox4.Text);
                deleteQuery = (from r in objCompany.Employees where r.ID == id select r).First();
                objCompany.DeleteObject(deleteQuery);
                objCompany.SaveChanges(); Label5.Text = "Data Deleted Successfully";

                Label5.ForeColor = System.Drawing.Color.Green; TextBox4.Text = string.Empty;
            }
        }
    }
}

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

Step 17: The output of table data before deleting the application looks like this:

Step 18: Data entering output of the application looks like this:

Step 19: Deleted data showing on the cloud output of the application looks like this:

Up Next

Ebook Download

View all

Microsoft Azure Step by Step Guide

Read by 4.4k people

Download Now!

Learn

View all

MVC Corporation

MVC Corporation is consulting and IT services based company.