Select Data with Raw SQL Query via EDF Framework

Today, in this blog let's play around with one of the interesting and most useful concept in EDM Framework.
Question: What is select data with raw sql query via EDM framework?
In simple terms "It provides flexibility to pull off data with help of raw sql queries via EDM framework".
Step 1: Create a new web application


Step 2: Set up a new EDM framework with reverse engineering to the project


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

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


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "">

<html xmlns="">

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

    <style type="text/css">



            margin-top: 50px;






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





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

                        <asp:Label ID="Label1" runat="server" Text="Select Data with Raw SQL Query via EDM Framework"

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










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;

using SQLQueryEntityFrameworkApp.Models;

namespace SQLQueryEntityFrameworkApp


    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 = objContext.tblEmployees.SqlQuery("select * from dbo.tblEmployee ORDER BY Age DESC").ToList();

            GridView1.DataSource = query;



        #region Instance

        MembersCompanyContext objContext = new CompanyContext();




Step 5: The output of the application looks like this


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


MVC Corporation
MVC Corporation is consulting and IT services based company.