Table Splitting Insert Data

Introduction

This article shows how to do table splitting and insert data operations.

SQL Server table structure

Create an ASP.Net Web Application as in the following:

Set up Entity Framework as in the following:

Cut columns from the Employee entity as in the following:

Paste them into the EmployeeDetails entity as in the following:

Add an association between Employee and EmployeeDetails as in the following:

Referential constraint

Webform1.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="TableSplitting_InsertData.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" OnClick="Button1_Click" />
</div>
</form>
</body>
</html>