Post
Ask Question

Delete Data Using EDMF to Cloud Database With Azure

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"

Create-a-cloud-database-in-WindowAzure.jpg

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

Create-a-Server-WebPage-in-WindowAzure.jpg

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

table-in-WindowAzure.jpg

Step 5: Insert some data into the table

Insert-Data-in-table-in-WindowAzure.jpg

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

Open-visual-studio-2010.jpg

Step 7: Add an EDMF item to the project.

Add-EDMF-item-to-visual-studio-2010.jpg

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

generate-from-database-in-visual-studio-2010.jpg

Step 9: Add a new connection.

Add-new-connection-in-visual-studio-2010.jpg

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.

connection-established-in-database.jpg

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

Choose-table-from-database.jpg

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

EDMF-created-in-visual-studio-2010.jpg

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:

out-put-of-the-application-in-visual-studio2010.png

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

output-of-the-table-in-visual-studio-2010.png

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

delete-data-from-table-in-visual-stdio2010.png

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

show-delete-data-in-visual-studio2010.png


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