Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

I am Jalpesh Vadgama a Microsoft MVP for Visual C# and BrainBench Certified ASP.NET Developer having more then 6 years of experience in .NET Technology.
Browse by Tags · View All
#ASP.NET 88
#DOTNET 87
BRH 79
ASP.NET 72
#.NET 52
C#.NET 48
DOTNET 47
ASP.NET 4.0 31
ASP.NET MVC 29
VisualStudio 27

Archive · View All
December 2010 16
July 2011 13
April 2011 13
April 2012 12
January 2011 12
June 2011 11
May 2011 11
May 2012 8
February 2013 7
January 2013 7

Execute TSQL statement with ExecuteStoreQuery in entity framework 4.0

Apr 8 2012 2:09PM by Jalpesh   

I was playing with entity framework in recent days and I was searching something that how we can execute TSQL statement in entity framework. And I have found one great way to do that with entity framework ‘ExecuteStoreQuery’ method. It’s executes a TSQL statement against data source given enity framework context and returns strongly typed result.

You can find more information about ExcuteStoreQuery from following link.

http://msdn.microsoft.com/en-us/library/dd487208.aspx

So let’s examine how it works. So Let’s first create a table against which we are going to execute TSQL statement. So I have added a SQL Express database as following.

Execute TSQL Staement with entity framework

Now once we are done with adding a database let’s add a table called Client like following.

Execute SQL staement with enity framework

Here you can see above Client table is very simple. There are only two fields ClientId and ClientName where ClientId is primary key and ClientName is field where we are going to store client name. Now it’s time to add some data to the table. So I have added some test data like following.

Extcute StoredProcedure with entityframework

Now it’s time to add entity framework model class. So right click project->Add new item and select ADO.NET entity model as following.

Entity Framework with TSQL Statement

After clicking on add button a wizard will start it will ask whether we need to create model classes from database or not but we already have our client table ready so I have selected generate from database as following.

Execute TSQL statement with ExecuteStoreQuery in entity framework 4.0

Once you process further in wizard it will be presented a screen where we can select the our table like following.

Entity Model with TSQL Stement

Now once you click finish it will create model classes with for us. Now we need a gridview control where we need to display those data. So in Default.aspx page I have added a grid control like following.

<%@ Page Title="Home Page" Language="C#" MasterPageFile="~/Site.master" AutoEventWireup="true"
    CodeBehind="Default.aspx.cs" Inherits="EntityFramework._Default" %>

<asp:Content ID="HeaderContent" runat="server" ContentPlaceHolderID="HeadContent">
</asp:Content>
<asp:Content ID="BodyContent" runat="server" ContentPlaceHolderID="MainContent">
    <h2>
        Welcome to ASP.NET!
    </h2>
    <p>
        To learn more about ASP.NET visit <a href="http://www.asp.net" title="ASP.NET Website">www.asp.net</a>.
    </p>
    <p>
        You can also find <a href="http://go.microsoft.com/fwlink/?LinkID=152368&amp;clcid=0x409"
            title="MSDN ASP.NET Docs">documentation on ASP.NET at MSDN</a>.
        <asp:GridView ID="grdClient" runat="server">
        </asp:GridView>
    </p>
</asp:Content>
Now once we are done with adding Gridview its time to write code for server side. So I have written following code in Page_load event of default.aspx page.
protected void Page_Load(object sender, EventArgs e)
{
    if (!Page.IsPostBack)
    {
        using (var context = new EntityFramework.TestEntities())
        {
            ObjectResult<Client> result = context.ExecuteStoreQuery<Client>("Select * from Client");
            grdClient.DataSource = result;
            grdClient.DataBind();
        }
    }
}

Here in the above code you can see that I have written create a object of our entity model and then with the help of the ExecuteStoreQuery method I have execute a simple select TSQL statement which will return a object result. I have bind that object result with gridview to display data.

So now we are done with coding.So let’s run application in browser. Following is output as expected.

Enity framework example with TSQL Statement

That’s it. Hope you like it. Stay tuned for more..Till then happy programming.

Shout it

Tags: #DOTNET, ASP.NET, #TSQL,


Jalpesh
15 · 11% · 3548
3 Readers Liked this
Jacob Sebastian Liked this on 4/9/2012 4:25:00 AM
Profile · Blog · Facebook · Twitter
Guru Samy Liked this on 4/9/2012 4:28:00 AM
Profile · Blog
Khyati Patel Liked this on 4/23/2012 12:55:00 AM
Profile · Facebook · Twitter
3
Liked
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

Your Comment


Sign Up or Login to post a comment.

"Execute TSQL statement with ExecuteStoreQuery in entity framework 4.0" rated 5 out of 5 by 3 readers
Execute TSQL statement with ExecuteStoreQuery in entity framework 4.0 , 5.0 out of 5 based on 3 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]