Insert and Select Data in Reverse Engineering POCO Generator

Vijay Prativadi
11y
6.6k
0
0

Article

Insert Data - Reverse Engineering POCO Generator

Introduction

This article demonstrates an interesting and very useful concept in Entity Framework.

Question: What is reverse engineering POCO generator?

In simple terms "It is a template that enables generation of entity classes by reverse engineering with the POCO generator".

Step 1: Create a new web application

Step 2: Adding a new Entity Framework reverse engineering POCO generator:

Step 3: The complete code of WebForm1.aspx is as in the following:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="InsertDataReverseEnggPOCOGenerator.WebForm1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<table>

<tr>

<td>

<asp:Label ID="Label1" runat="server" Text="Reverse Engg. POCO Generator - Insert Data"

Font-Bold="true"></asp:Label>

</td>

</tr>

</table>

<br />

<table>

<tr>

<td>

<asp:Label ID="Label2" runat="server" Text="Please Enter FirstName: " ForeColor="Brown"

Font-Bold="true" Font-Italic="true"></asp:Label>

</td>

<td>

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td>

<asp:Label ID="Label3" runat="server" Text="Please Enter LastName: " ForeColor="Brown"

Font-Bold="true" Font-Italic="true"></asp:Label>

</td>

<td>

<asp:TextBox ID="TextBox2" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<td>

<asp:Label ID="Label4" runat="server" Text="Please Enter Age: " ForeColor="Brown"

Font-Bold="true" Font-Italic="true"></asp:Label>

</td>

<td>

<asp:TextBox ID="TextBox3" runat="server"></asp:TextBox>

</td>

</tr>

<tr>

<asp:Button ID="Button1" runat="server" Text="Insert Data" OnClick="Button1_Click"

BackColor="Orange" Font-Bold="true" /><br />

<br />

</td>

</tr>

</table>

<br />

<table>

<tr>

<asp:Label ID="Label5" runat="server" Font-Bold="true"></asp:Label>

</td>

</tr>

</table>

</center>

</form>

</body>

</html>

Step 4: The complete code of WebForm1.aspx.cs is as in the following:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace InsertDataReverseEnggPOCOGenerator

{

public partial class WebForm1 : System.Web.UI.Page{protected void Page_Load(object sender, EventArgs e)

{

}

protected void Button1_Click(object sender, EventArgs e)

{

if (string.IsNullOrEmpty(TextBox1.Text) || string.IsNullOrEmpty(TextBox2.Text) || string.IsNullOrEmpty(TextBox3.Text))

{

Label5.Text = "Please Enter Some Values";

Label5.ForeColor = System.Drawing.Color.Red;

}

else

{

objEmployee.FirstName = TextBox1.Text;

objEmployee.LastName = TextBox2.Text;

objEmployee.Age = int.Parse(TextBox3.Text);

objEntities.TblEmployee.Add(objEmployee);

objEntities.SaveChanges();

Label5.Text = "Data Inserted Successfully";

Label5.ForeColor = System.Drawing.Color.Green;

TextBox1.Text = string.Empty;

TextBox2.Text = string.Empty;

TextBox3.Text = string.Empty;

}

#region Instance MembersMyDbContext objEntities = new MyDbContext();

TblEmployee objEmployee = new TblEmployee();

#endregion

}

Step 5: The complete code of web.config is as in the following:

<?xml version="1.0" encoding="utf-8"?>

</configSections>

</connectionStrings>

<system.web>

</authentication>

</providers>

</membership>

</providers>

</profile>

</providers>

</roleManager>

</system.web>

<system.webServer>

</system.webServer>

</entityFramework>

</configuration>

Step 6: The output of the application is as in the following:

Step 7: The inserted data output of the application is as in the following:

Select Data - Reverse Engineering POCO Generator

Question: What is reverse engineering POCO generator?

In simple terms "It is a template that enables generation of entity classes by reverse engineering with the POCO generator".

Step 1: Create a new web application

Step 2: Adding a new Entity Framework reverse engineering POCO generator:

Step 3: The complete code of WebForm1.aspx is as in the following:

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="SelectDataReverseEnggPOCOTemplate.WebForm1" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

</head>

<body>

<div>

<table>

<tr>

<asp:Label ID="Label1" runat="server" Text="Select Data - Reverse POCO Generator"

Font-Bold="true" Font-Size="Large" Font-Names="Verdana" ForeColor="Maroon"></asp:Label>

</td>

</tr>

<tr>

<asp:Button ID="Button1" runat="server" Text="Select Data" Font-Names="Verdana" Width="213px"

BackColor="Orange" Font-Bold="True" OnClick="Button1_Click" />

</td>

</tr>

<tr>

<asp:GridView ID="GridView1" runat="server" CssClass="grid" BackColor="LightGoldenrodYellow"

BorderColor="Tan" BorderWidth="1px" CellPadding="2" ForeColor="Black" GridLines="None">

No Records Found!</EmptyDataTemplate>

</asp:GridView>

</td>

</tr>

</table>

</div>

</center>

</form>

</body>

</html>

Step 4: The complete code of WebForm1.aspx.cs is as in the following:

using System;

using System.Collections.Generic;

using System.Linq;

using System.Web;

using System.Web.UI;

using System.Web.UI.WebControls;

namespace SelectDataReverseEnggPOCOTemplate

{

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 (MyDbContext objEntities = new MyDbContext())

{

GridView1.DataSource = objEntities.TblEmployee.ToList();

GridView1.DataBind();

}

Step 5: The complete code of web.config is as in the following:

<?xml version="1.0" encoding="utf-8"?>

</configSections>

</connectionStrings>

<system.web>

</authentication>

</providers>

</membership>

</providers>

</profile>

</providers>

</roleManager>

</system.web>

<system.webServer>

</system.webServer>

</entityFramework>

</configuration>

Step 6: The output of the application is as in the following:

Step 7: The selected data output of the application is as in the following:

I hope this article was useful for you.

Up Next

Ebook Download

View all

Diving Into OOP

Read by 5.3k people

Download Now!

Learn

View all

MVC Corporation

MVC Corporation is consulting and IT services based company.