Select Data With Enums Via EDF Framework 5.0

Introduction

Today, in this article let's play around with one of the interesting and most useful concepts in Entity Data Model Framework 5.0.

In simple terms "It provides the flexibility to pull data using enums using the Entity Framework 5.0".

Step 1. Create a new web application.

Web application

Step 2. Add a new ADO.NET entity data model, as in.

ADO.NET

Model

Data Connection

Tables

Employee

Enum Type

Step 3. The complete code of WebForm1.aspx looks like this.

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="EnumEFApp.WebForm1" %>
<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head id="Head1" runat="server">
    <style type="text/css">
        .grid {
            margin-top: 50px;
        }
    </style>
    <title></title>
</head>

<body>
    <form id="form1" runat="server">
        <center>
            <div>
                <table>
                    <tr>
                        <td colspan="2" align="center">
                            <asp:Label ID="Label1" runat="server" Text="Select Data with Enums Types via Entity Framework 5.0"
                                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" />
                            </asp:GridView>
                        </td>
                    </tr>
                    <tr>
                        <td colspan="2" align="center">
                            <asp:Label ID="Label3" runat="server" Font-Bold="true" Font-Size="Medium" Font-Names="Verdana"></asp:Label>
                        </td>
                    </tr>
                </table>
            </div>
        </center>
    </form>
</body>

</html>

Step 4. The complete code of WebForm1.aspx.cs looks like this.

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace EnumEFApp
{
    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.Employee
                         where r.Location == LocationName.Nepal
                         select new
                         {
                             FirstName = r.FirstName,
                             LastName = r.LastName,
                             Age = r.Age,
                             Location = r.Location
                         }).ToList();
            GridView1.DataSource = query;
            GridView1.DataBind();
        }

        #region Instance
        MembersCompanyEntities2 objEntities = new CompanyEntities2();
        #endregion
    }
}

Step 5. The output of the application looks like this.

Output

Step 6. The selected data output of the application looks like this.

Framework