How to get the biggest number?

Question

5.00/5 (1 vote)

See more:

How get the biggest number?
i am trying to get the biggest number from a field in my database but is it strange because i use this simple code

C#

amenitiesExcel = dc.Hotel_Meals_TBLs.Select(Convert.ToInt32(a => a.CodeNumber)).Max();

and when i compile the query i receive this error:

Error   370 The type arguments for method 'System.Linq.Queryable.Select<TSource,TResult>(System.Linq.IQueryable<TSource>, System.Linq.Expressions.Expression<System.Func<TSource,TResult>>)' cannot be inferred from the usage. Try specifying the type arguments explicitly.

...the field "CodeNumber" in the database is a Nvarchar Datatype then is filled only with number and i need to store the biggest number in this field ,do you have any idea or suggestion how i can get the biggest number in this case

Thanks so much for the support.

Cheers

Posted 6-May-13 21:04pm

VisualLive

Updated 7-May-13 7:41am

Matt T Heffron

v2

Add a Solution

4 solutions

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)

Matt T Heffron · Answer 1 · 2013-05-07T07:38:00

Solution 3

You should try this:

C#

amenitiesExcel = dc.Hotel_Meals_TBLs.Max(a => Convert.ToInt32(a.CodeNumber));

or

C#

amenitiesExcel = dc.Hotel_Meals_TBLs.Max(a => int.Parse(a.CodeNumber));

Posted 7-May-13 7:38am

Matt T Heffron

Jameel VM · Answer 2 · 2013-05-06T21:21:00

Solution 1

You don't need to Convert to int. Just change your Query like below

C#

amenitiesExcel = dc.Hotel_Meals_TBLs.Max(a => a.CodeNumber);

Hope this helps

Posted 6-May-13 21:21pm

Jameel VM

Comments

VisualLive 7-May-13 3:27am

@James Moideen Thanks fof the reply i tried your suggestion but i received this error Error 369 Cannot implicitly convert type 'string' to 'Software2011.Room' ,sincerely if i dont convert it the MAX number that store is '999' instead in the field CodeNumber the MAX number is 1671 .

Jameel VM 7-May-13 5:26am

In which type you tried to return the linq query results?

Matt T Heffron 8-May-13 16:39pm

OP said the CodeNumber is Nvarchar, so using Max like this gives the lexicographically largest string "999".

Renju Vinod · Answer 3 · 2013-05-07T00:01:00

Solution 2

Try this

C#

int amenitiesExcel = 0;
amenitiesExcel = dc.Hotel_Meals_TBLs.Max(a => (int?)a.CodeNumber)?? 0;

Posted 7-May-13 0:01am

Renju Vinod

Comments

Matt T Heffron 8-May-13 16:42pm

OP said the CodeNumber is Nvarchar, so using Max like this will probably throw an exception on the cast.

Radoslav Dimitrov · Answer 4 · 2013-05-07T08:07:00

Solution 4

C#

int TExcel = 0;
TExcel = dc.Hotel_Meals_TBLs.Max(a => a.CodeNumber);

It is allready converted!

Posted 7-May-13 8:07am

Radoslav Dimitrov

Comments

Matt T Heffron 8-May-13 16:40pm

OP said the CodeNumber is Nvarchar, so using Max like this gives the lexicographically largest string "999".