Reader Level:
Article

Select Data - POCO Template

By Vijay Prativadi on Feb 12, 2013
This article demonstrates an interesting and very useful concept in Entity Framework.

Introduction

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

Question: What is POCO template?

In simple terms "It enables generation of code with a template based upon an Entity".

Step 1: Create a new web application

Output1.jpg

Step 2: Adding a new Entity Data Model Framework

OutputEDF.jpg

Step 3: Make Code Generation Statergy as "None"

Output2.png

Step 4: Select POCO Template


Output3.png

Output4.jpg

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

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

 

<!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">

    <div>

        <center>

            <div>

                <table>

                    <tr>

                        <td colspan="2" align="center">

                            <asp:Label ID="Label1" runat="server" Text="Select Data - POCO Template" Font-Bold="true"

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

                        </td>

                    </tr>

                    <tr>

                        <td colspan="2" align="center">

                            <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>

                        <td colspan="2" align="center">

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

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

                                <AlternatingRowStyle BackColor="PaleGoldenrod" />

                                <FooterStyle BackColor="Tan" />

                                <HeaderStyle BackColor="Tan" Font-Bold="True" />

                                <PagerStyle BackColor="PaleGoldenrod" ForeColor="DarkSlateBlue" HorizontalAlign="Center" />

                                <SelectedRowStyle BackColor="DarkSlateBlue" ForeColor="GhostWhite" />

                                <SortedAscendingCellStyle BackColor="#FAFAE7" />

                                <SortedAscendingHeaderStyle BackColor="#DAC09E" />

                                <SortedDescendingCellStyle BackColor="#E1DB9C" />

                                <SortedDescendingHeaderStyle BackColor="#C2A47B" />

                                <EmptyDataTemplate>

                                    No Records Found!</EmptyDataTemplate>

                            </asp:GridView>

                        </td>

                    </tr>

                </table>

            </div>

        </center>

    </div>

    </form>

</body>

</html>


Step 6:
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 Select_DataPOCOTemplate

{

    public partial class WebForm1 : System.Web.UI.Page

    {

        protected void Page_Load(object sender, EventArgs e)

        {

        }

        protected void Button1_Click(object sender, EventArgs e)

        {

            var query = from r in objEntities.tblEmployee select new

            {

                FirstName = r.FirstName, LastName = r.LastName, Age = r.Age

            }

            ;

            GridView1.DataSource = query;

            GridView1.DataBind();

        }

        #region Instance MembersCompanyEntities objEntities = new CompanyEntities();

        #endregion

    }

}

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



Output5.png



Step 8: The select data output of the application is as in the following:

Output6.png



I hope this article was useful for you.

Vijay Prativadi

Hey Everyone, It's Vijay. I am SDE mostly up on Microsoft Technologies. If you are thinking to know what I do mostly when at work. I get a chance to work upon few Microsoft technologies. All the way along my core tech... Read more

COMMENT USING