Entity Splitting CRUD Operations

Vijay Prativadi
9y
3.7k
0
0

100

Article

Entity Splitting Select Operation

This article shows how to do entity splitting and how to do various data operations.

Here is the SQL Server table structure.

Start by creating an ASP.Net Web Application as shown in the following screenshot.

Now, cut columns from the employee details entity as shown in the following screenshot.

Now, paste them into the Employee entity.

Next, delete the Employee Details entity from the model.

Click No. Then a dialog box appears for "Delete Unmapped Tables and Views". The same can be seen in the following screenshot.

Do the the table mapping.

Webform1.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="EntitySplitting_SelectDataApp.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:GridView ID="GridView1" runat="server" BackColor="LightGoldenrodYellow" BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="None">
<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>
</asp:GridView>
</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 EntitySplitting_SelectDataApp
{
public partial class WebForm1 : System.Web.UI.Page
{
EmployeeDBEntities objEmpEntities = new EmployeeDBEntities();
protected void Page_Load(object sender, EventArgs e)
{
var query = from r in objEmpEntities.Employees
select new
{
r.FirstName,
r.LastName,
r.Phone,
r.Email
};
GridView1.DataSource = query.ToList();
GridView1.DataBind();
}
}
}

The output of the application looks as shown in the following screenshot.

Summary: In this operation, we saw how to do entity splitting and select data operation.

Happy coding!

Entity Splitting Insert Operation

In this operation, we will learn how to do entity splitting and later we will also learn how to do an insert data operation.

Here is the SQL Server table structure.

Create an ASP.Net Web Application as shown in the following screenshot.

Now, cut the columns from the Employee Details entity.

Next, paste them into the Employee entity.

Delete the Employee Details entity from the model.

Click no, then a dialog box appears for "Delete Unmapped Tables and Views". The same can be seen in the following screenshot.

Do the table mapping.

Webform1.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Entity_Splitting_Insert_Data.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="Insert 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 Entity_Splitting_Insert_Data
{
public partial class WebForm1 : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
}
protected void Button1_Click(object sender, EventArgs e)
{
using (var context = new EmployeeDBEntities())
{
var employee = new Employee
{
FirstName = "Steve",
LastName = "Robin",
Email = "[email protected]",
Phone = "123443223"
};
context.Employees.Add(employee);
context.SaveChanges();
}
}
}
}

The output of the application is shown in the following screenshot.

Summary: In this operation, we saw how to do entity splitting and an insert data operation. Happy coding!

Entity Splitting Delete Operation

In this operation, we will see how to do entity splitting and a delete data operation.

Here is the SQL Server table structure.

Create an ASP.Net Web Application as shown in the following screenshot.

Cut columns from the Employee details entity.

Paste them into the Employee entity.

Now, delete the Employee Details entity from the model.

Click no, then a dialog box appears for "Delete Unmapped Tables and Views". The same can be seen in the following screenshot.

Do the table mapping.

Webform1.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Entity_Splitting_Delete_Data.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" 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 Entity_Splitting_Delete_Data
{
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 empContext = new EmployeeDBEntities();
var empID = 1;
var emp = empContext.Employees.Where(a => a.EmpId.Equals(empID)).SingleOrDefault();
empContext.Employees.Remove(emp);
empContext.SaveChanges();
}
}
}

The output of the application looks as in the following.

Summary: In this operation, we saw how to do the entity splitting and a delete data operation.

Happy coding!

Entity Splitting Update Operation

In this operation, we will see how to do the entity splitting and a update data operation.

Here is the SQL Server table structure.

Create an ASP.Net Web Application as shown in the following screenshot.

Now, cut columns from the Employee Details entity.

Paste them into the Employee entity.

Delete the Employee Details entity from the model.

Click no, then a dialog box appears for "Delete Unmapped Tables and Views". The same can be seen in the following screenshot.

Do the table mapping.

Webform1.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="Entity_Splitting_UpdateData.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="Update" 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 Entity_Splitting_UpdateData
{
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 empContext = new EmployeeDBEntities();
int empId = 1;
var emp = empContext.Employees.Where(a => a.EmpId.Equals(empId)).SingleOrDefault();
emp.FirstName = "Jonny";
emp.Phone = "123423";
empContext.SaveChanges();
}
}
}