Introduction
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"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<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 Raw SQL Query via EDM Framework"
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>
</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;
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;
GridView1.DataBind();
}
#region
Instance
MembersCompanyContext
objContext = new CompanyContext();
#endregion
}
}
Step 5: The output of the application looks like this
Step 6: The selected data output of the application looks like this