Reader Level:

Select Data - POCO Template

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


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


Step 2: Adding a new Entity Data Model Framework


Step 3: Make Code Generation Statergy as "None"


Step 4: Select POCO Template



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

<html xmlns="">

<head id="Head1" runat="server">




    <form id="form1" runat="server">






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


                                    No Records Found!</EmptyDataTemplate>











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;



        #region Instance MembersCompanyEntities objEntities = new CompanyEntities();




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


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


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 I'm at work. I get a chance to work upon few Microsoft technologies. All the way along my core tec... Read more