IDataStore.Sum<TModel>(Func<TModel, decimal> selector) Method

.NET Standard 2.x

Computes the sum of a sequence of decimal values that are obtained by invoking a transform function on each row of the primary buffer in DataStore.

Namespace: DWNet.Data

Assembly: DWNet.Data.dll

Syntax

  public decimal Sum<TModel>(Func<TModel, decimal> selector);

Type Parameters

TModel

The type of a model class that matches with the current DataObject.

Parameters

selector System.Func<TModel,System.Decimal>

A transform function to apply to each row.

Returns

System.Decimal

The sum of the sequence of values.

Examples

The following code example calculates the sum of the values in the budget column.

using Appeon.ApiDoc.Models;
using DWNet.Data;
using System;

namespace Appeon.ApiDoc.IDataStoreExamples
{
    public class SumExample
    {
        private readonly SchoolContext _context;

        public SumExample(SchoolContext dataContext)
        {
            // Sets the data context
            _context = dataContext;
        }

        public void Example1()
        {
            // Instantiates a DataStore object with datawindow: d_department.
            var datastore = new DataStore("d_department", _context);

            // Retrieves rows from the database for datastore.
            datastore.Retrieve();

            Console.WriteLine("After Retrieve, Rowcount: {0}",
                datastore.RowCount);

            // Calculates the sum of the budget column
            decimal sumvalue = datastore.Sum<D_Department>(m => m.Budget);

            Console.WriteLine("The sum of Budget is: {0}", sumvalue);

            /*This code produces the following output:
            
            After Retrieve, Rowcount: 4
            The sum of Budget is: 790000.0000
            */
        }
    }
}

Example Refer To

Model Class: D_Department
DataWindow File: d_department

Applies to

.NET Standard

2.x