score:4

Accepted answer

For anyone else having a similar issue...

var paidmembers = (from c in db.Customer
                   where c.CustomerStatusID == 1
                   select c).Count();

var activemembers = (from c in db.Customer
                     where c.CustomerStatusID == 2
                     select c).Count();

new Series {
            Name = "Category",
            Data = new Data(new object[] {paidmembers, activemembers})
}

Related Query

More Query from same tag