Sum of Field using Linq

Ramco Ramco

I am trying below code but not working



public Int32 subSum(Int32 Id)
{
try
{
var Result = (from t in context.Masters
where t.ID == Id
select new
{
SumCol1 = t.Sum(x => x.weight)
})SingleOrDefault;
return Result;
}
catch (Exception ex)
{
throw ex;
}
}

Thanks

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vishal Yelve4y ago

Accepted answer

Try this


var Result= (from t in Context.Mastsrs where t.ID == Id                                select t).Sum(x=> x.weight);

Vishal Joshi4y ago

Hello

Please try below linq query code.

var Result = (from t in masters where t.ID == Id && t.weight != null select t).Sum(x => (int)x.weight);

Ramco Ramco4y ago
Hi

It is giving error Cannot implicitly convert type int? to int. An explicit conversion exists

public Int32 subSum(Int32 Id)
{
try
{
var Result = (from t in context.Masters where t.ID == Id select t).Sum(x => x.SubWeight);
return Result;
}
catch (Exception ex)
{
throw ex;
}
}Thanks
+2