Table splitting we split one table into two tables.
Step 1: Create a new web
application And install Entity framework.
Step 2: Add a class to the project. Give the Name as Student.cs. Write Below code.
Step 2: Add a class to the project. Give the Name as Student.cs. Write Below code.
namespace EFTableSplitting
{
public class Student
{
public int StudentID { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string Gender { get; set; }
public StudentContactDetail StudentContactDetail
{ get; set; }
}
}
|
Step 3: Add a another class to
the project And give the Name as StudentContactDetail.cs. And
write the below code.
namespace EFTableSplitting
{
public class StudentContactDetail
{
public int StudentID { get; set; }
public string Email { get; set; }
public string Mobile { get; set; }
public Student Student { get; set; }
}
}
|
Step 4: Add a class to the
project For the DBContext and give the name it as StudentDBContext.cs.
And Write below code.
using System.Data.Entity;
namespace EFTableSplittings
{
public class StudentDBContext : DbContext
{
public DbSet<Student> Student { get; set; }
protected override void OnModelCreating(DbModelBuilder _Modal)
{
_Modal.Entity<Student>()
.HasKey(c => c.StudentID)
.ToTable("Student");
_Modal.Entity<StudentContactDetail>()
.HasKey(c => c.StudentID)
.ToTable("Student");
_Modal.Entity<Student>()
.HasRequired(c => c.StudentContactDetail)
.WithRequiredPrincipal(c => c.Student);
}
}
}
|
Step 5: Add the database
connection string in web.config file.
<connectionStrings>
<add name="StudentDBContext"
connectionString="server=.; database=entitysplitting; integrated security=SSPI;"
providerName="System.Data.SqlClient" />
</connectionStrings>
|
Step 6: Now Add a web form And
pest below code in HTML code portion.
<asp:Button ID="FullDataWithContactDetail" runat="server" Text="GetStudent
Data with contact detail"
onclick="Button1_Click" />
<br />
<asp:Button ID="Button2" runat="server" Text="Get
Student Data"
onclick="Button2_Click" />
<asp:GridView ID="GridView1" runat="server">
</asp:GridView>
</div>
</div>
|
Step 7: Write the below code in code behind section
public partial class WebForm1 : System.Web.UI.Page
{
private DataTable GetStudentData()
{
StudentDBContext studentDBContext = new StudentDBContext();
List<Student> students = studentDBContext.Student.ToList();
DataTable dt = new DataTable();
DataColumn[] columns = { new DataColumn("StudentID"),
new DataColumn("FirstName"),
new DataColumn("LastName"),
new DataColumn("Gender")};
dt.Columns.AddRange(columns);
foreach (Student student in students)
{
DataRow dr = dt.NewRow();
dr["StudentID"] = student.StudentID;
dr["FirstName"] = student.FirstName;
dr["LastName"] = student.LastName;
dr["Gender"] = student.Gender;
dt.Rows.Add(dr);
}
return dt;
}
private DataTable FullDataWithContactDetails()
{
StudentDBContext studentDBContext = new StudentDBContext();
List<Student> students = studentDBContext.Student
.Include("StudentContactDetail").ToList();
DataTable dt = new DataTable();
DataColumn[] columns = { new DataColumn("StudentID"),
new DataColumn("FirstName"),
new DataColumn("LastName"),
new DataColumn("Gender"),
new DataColumn("Email"),
new DataColumn("Mobile"),
dt.Columns.AddRange(columns);
foreach (Student student in students)
{
DataRow dr = dt.NewRow();
dr["EmployeeID"] = student.StudentID;
dr["FirstName"] = student.FirstName;
dr["LastName"] = student.LastName;
dr["Gender"] = student.Gender;
dr["Email"] = student.StudentContactDetail.Email;
dr["Mobile"] = student.StudentContactDetail.Mobile;
dt.Rows.Add(dr);
}
return dt;
}
protected void Button1_Click(object sender, EventArgs e)
{
GridView1.DataSource = FullDataWithContactDetails();
GridView1.DataBind();
}
protected void Button2_Click(object sender, EventArgs e)
{
GetStudentData();
}
}
|
At this point, run the application. entitysplitting
database and Student table should be created by the entity
framework.
Step 8: Insert test data
using the following SQL script
Insert into Students values
('Munesh', 'Sharma', Male',m@g.com,5555555555)
Insert into Students values
('Rahul', 'Sharma', 'Male',R@g.com,333333333)
Insert into Students values
('Sara', 'vilium', 'Female',S@g.com,111111111)
Insert into Students values
('Mark', 'hash', 'Female',M1@g.com,2222222222)
Insert into Students values
('ABC', 'EFG', 'Male',A@g.com,6666666666)
|
Step 9: Run your application and check
your data that it is working properly or not.
