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

.NET Standard 2.x

Computes the sum of a sequence of long? 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

long? Sum(Func<TModel, long?> selector);

Parameters

selector Func<TModel, long?>

A transform function to apply to each row.

Returns

Nullable<Long>

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.IDataStore_GenericExamples
{
    public class SumExample
    {
        private readonly SchoolContext _context;

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

        public void Example4()
        {
            // 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
            long? sumvalue = datastore.Sum(m => (long?)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