Linq for taking values in variable through select query

Question

By googling i have made following select query to take max value of column ID.

 var result = (from rs in db.tradeFiles

                             select (rs.ID)).Max();

Please let me know is this a query is write for taking max value of column ID.

And for taking data out of it in variables i used foreach loop in following manner which is also not working.

foreach(var item in result)
           {

           }

Please let me know what is the mistake and what is the correct way to pull out the data out of select query.

Andrey · Accepted Answer · 2013-03-07 13:02:43Z

4

Result is the value itself, just use it, there is no need to iterate over it. If for example rs.ID column is int, then result will be the int.

answered Mar 7, 2013 at 13:02

Andrey

60.3k12 gold badges127 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Freelancer Over a year ago

If var result = (from rs in db.tradeFiles select (rs.ID)) this is the query, then how should i pull the individual ID value out of it?

Andrey Over a year ago

@freelancer from ... select construct always return a list or results (IEnumerable to be exact). There are methods that can narrow down that list to 1 item, like First and Single.

ken2k · Accepted Answer · 2013-03-07 13:03:39Z

1

Enumerable.Max can't be enumerated, it returns the value you're looking for.

answered Mar 7, 2013 at 13:03

ken2k

49.2k12 gold badges119 silver badges179 bronze badges

1 Comment

Freelancer Over a year ago

If var result = (from rs in db.tradeFiles select (rs.ID)) this is the query, then how should i pull the individual ID value out of it?

nichu09 · Accepted Answer · 2013-03-07 14:15:15Z

0

in result you will get one int value.because you are taking max value of the column. it will give one single result.if you want to take some specific id value ,you just make one where condition and select that value.like

(from rs in db.tradeFiles
where rs.id==1
select (rs.Name)); something like this..

answered Mar 7, 2013 at 14:15

nichu09

9022 gold badges16 silver badges45 bronze badges

Collectives™ on Stack Overflow

Linq for taking values in variable through select query

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related