Display my SUM () appears on on Linq

Asked Apr 13 '15 at 20:50

Active Apr 13 '15 at 21:25

Viewed 44 times

I'm working right now to display the SUM to my LINQ but it will in no way apparent as it makes mistakes.

I've done like this

DataClassesDataContext db = new DataClassesDataContext();

var brugerPoint = db.brugeres.Sum();
    if (brugerPoint != null)
    {
        LiteralBrugere.Text = "<strong data-to='" + brugerPoint.ToString() + "'>" + brugerPoint.ToString() + "</strong>";
    }

EIDT i have try its here:

var brugerPointVB = db.brugeres.Where(brugerPoint => brugerPoint.point >= 0).Sum();
    if (brugerPointVB != null)
    {
        LiteralBrugere.Text = "<strong data-to='" + brugerPointVB.ToString() + "'>" + brugerPointVB.ToString() + "</strong>";
    }

after i have look her: c# / Linq sum where

EIDT EIDT NEW

var brugerPointAAA = db.brugeres.Sum(brugerPoint => brugerPoint.point);
    if (brugerPointAAA != null)
    {
        LiteralBrugere.Text = "<strong data-to='" + brugerPointAAA.ToString() + "'>" + brugerPointAAA.ToString() + "</strong>";
    }

edited May 23 '17 at 12:22

Community

asked Apr 13 '15 at 20:50

Jesper Petersen

What are you summing? I'm assuming `brugeres` is a table and not a collection of values. – D Stanley Apr 13 '15 at 20:52
@DStanley `brugeres` is the name of the lost where my users come from, – Jesper Petersen Apr 13 '15 at 20:54
I think you mean it throws exceptions. Which? – Gert Arnold Apr 13 '15 at 20:58
@GertArnold What you mean on this you say? – Jesper Petersen Apr 13 '15 at 20:59
You need to tell `Sum` which field (or expression) you are summing - something like `.Sum(b => b.Price)`. (replacing `Price` with the field you are summing) – D Stanley Apr 13 '15 at 21:12
@DStanley I add a new bit, is this what you mean? – Jesper Petersen Apr 13 '15 at 21:25
@JesperPetersen if `point` is the field you're summing than that looks reasonable. What errors/bad results do you get with that method? – D Stanley Apr 13 '15 at 21:29
@DStanley I get nothing back at all. :( – Jesper Petersen Apr 13 '15 at 21:33
`Sum` returns an `int` which can never be null, so your line `if burgerPointAAA != null` doesn't make any sense. – Philip Pittle Apr 14 '15 at 00:18

Display my SUM () appears on on Linq

0 Answers0