How to pass result of a "select * from" query to my app variables using entityframework

Question

0.00/5 (No votes)

See more:

VS2012

I am using entity framework for my database app where I need to run a query to my database using the app like this query

SQL

select top 1 * from table1 order by col1 desc, col3 asc

here my table1 has about four columns and I need to use all of those 4 columns in some other process for my app, I cant seem to get to pass all 4 column result to my variables at one time, normally i use a code like

C#

var col1= dbentity.Database.SqlQuery<string>(select col1 from table1 where col3=@param, new SqlParameter("param", param)).Single();

then i use col1 variable for my some other process. What i need is to run the select top 1 * from table1 and assign all the resulting columns to my variables.

Please help me with this. thanks in advance

(if ever this kind of question has already been answered a good reference link would be of big help :) )

Posted 28-Jun-14 6:33am

phyxian

Add a Solution

2 solutions

Solution 1

You should check out the class DataAdapter and look for examples of how to use it.

http://msdn.microsoft.com/en-us/library/system.data.common.dataadapter(v=vs.110).aspx

Escpecially look at the method Fill.

Posted 28-Jun-14 18:10pm

George Jonsson

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

phyxian · Accepted Answer · 2014-07-20T04:02:00

Thanks for that insight George, though I was able to find a way that better suits me :) I used this page as reference http://geekswithblogs.net/dotNETvinz/archive/2011/04/04/entity-framework---fetching-and-populating-the-data-in-the.aspx[^] where adding a public class to define the columns, you could also use a raw sql query and still assign the resulting columns of a single row to any variables or controls that accept value.