i am having this problem. i want to get the maximum value of a column's record in my database but when i use this code, it gives me an error.  saying

"The null value cannot be assigned to a member with type System.Int16 which is a non-nullable value type. ".

How can i solve this problem?  i dont want to use sql to get it. 

This is the code i wrote to get the maximum ID from the Oracleorganization database, 

 int x = synergy.OracleOrganizatations.Max(c=> c.OracleOrganizationID);

help needed urgently. 

Thanks

Kingsley

 it seems to be you are getting null value as there are no records in that table.

 int x =  (int?) synergy.OracleOrganizatations.Max(c=> c.OracleOrganizationID) ?? 0;

Hi friend,

First check what values you are getting. I think one of the value is null. Hence it is breaking. So before assigning it to int variable please check wheather it is convertable to int or not by using int.Tryparse() method as follows:

int tempX = 0;

int x = if(int.TryParse(synergy.OracleOrganizatations.Max(c=> c.OracleOrganizationID).ToString() , out tempX))? tempX : 0;

This should solve your error, If it does help you PLEASE MARK IT AS ANSWER.

thank you

 hey dude,

ur code is giving me some errors, "invalid expression term if"  and i cant figure out how to solve it.

could you please help me with your code?

thanks

 hey bro im still getting the same error when i use your code. Still need help. Thanks

 r u tried my suggestion?

 yes i did and i still got the same error that i had before.

still need help

Thanks 

try like this.

   var Id = (from v in db.TestTables select (int?)v.Id).Max() ?? 0;

 i cannot write LINQ code in a class library project. That is why i need a  C# version.

Hi,

Please try the following

int tempX = 0;

int x = (int.TryParse(synergy.OracleOrganizatations.Max(c=> c.OracleOrganizationID).ToString() , out tempX))? tempX : 0;

I have removed 'If'

This should solve your error, If it does help you PLEASE MARK IT AS ANSWER.

thank you

 still got the same error as before.

do u have any other idea on how to solve this?

Thanks 

Kingsley

 i meant to say  i got my initial error which is :

"The null value cannot be assigned to a member with type System.Int16 which is a non-nullable value type."

 i need serious help.

Thanks 

Kingsley

Hi,

I think you should post your code here because we dont know whats heppening into that MAX method. I will also require how are you taking column values.

I think we need to implement some loop logic here to get max value from it. So provid us input (i.e Column values) and output (i.e. Max() method). So we can provide exact solution

Thanks