Loading

Return count of records

Ramco Ramco

Hi

In below Linq query i want to return no of records

var CostCenter = (from t in context.CostCenter
where t.CostCenterID == Convert.ToInt32(colum[5].ToString())
select t.CostCenter).FirstOrDefault();

Thanks

1 Reply

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

Sachin Singh4y ago
Accepted answer
you can use Count() extension method.
var costCenterId=Convert.ToInt32(colum[5].ToString());
var count=context.CostCenter.where(x=>x.CostCenterID ==costCenterId).Count();