IDataStore<TModel>.Max(Func<TModel, int?> selector, Predicate<TModel> predicate) Method

.NET Standard 2.x

Invokes a transform function on each row of the primary buffer in the DataStore and returns the maximum result value.

Namespace: DWNet.Data

Assembly: DWNet.Data.dll

Syntax

int? Max(Func<TModel, int?> selector, Predicate<TModel> predicate);

Parameters

selector Func<TModel, int?>

A transform function to apply to each row.

predicate System.Predicate<TModel>

A function to evaluate each row in the primary buffer for a condition.

Returns

Nullable<Int32>

The maximum value.

Examples

The following code example demonstrates how to get the maximum value for budget from the Department table which meets the criteria Departmentid > 3.

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

namespace Appeon.ApiDoc.IDataStore_GenericExamples
{
    public class MaxExample
    {
        private readonly SchoolContext _context;

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

        public void Example18()
        {
            // Instantiates a DataStore object with datawindow: d_department.
            var datastore = new DataStore<D_Department>(_context);

            datastore.Retrieve();

            // Gets the maximum value for budget where departmentid > 3
            // The largest budget that meets the criteria is 250000.00
            int? maxBudget = datastore.Max(d => (int?)d.Budget, d => d.Departmentid > 3);

            Console.WriteLine("Max Budget: {0}", maxBudget);

            /*This code produces the following output:
             
            Max Budget: 250000.00
            */
        }
    }
}

Example Refer To

Model Class: D_Department
DataWindow File: d_department